-
Object Renaming Does Not Work in the Search Panel
Hello PA Team, I found an issue with renaming objects in the Search panel. Steps to reproduce: Select any object in the Explorer, open its Metadata panel and copy its Item ID Reload the browser page…
- Answered
-
Pyramid for Pro License Type (2023) - Walkthrough question
Hello - I am doing the walkthrough shown above, and in 'Walkthrough 2: Building on the Model using Time Intelligence & Machine Learning', Step 2, when renaming the output column to 'outputDF',…
-
Need Help Creating Dynamic Previous Month Sales, Current Month Sales & Growth % in Pivot
Hi Team, I need help creating Previous Month Sales, Current Month Sales, and Growth % in a Pivot. I have: A Sales column A Sales Date column in yyyy-MM-dd format Initially,…
- Answered
-
Creating a group folder
Hello everyone, Is it possible to create a group folder for an existing role? We are currently restructuring our folders and want to avoid creating new roles or deleting existing ones.…
- Answered
-
Order Dimension Tables
Is there a way to order the tables in Pyramid? I want them in a specific order not alphabetical order.
- Answered
-
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.
- Answered
-
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…
- Answered
-
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
- Answered
-
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
- Answered
-
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…
- Answered
-
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
Got stuck with a report? Start a discussion or help others to move forward.