Questions & Answers Category

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

CSV Export Changes Column Order in Pyramid Discover/Presentation

Hi Team, Greetings. When exporting a CSV file from Discover or Presentation, the column order changes to a weird (non-alphabetical) sequence. I want the columns to export in the exact same order as…

• Answered

Conditional formatting on a switch list

I am trying to input conditional formatting on a switch list, but the conditional formatting won't dynamically update based on the measure selected from the switch list when the discovery is put into…

General question about feature requests

Maybe I'm just being stupid, but I can't reply to my own FR again: https://community.pyramidanalytics.com/t/x2yp3df The FR was tagged with “already exists” (which I doubt) at the same time.…

• Answered

Excel Exported Report Not Preserving Bold Header Formatting

We are facing a common issue across all reports when exporting to Excel. In the report view, all column headers are formatted in bold, but after exporting to Excel,…

• Answered

Export to Excel w/o totals/subtotals

Is there a way to export (print) a matrix grid to Excel without the totals/subtotals? I am aware I can remove them via discover, but for the viewers who don't have access to the discovery,…

• Answered

Dynamic Function for Total Year

Hi PA-Team, We currently use a formula that recognises the current month and year based on the current date and then outputs the entire year (e.g. January 2025, February 2025, ..., December 2025).…

• Answered

Data Type changes from Date to Datetime when reusing IMDB Models (blocking Multi-Select workflows)

Hello PA Team, I'd like to report an issue with Data Type preservation that creates a blocker when using the "Multi-Select" feature in Data Flow. The Scenario:…