-
Plotting values on line chart without aggregating
Hello Pyramid Community! I have plotted a line chart on monthly data as shown in attached screenshot. I want to remove dates from axis, instead have only year on x-axis (the way I have at the bottom…
- Answered
-
Ensure you have a Communication Plan and Measure Your Success
Guest Blog - Tip #5 (of 5) - Ensure you have a Communication Plan and Measure Your Success Navigating Business Intelligence Adoption in Your Organisation Ensure you have a Communication Plan Give…
-
Pyramid 2023.13 Released
Pyramid 2023.13, a service pack for Pyramid 2023, has been released. It primarily includes fixes and adjustments for critical vulnerabilities in 3rd party technologies.…
-
Congratulations – Level 3 Certified: Jeanre Van Wyk - BicycleBi
Pyramid Certified Level 3 Announcement Jeanre is the next fully certified Consultant from our Partner BicycleBI, covering the US market but working from South Africa.…
-
Publication | Report Triggers | Matrix vs Tabular Grid
We are needing to use Report Triggers on a publication that has Tabular Grids. Is there a reason that a Report Trigger will work with a Matrix grid and not a Tabular grid? Matrix Grid: Tabular Grid:…
- Answered
-
Last non empty function Modell Pro
Hello Pyramid Community, is it possible to select the function 'last non empty' for Measures in the modell pro designer? I want to show the last filled amount for the month.…
- Answered
-
Filters-Two Different Models
I have two dashboards from two different models where the sources for the dashboards are also different but both of the dashboards uses same filters . I want to use the filter in only one dashboard…
- Answered
-
Pyramid Community Weekly Wrap Up - July 5th 2024
Dear Community, I you have not done yet, read it, Gartner has dropped the second part of its annual Analytics and Business Intelligence Market Analysis.…
-
Wrapping legend values in a line chart
Hello Pyramid Community! I have a very simple query on legend text. I am creating a line chart and the dimension I am using has long text values. Is there a way we can wrap legend text(each value…
- Answered
-
Static value list for a dimension
Hello Community, I am building a report for a client. I need to create a matrix grid with monthly return values(Jan to Dec) for each year starting 2017.…
- Answered
-
How to show URL icons in matrix grid?
Hello, I have a requirement to show URL icons in matrix grid. I am able to show URL's under question as URL after doing MAX of the URL value but i need to show it as URL icons.…
- Answered
-
Making Custom Bins With Measures For Discover
So I have a measure that I want to use to make bins. Discover is able to have me create bins by rank, value, category, size, parameter, etc. Still, is there a way for me to create bins by custom…
- Answered
-
How to hide Hierarchy/Measures for specific Role Types (CLS)
This use case is around column level security and hiding certain columns based off of user role. I am trying to hide certain dimensions and measures depending on the role of the user that is looking…
- Answered
-
Pyramid Community Weekly Wrap Up - June 28th 2024
Dear Community, an I am back with my regular update, two weeks offline and boy have you been busy on the community. Plenty of new questions and ideas in the system.…
-
Gartner Magic Quadrant and Critical Capabilities Report for ABI Platforms 2024
Pyramid Analytics in the 2024 Gartner Magic Quadrant The Gartner Magic Quadrant™ for Analytics and Business Intelligence platforms report and the Critical Capabilities Report for Analytics and…
-
Custom Date Time Format with Time Zone
Is there a way to avoid interpretation of text in the custom date/time format? I am following the Pyramid help reference for DateFormat, where it explains that the masking is based on Java…
- Answered
-
Craft a Comprehensive Delivery Plan
Guest Blog - Tip #4 (of 5) - Craft a Comprehensive Delivery Plan Navigating Business Intelligence Adoption in Your Organisation A well-structured delivery plan is the backbone of successful BI…
-
Help regarding pyramid learning materials.
Hi, I'm a beginner with the Pyramid Analytics tool and I want to learn from scratch. Could you guide me on where to find materials or provide any guidance on how to start learning Pyramid?…
- Answered
-
Calculation based on Date Filter Range
I am looking for a calculation of a value divided by month; however, the number of months is dynamic depending on the overall date range that the user has set.…
- Answered
-
External IMDB Service Setup
We have been advised to set up the IMDB (in-memory database) service on a separate server for our multi-tenancy architecture. We're looking for detailed documentation or resources that describe how…
- Answered
-
Data Model - summarize column, unique row
Hello, I am running into a problem when developing my data model. I have two rows of data: ID AMT CREDITS COUNT_REG UID1 24775 18.00 1.00 UID1 -1286 18.00 1.…
- Answered
-
Model app missing from Explore Pyramid
Hello, I'm trying to work through the Data Modeler certification modules using explore.pyramidanalytics.com however the Model app isn't showing (see image). How do I get it added? Much Thanks, Sarah.
- Answered
-
Date comparison with DateDiff
Currently the date comparison of two dates can only be done with one format “yyyy-MM-dd HH:mm:ss”, but to work with another one the DateDiff function does not work correctly.…
- Answered
-
Count of last three months regardless of year
I have two filters year and month for few years where I want to find the count of members for the last three months . For say if am selecting year 2023 in the filter and the month December in the…
- Answered
-
Geocode Missing error
Hi, I got results on state wise data on discovery. But In presentation I getting geocode missing error in state region on united states country. how to resolve geocode location issue?
- Answered
Welcome to the Pyramid User Community
Pyramid User Community
