Latest Activity

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

For certification

How will I log in to Pyramid Analytics for certification? And I can practice also.

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

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

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

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

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

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

Continuous date table

Hi All, I want to include a continuous date table in the model and I am looking for a function similar to Dates = CALENDAR(DATE(2019,01,01), Date(YEAR(TODAY()), 12,…

• Answered

Use one date to filter multiple fields

Hello, We are trying to make it so that a user can select a single date and it will filter the data similar to this where clause, replacing the ? with the date: where trans_date<=?…

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

Technical Questions on LLM/GenAI Architecture and Data Flow

Hello PA Team, I'm looking for a deeper technical understanding of how the GenAI/LLM integration works, specifically regarding data flow and security. I've seen the general documentation,…

• 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

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

Publication as an E-Mail - visuell flow

Hello everyone, after the latest major Release we often use the function to print a publication in the body of an e-mail. In some cases we have discoveries with many rows in it.…

• Answered