Questions & Answers Category

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…

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…

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

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

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…

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…

Images to be connected to a slicer

I have a presentation that shows the sales for 4 different companies, where the data is changed by a company slicer. Each company has their own logo. Is it possible on a presentation to have the logo…

• Answered

NLQ with Pyramid Internal Chatbot

Hello, Does using NLQ with the Pyramid Internal chatbot cause any data (semantic as well) to leave my network ? Or does this just use the semantic data from the model to answer my questions ?…

• Answered

Average invoiced shown instead of totals

I'm so lost here that I had to draw it by hand! haha. How do I do this properly? I'm actually just grasping at straws at the moment and need some expertise.…

Bug Report - Critical Excel Export Failures

I am observing consistent failures when attempting to Export to Excel, particularly with large datasets (e.g., ~300k cells). Notably, exporting the exact same report to PDF succeeds,…

Adjust width for text indicator

How do I adjust how much of the cell is for the indicator (text in this case) and how much is for the data? I get this block of empty space between my data and the indicator text that is a real pain.…

question about 'Distinct Count' total function by measure in Row Total

I have a report for active customer count by quarter , so one customer may appear in multiple quarters, in grand total, need to 'distinct count ' customers,…

• Answered

Query the Pyramid Database to find Data Interaction Setting Between Report Items

Over time while maintaining Presentations we have inadvertently unset the "Data Interaction" setting in the Interaction Manager (see attached screenshot);…

• Answered

Alternative to SQL Window Functions in PQL

I wanted to check if there is any alternative approach in PQL to achieve functionality similar to SQL window functions( for example Row Number() ). Any guidance, examples,…

• Answered

How to create dynamic range slicers that change min/max values based on another parameter?

Hi everyone, I'm trying to create a range slicer system where the slider's min/max values change dynamically based on a period type selection. My Use Case:…

• Answered