Questions & Answers Category

Is there a PQL equivalent to the MDX Generate function?

I have a report that I am trying to build that will display a current year period and a prior year period. The user needs to be able to select a date range.…

Error in interaction between two calendar filters

Hi all, i have the following problem - error in interaction between two calendar filters. How to reproduce the problem: 1) Create a calculated measure. 2) Create a visualization with two date filters.…

[Bug] Unpivot Settings causes a gray screen in Model

Hi Pyramid Team, I can reproduce a UI crash in Model when opening the settings window for an Unpivot node. Scenario: ClickHouse > Table > Unpivot Steps to reproduce: Create a new model.…

Unique features of Pyramid Analytics?

Hello All, I am new to Pyramid Analytics. I wanted to explore it. How Pyramid Analytics is different from other tools/technologies available in the market? like Power BI or Tableau or Oracle BI?…

Using the API to return the PQL or MDX of a Formulate

I have a need to retrieve a list of formulas from our instance that includes the name, description and the actual logic for documentation purposes. I have figured out how to get the first two items…

Issues with $0 values exported as $ in Excel export of a Publication

Hi, I have measures in my publication that display values as $0. When I export the publication to Excel, the values appear as just $ without the 0. I have attached screenshots of both the publication…

• Answered

How can I proactively identify content that overloads runtime servers?

Hi Pyramid Team, I am looking for recommendations on how to proactively identify Pyramid content that may overload runtime servers. I had a case where opening a specific content item caused very high…

How to configure Dashboard slicers to work with Tabulate slicers?

I have a tabulate that contains 2 discovers, both filtered by a date. I grab one of the rows from the second discover and place it at the bottom of the first sheet and create some calcs.…

Preserving Matrix Layout in CSV Export from Pyramid Discovers

Hi, We are currently using a matrix-format report with subtotals in Pyramid Analytics. However, when exporting the report to CSV, the columns become jumbled/misaligned because the matrix layout is…

• Answered

PQL Formulates

Hello PA Team, We have written the following formula to count the number of active users: Code-Snippet Count( Filter( allMembers([Nutzer].[Benutzer ID]), ([Nutzer].[Benutzerstatus].[1], [measures].…

• Answered

Unable to Validate Data Flow Because of the SQL Script Node

Hello PA Team, I encountered an issue with SQL Script node in the Master Flow. Steps to reproduce: Create new model and dataflow In our case it’s a simple dataflow from excel file to an In-Memory…

• Answered

Sorting a Matrix in Presentation Breaks Hierarches

Hello PA Team, I found an issue with sorting hierarchies in presentation as a viewer. This problem exists in Version 2024.03.002. To reproduce this issue,…

• Answered

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