User Community

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.…

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

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

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