-
How to upgrade Pyramid 2020 to the latest version
Backup the underlying Pyramid 2020 content database Download the latest installer from https://www.pyramidanalytics.com/download Run the downloaded installer on all Pyramid 2020 Machines in the…
-
Default grid styles
Unsure if this has been fixed already (I'm on version 2020.18.055)- I have set the default grid type in my user defaults to be a flat mode grid. When I create a new discovery,…
- Answered
-
Group By option for grids
I have this report that shows allocation details for sales invoices, and I'm having a problem with transactions that cancel each other out; when we reverse a transaction in our system,…
- Answered
-
differences in standard deviation
Hi, I am working on a scatter plot and want to show the standard deviation. I have used three different methods, one from formulate which gives one standard deviation line (green line),…
- Answered
-
Parameter Format
Hi, As per the above, is it possible to change the default formatting of a parameter. I would like the values within the parameter to display as a %. The graph that the parameter interacts with has…
- Answered
-
Export to Excel - keep format of conditional formatted grid data
Hi, I'm trying to export the format of conditional formatted grid data to Excel. Columns and rows are formatted but not the data itself. Is there a way to do it?
- Answered
-
Multi Select (All) parameters
Multi Select (ALL) parameters. If you have this selected to all for a dashboard, after a while new elements are added however the (ALL) selection now only selects the elements which were there when…
- Answered
-
Display "all" in dynamic text when user selects all options in multiselect dropdown
We have a multiselect dropdown slicer that has a lot of values and when a user clicks the All button in the dropdown it is populating the dynamic text with all the options.…
- Answered
-
Using Variables with strings in Master flow
In a master flow I'm trying to call a REST API with part of a result of another REST API which is stored in a variable and the body would look something like {"key":…
- Answered
-
Selection set under Data Point not possible
Hi, I was trying to make a formula in which I wanted to use a data point in order to select both a measure and a dimension. For the dimension I wanted to use a set made on that dimension,…
- Answered
-
Log4J Remedies
As described in the previous blog on this subject, All versions of Pyramid do not contain the Log4J component with the critical vulnerability. However,…
-
Pyramid 2020.22 Released
Pyramid 2020.22 (Service Pack 2 for 2020.20) has been released to specifically mitigate the vulnerabilities found in the Log4J library. It also includes a collection of fixes for other bugs and…
-
Export to Excel
When using version 2020.20.586, I am no longer able to export a discovery to excel that contains totals. The output status shows as failed. Has anyone else experiences this issue and if so,…
- Answered
-
blank row in between different values
Is it possible to add blank rows in the tables? i.e. show 3 value measures, have a blank row then another 3 value measures?? So I have a table which shows increased, reduced, unchanged,…
- Answered
-
Log4J Security Vulnerability & Pyramid
There has been a critical notification of a potentially serious vulnerability in the Apache Log4J Java library used extensively in many Java applications world-wide, including Pyramid.…
-
Date slicers- show months in chronological order
I am wondering if there is something we need to do differently with the 2020 version of Pyramid compared to 2018, to make date slicers list months in the proper order?…
- Answered
-
Additions to conditional formatting
Hi I reckon this should be a simple one. Essentially it's a combination of the logical band with "positive negative" and the continuous linear function. Say I have a range going from -50 to +200.…
- Answered
-
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



