-
Dynamic formatting of table headers
Dear Pyramid-Team, when using OLAP-Cubes of MSAS, Pyramid is able to use the Measure formats defined in the cube. As far as I know, this definition can also be dynamic (e.g.…
- Answered
-
Relation between discoveries
My question is : At first, I create new discovery as A, in A I choose product codes using some filters and measure, as a result, I have 100 product with their sale.…
- Answered
-
Marketplace Scripts in Modeling and Formulate Modules
The Marketplace shows up in the Data Modeler module and the Formulate module. The question is what is the purpose of the marketplace in both modules, as they appear to be different?
- Answered
-
Can you change the headers of the columns?
When displaying data in a grid, the column headers are based on the attribute names in the model. Is there a way to rename these columns in the grid?
- Answered
-
How to add text in the header or footer of a publication?
I would like to add header and footer text to my publications. Is there a way to include titles and page numbers?
- Answered
-
Can you create statistical test on the fly such as Chi square test or F-test?
The example formula I am after is this: (expected-actual)^2/(expected) The challenge is the exponent value. How do I add that?
- Answered
-
PQL for dynamic text
Hi, I am struggling to write a PQL part for dynamic text to show the last day of the previous month based on current date. is it possible and anyone able to assist? many thanks
- Answered
-
Do publication triggers check slicer values, one by one?
If I have slicers configured for a publication, do the triggers check the slicer values as part of the evaluation process?
- Answered
-
Custom sort ordering - order by top N but leave "other" at bottom
Hi I have a table which shows the top N brokers, and then has the rest in an "other" bucket.. this works brilliant but I need to sort by the top N by premium but leave the "other" bucket at the…
- Answered
-
Change Discovery Column Label without Changing the Measure Caption throughout the system
Hello, For different discoveries we would like to have different titles on the columns. However, if we go to a measures properties and change the caption it changes it for all reports.…
- Answered
-
Snapshot of Incomplete Encounters
Instead of a rolling number of open encounters from mth to mth, I am trying to capture a snapshot of mth to mth of open encounters to show a trend. Any ideas on the formula?
- Answered
-
Publication Level Slicer for Dynamic Text on Publication
Is there any way to apply a slicer to dynamic text on a publication when you export or schedule the publication? Right now if I have half a dozen reports on a publication and I want those reports to…
- Answered
-
Unit of Measure
Hi! I would like to add a unit to each measure (e.g. "EUR" or "pcs") which can be shown or hidden, depending on the preference - is that possible? Thanks!
- Answered
-
Create a table in publish
In BI Office, we had the option of creating a formatted table in a publication (aligned with rows and columns) for supplemental information that did not come from a data discovery.…
- Answered
-
PA mobile version dashboard
Hi, We want to create mobile version dashboards. example. We have desktop version presentation. And now we must create mobile version on it as the same information.…
- Answered
-
Question about Sets and Display Folder in SSAS Cube
Hey guys, we would like to use sets and display folders in a SSAS cube. Unfortunately both doesn't really work correctly. First issue we're having is related to the set "LastWeek" which is shown in…
- Answered
-
Pyramid Office Hours 4/16 - Setting Data Based Colors
In the Color options, is there a way to "hard code" which colors I want for which values? For example, I want everything > 5 to be red, everything <= 5 to be green, can we do that?
- Answered
-
Pyramid Office Hours 4/16: Arrangement of Labels on Bubble Chart
If you labeled the points in the bubble chart, would the labels automatically arrange themselves to not overlap?
- Answered
-
Pyramid Office Hour 4/16: Can context calculations use free form text?
Can you have user defined formulas using free form text when creating context calculations
- Answered
-
Pyramid Office Hours 4/16: How do you view the underlying query for a Discover Report?
Could you show how to view the mdx?
- Answered
-
Pyramid Office Hours 4/16: Creating Animated Visualizations
Do you have an option of a play button on a scatter plot?
- Answered
-
Pyramid Office Hours 4/16: Using advanced analytics in the Discover Module
We had two questions on this topic: Is it possible to obtain the model diagnostics? for example, how do we identify which products have been assigned to each cluster? Generally in Linear Regression,…
- Answered
-
Pyramid Office Hours 4/16: If the visualization theme is changed, does the query run again?
If the visualization theme is changed, does the query run again? or is it only a visual?
- Answered
-
Pyramid Office Hours 4/16 - Accessing Discover Reports on Mobile Platform.
Is there any limitations for Analytics and charts on the Mobile platform?
- Answered
-
Folder & sub-folder in Measure group
Hi I would like to create a subfolder in a measure group - is that possible? If I do that, all other folders disappear and all KPIs are shown without folder (see image). thanks!
- 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