Questions & Answers Category

For certification

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

• Answered

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

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

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

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

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

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

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

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

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

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

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

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

• Answered

Configuration of Tooltips Over Grid Columns

Hello. For some grid reports, we are using data model column descriptions to define data; Mousing over the column name in the Discover brings up the tool tip, showing the definition,…

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…

• Answered

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…