-
Change Value on horizontal axis based on variable value selected
I am trying to change dimension in horizontal axis of my graph based on the filter selected. For example, In graph I would like to change value in horizontal axis to created date year, quarter,…
- Answered
-
Greater Than Filtering in a Discovery
I am looking to do Greater Than filtering rather than Top N, where I want to include a set of values where any one of those values breaches a threshold,…
- Answered
-
How to import multiple Excel files in Data Modeler?
Is there a way to loop through multiple Excel spreadsheets with the same format and load the data into the in memory database?
- Answered
-
Changing Slicer Settings
I've noticed that when I change a slicer from Single Select Tree to Multi Select Drop Down that it places my Single Select Tree selection into the background and does not change the Slicer Type.…
- Answered
-
Do interactions work with Actions?
Can I use Interactions along with Actions? How does it work together?
- Answered
-
Can dynamic texts be used for creating click actions?
If I add text objects to a dashboard, can I add actions to them?
- Answered
-
Can you create Actions in Pyramid 2020 if the source is a SSAS model?
Are actions available for models built in SQL Server Analysis Services or is it just for Pyramid In-Memory Databases and SQL models?
- Answered
-
How to launch dashboards via Actions?
Is it possible to use an action to open another dashboard? For example, I’d like a summary dashboard to link out to a detail dashboard to drill down, essentially.
- Answered
-
Columns position in Discover Tablix
In smart discover how can i Switch between the columns position in tablix/Matrix
- Answered
-
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
Content aside
Category actions
Rate Pyramid today:
Please rate from 1-5 Stars and click on the Star
to register your feedback.
2024 Gartner MQ for BI and Analytics
Pyramid 2023.12 Release Notes
Pyramid Tip of the Day
Discontinued OS Support for EOL Systems
Pyramid Learning Hub
Pyramid Tutorial Videos
Pyramid Support
Pyramid Help