User Community

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

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

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

Order Dimension Tables

Is there a way to order the tables in Pyramid? I want them in a specific order not alphabetical order.

• Answered

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

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

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',…