-
Complex report table
The tutorial videos show only simple tables, which are perfect for dashboards. My customers need more complex table reports like the attached. Is it possible to build a this report by only one…
- Answered
-
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
-
Drill Down in an inner dimension of two nested ones
Dear Pyramid-Team, assuming the following situation: Two dimensions are nested in the rows of a table grid (e.g. Customers as outer dimension and Products as inner dimension).…
- 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
-
How to create date ranges and aggregate them?
Is it possible to create a date range with Start and End dates? If so, can we aggregate the range to show the values as Average or Sum?
- 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 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
-
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
-
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
-
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
-
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
-
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
-
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
-
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
-
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
-
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 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: 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 Hours 4/16 - Accessing Discover Reports on Mobile Platform.
Is there any limitations for Analytics and charts on the Mobile platform?
- Answered
Got stuck with a report? Start a discussion or help others to move forward.