-
Custom Subtotals
Pyramid provides users flexibility over how to apply subtotals in a multi-dimensional matrix grid—using a simple point and click interface. Adding subtotals to a table or grid enables users to…
-
Parent-Child Hierarchy Security
Pyramid offers flexible, intuitive security for parent-child hierarchies, providing role-based control over how members are viewed and aggregated within hierarchies.…
-
Pyramid 2020.21 Released
Pyramid 2020.21 (Service Pack 1 for 2020.20) has been released and includes a few features and a collection of fixes for bugs and issues. Software The main installer files can be downloaded from the…
-
Measures/Dimensions caption translation
Hi all, I have this issue: I work for an italian company and all our database objects captions are in italian. I would like to translate the labels in english since we now have an USA company branch.…
- Answered
-
Export/Publish to google spreadsheets
Dear all, we're introducing google workplace in our company and are wondering whether it is possible to export/publish to google docs/spreadsheets directly. Best regards, Olaf
- Answered
-
Cell bars are displayed incorrectly in case the Grand Total is switched on
Dear all, the cell bars' lenghts are related to the maximum value (which will then have the bar filling the whole cell). If the Grand total is switched on this will not be taken in to account, i.e.…
- Answered
-
Calculate a dimension value (numeric)
I'm wondering if its possible to use a numerical dimension value in a sum? I have exchange rates in its own dimension table and want to use them to calculate original currency premium value into a…
- Answered
-
Presentation has no charts due to measures calculated
Hi I am needing some guidance on how to make calculated measures on variables in the discover available to a reportviewer. The reportviewer sees empty charts due to three measures create.…
- Answered
-
How Do I Use A Small Font Size In Questions And Answers?
Is there any way to use a small font size in questions or answers? That is, for the purpose of minor and possibly irrelevant information? I've checked the Markdown syntax but couldn't find anything.…
- Answered
-
Calculating a CLV measure
Has anyone calculated CLV on a 24 month contract period where there are customers who have been there longer than 24 months? Payments are monthly I am trying to get the average CLV per customer.…
- Answered
-
Scheduled Model Refresh not showing under Schedule Listing
Hi, As per the above mentioned, does anyone know why a model which has an active schedule on it wont display under the usual schedule listing in pyramid (via the settings cog > Schedules > Models).…
- Answered
-
How do you convert unix epoch time to time?
I have a time stamp, in UNIX epoch format, from a json feed "1637491969" How do I convert it to time in Pyramid?
- Answered
-
Date Parameter Slicer Issues
I’m new to Pyramid 2020, coming into it from BI Office and struggling to create parameters for date selection. In most of our BI Office reports we created an Advanced Data Set from a Date Hierarchy…
- Answered
-
Adding Hyperlink to text in Publish
Is it possible to add a text field with a hyperlink to a page in Publish? I've seen that you can add jump to hyperlink to a click action in Present, which is fine.…
- Answered
-
Error using an OLAP connection: "The 'MSOLAP' provider is not registered on the local machine..."
This error can occur when trying to run a query while the underlying data source is MS OLAP. The error indicates that the msolap130.dll file is not registered in the Pyramid environment.…
-
Rotate table header text?
Hi all I have a nice simple Matrix grid table, the header texts are all quite long, we cant avoid that, and they're required. I've been trying to see how to rotate the text in this manner (these are…
- Answered
-
interactions across column charts
Hi community. I have highlight-type interactions between two column charts, both of which feature measures from the same table (one is "value" and the other is "cost").…
- Answered
-
Analysis Services Dynamic Management Views as IMDB Data Source
Hi, I have an Excel file with that uses custom .odc files as data sources with a connection string to analysis services and MDX query to pull back DMV's.…
- Answered
-
Display weather on map with data points
Hello, We are trying to identify if there is a way to map customers address on a weather map to identify who would be affected by a storm. Do you have some ideas on how this might be accomplished.…
- Answered
-
Date Calendar Slicer Load Time Settings
I'm trying to find a way to set the load time settings for the Date Calendar slicer. There isn't an option (v2020) to set the load time settings. When the presentation loads,…
- Answered
-
Truncating decimal numbers in dimensions
I have a custom model that has currency exchange rates; the rates are decimal numbers with 4 places, in the sql query I have them truncated to only show 4 places In some of my discoveries,…
- Answered
-
Dynamic Text - Getting max used columns data
Hi all, As per the attached pic and above mentioned. Is it possible in the dynamic text editor to get the column number of the highlighted section, baring in mind that when changing filters the…
- Answered
-
Advanced slicer settings
We have just upgraded to a new version of Pyramid and I can see that there are now advanced settings in slicers I am selecting "remember user's last selection" but it won't stay selected!…
- Answered
-
Pyramid 2020.20 Released
Faster, more intelligent decisions for the enterprise. Version 2020.20 is the main release of Pyramid for 2021. It includes over 100 new named features together with numerous functional upgrades,…
-
Customize KPI Component Captions
In KPI definitions, I would like to define the caption for each component - So I don't have to use "value", "goal" and "status". I know in a KPI type discover I can change them,…
- Answered
Content aside
Topic actions
Rate Pyramid today:
Please rate from 1-5 Stars and click on the Star
to register your feedback.
BARC 2025 BI and Analytics Survey
Pyramid 2024 LTS Release Notes
Pyramid 2023.15 Release Notes
Pyramid Tip of the Day
Pyramid Learning Hub
Pyramid Tutorial Videos
Pyramid Support
Pyramid Help