Latest Activity

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

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…

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…

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

YTD Formula in PQL

Hello everyone, I would like to create a formula (PQL) in an InMemory model that allows me to display the cumulative booking amount as Year to Date( YTD).…

• Answered

Date dimension from SSAS model not seen as a date in Pyramid

I'm connecting to an SSAS model with a date table. When I put the date column from this table into the filter, it gives me a regular drop down as if the column were a string.…

• Answered

ORIG Date format - strip time & convert to DATE column

I need some help in converting the datetime to DATE format and then keep it as a date column rather than a string. For example, we have this ORIG_DT which is a datetime and I use the DateFormat to…

• Answered

Slow Loading and Incorrect Previews in Presentation Viewer

Hello PA Team, I'd like to report a performance and rendering issue with slide previews in the Presentation viewer. The Issue: When opening a Presentation,…

• Answered

Pre-Query Slicer Popup Appears on All Slides

Hi Team, How can I prevent the pre-query popup from appearing on all slides when a slicer is set as a pre-query slicer on one slide? Thanks, Raveena

How to calculate "New vs Existing Buyers" with dynamic slicer context in PQL?

Hi everyone, I'm building a product launch dashboard and struggling with PQL filter context. I need to calculate several "New vs Existing Buyers" metrics that require comparing two different time…

How can we be able to get the recipient list in the email (Subscription and Publication)

Hi, Currently , while sending an email from Subscription and publication, we are unable to see the email recipients . Its difficult for the team to check with the teams whether the mail is received…

Scrollable Column Chart Visualization

Hi Everyone! I was wondering if it's possible to enable scrolling in a "Column Chart" Type discovery, the thing is that i might have a discovery with many categories and it's hard to understand…

• Answered

Availability of the Explore Server

Is or was the Explore server down this morning/at noon (CET)? I can't access it at the moment. I was able to demonstrate something to my colleagues from 10:30 a.m. to around 11:10 a.m.…