-
Order Dimension Tables
Is there a way to order the tables in Pyramid? I want them in a specific order not alphabetical order.
-
Time Intelligence - Trading Calendar injection
i am looking for a way to let the Time intelligence function use my customer's trading calendar instead of the Gregorian Calendar.
-
Filtering Based off of Measures and Totaling
I have a report that needs to be built where two of the measures that I am looking at, cannot equal 0 when they are added together. I created a new column to total them so I only have to filter on…
-
Enable email templates
Hi Team, Can we enable a specific email template for one workgroup without making it the default for all workgroups? Thanks, Raveena
-
How to remove border in mini-tab
Hi Team, Is there a way to remove the border in mini-tab. Thanks, Raveena
-
Group Dimension Elements
Hello, How can I group in the report some elements? I have a field with A, B, C, D, E and F, and I want to create an extra field with value XX when field 1 is a, B or C,…
- Answered
-
Pyramid MHTML File Support and Format Retention
Hi Team, Does Pyramid Support MHTML files if so how we can retain the format? Thanks, Raveena
-
Pyramid Learning Hub Help
My colleague sent an email to learninghub@pyramidanalytics.com on Monday and then on Tuesday after recieving no response, he created a support ticket only to be told "Our technical support team…
-
For certification
How will I log in to Pyramid Analytics for certification? And I can practice also.
- Answered
-
Bringing in slicers as columns in Drill Down report
Hi, Can we configure an action on a Present so that, when it navigates to a Discover via actions, the slicers are passed through as columns in the destination Discover? Thanks, Raveena
- Answered
-
Exporting Multiple Discovers to a Single Excel Sheet
Hi, I want to collate multiple discovers onto a single page and export them into one Excel file. The export should appear as shown here, where each table represents a separate discover.…
- Answered
-
Exporting Multiple Discovers to a Single Excel Sheet
Hi, I want to collate multiple discovers onto a single page and export them into one Excel file. The export should appear as shown here, where each table represents a separate discover.…
- Answered
-
Conditional Formatting Not Working
I am encountering an issue with conditional formatting not applying to cells that use the INDEX(MATCH()) excel formula. The formatting works correctly in Tabulate mode,…
-
Export to Excel
Hello, I am trying to export a Publication to Excel and want to maintain the layout of my page. Specifically: I have three reports/grids on a single Publication page, but when exporting to Excel,…
- Answered
-
DateDiff documentation says "dy" for days, but Custom Column only accepts "dd"
Hello PA Team, I found an inconsistency between the PQL documentation and the actual behavior of DateDiff in a Custom Column. https://help.pyramidanalytics.…
- Answered
-
Model Mapping between OLAP Cube and InMemory
Hello everyone, my aim is to map a slicer over two different models. One is a OLAP Cube and the other one a InMemory model. In both models I use the exact same Slicer "Buchungskreis ID" And also the…
- Answered
-
How do I categorize a column into groups?
I am trying to build a formulate to categorize our bank products and bucket them together. What syntax or method should I use? CASE( CONTAINS([product], “Checking”), “Checking”, CONTAINS([product],…
- Answered
-
Cascading slicers as multiple tree selection
Hello everyone, We have a dashboard with a slicer for cost centres. The sales organisation should cascade on this so that only the cost centres of the selected sales organisation are shown.…
-
Only primary Y-axis shall be colored...
Dear Community, I like to have a simple combined chart: "SALES by PRODUCT CATEGORY" as stacked column on the primary Y-axis "MARGIN" as line chart on the secondary Y-axis So, it should look like this.…
- Answered
-
Filter Context Manipulation: Removing Filters from a Measure
Hi PA team, We would like to implement the following calculation: We have a list of products, and we want to create a distinct count of these products.…
- Answered
-
How can i get total number of presents and models in pyramid for version 2025.01.004 using pyramid sql repository.
Hi everyone, We are running Pyramid in a single‑tenant deployment on our own VMs, and I am trying to generate daily stats for: total active Models total active Presents This is to help us track…
- Answered
-
Customizing - Pyramid Homepage
Hello everyone, We are currently designing our own homepage in Pyramid to better tailor it to the needs of our users. The latest reports and favourites should enable them to quickly find the most…
- Answered
-
Microsoft Intune Pyramid iOS App configuration
Hi there, does the iOS App support Configuration in Microsoft Intune? Customers wants to prefill Pyramid Server URL over the configuration in Intune. https://learn.microsoft.…
- Answered
-
YTD Formula in PQL
Hello everyone, I would like to create a formula (PQL) in an InMemory model that allows me to display the cumulative booking amount as Year to Date( YTD).…
- Answered
-
Date dimension from SSAS model not seen as a date in Pyramid
I'm connecting to an SSAS model with a date table. When I put the date column from this table into the filter, it gives me a regular drop down as if the column were a string.…
- Answered
Got stuck with a report? Start a discussion or help others to move forward.