-
SSAS Model showing NaN where a zero is expected
We have an SSAS model we use in Pyramid and when I look in Pyramid you can see that the value shows NaN. When I export it to excel the correct number shows which is zero.…
-
Bookmarks
Hi, There is any option to switch from one chart to another chart in the same page? like a bookmark? I want to create a button to switch a chart to MTD and other to YTD for example
-
Use the same Scale on Y axis and Secondary axis
How can I use the same scale in a chart?
-
Hidden Tables Delete Relationships. Is this a bug or a feature?
Hello PA Team, I’ve found that hiding tables in the data model causes their relationships to disappear. This may break existing content (reports, dashboards) that depend on those connections.…
- Answered
-
Duplicate Subtotal Values in Excel Export
Hi Team, When the subtotal is displayed in a separate column, why is the subtotal amount repeated on every detail row in the Excel export, even though it appears correctly only at the subtotal level…
-
Recurring Disk Latency Spikes While Pyramid In-Memory Service Is Running
Hello Pyramid team, I am investigating recurring disk read/write latency spikes on multiple Pyramid in-memory servers. The storage was moved to a higher-performance network SSD type,…
-
Tooltip "Default Value" vs Tooltip Drop Zones
I have two measures. I use measure one (Paid) in the Discover and Present (rounded to 1,000). I have original measure two (Paid Original) that I am dropping to Tooltip Drop Zone.…
-
Pyramid Email Subscription Delivers Both Excel and XML Files to Box
Hi Team, In a Pyramid model, we have an email subscription node configured to send an Excel file to a Box folder using the “Allow uploads to this folder” feature.…
-
Create a column chart with 2 measures
Its possible to create a column chart to show by day two measures? Current Value and PY value? Im facing issues because it split the chart in 2!
- Answered
-
Incorrect SQL generation in Calendar Slicer (Formula Picker) when using Last with Date granularity
Hello PA Team, I’m seeing incorrect SQL generation in the Calendar Slicer when applying function "Last" with Date granularity. The filter produces single-day matches per period instead of a full…
- Answered
-
Enabling Multiple Selections for a Presentation Column
Hi Team, Is it possible to enable multiple selections for a column in a presentation? Thanks, Raveena
- Answered
-
Average and Median for the Dimension Value in a Frequency Table
1. Given the following frequency table: How to calculate the Average and the Median of the Value? Is this possible at all? In Excel at least the average could be calculated via SUMPRODUCT(Value,…
- Answered
-
Error switching to Pyramid Internal LLM requires logout
Hi all! I’d like to report a bug regarding the LLM provider switching process. We have identified an issue where switching the default AI Engine from an external provider to "Pyramid Internal" causes…
- Answered
-
Recurring pyramidPrinter startup failure on Ubuntu 20 after application updates
Hi! We are experiencing a recurring issue that is consistently reproducible in versions 2024.X and 2025.X in our environment running Ubuntu 20. Steps to reproduce:…
- Answered
-
Edit an In-Memory Model's Target Table?
With an In-Memory Model target table, is it possible to edit the table's records? For an example, we have a user who takes daily snapshots of data. One of their historical dates has duplicates and…
- Answered
-
System table server_log_requests is not being populated after upgrade to version 2025.10.005.
Hi everyone! After upgrading to version 2025.10.005, the server_log_requests system table no longer records any entries. I checked the administrator console but couldn't find any relevant setting to…
- Answered
-
Why are Date fields exported as text in Excel but recognized as dates in CSV?
Hello Pyramid team, I have a question about Date/DateTime export behavior in Pyramid. After additional testing, I found the following behavior: If a Date/DateTime field has a model-level format…
-
Showing Forecasting Confidence Intervals in Crosstab
Hi everyone, I'm using the forecast feature in Discover. It shows a line chart, and for the forecasted periods it displays confidence intervals. Is there a way to show those confidence interval…
- Answered
-
Discover: Latitude and Longitude With Layered Maps
Hello, I am currently trying to create some layered maps in Discover that overlay store location bubbles on top of an area map. Unfortunately, it seems like layered maps do not support using latitude…
- Answered
-
Can we order the elements in the dimension tables how we would like and not in alphabetical order? In a discover have it grouped?
Can the elements in the dimension tables how we like and not in alphabetical order? When you open the discover it's always in alphabetical order the elements.…
- Answered
-
Sorting a measure using N-of-N
How do I sort the 2025 sales highest sales to lowest sales while keeping the subcategories unchanged. i want to sort them winin each subcategory.
- Answered
-
Execute JavaScript – Navigate to Specific Slide in Present
Hi Team, I'm trying to navigate to a specific slide in a Present Pro dashboard using Execute JavaScript action (not Jump To Slide). I wanted to share everything I've tried so far in case anyone has a…
-
Ai Driven Value creation - showing complete Json Value instead of the specific count
I am new to Pyramid. I was doing Use Case7. While doing 'AI Driven Value Creation" to add " Show population for each country". It's showing the entire JSON value.…
-
Dynamic “initial price” driven by a user-selected date filter
How do I calculate a dynamic “initial price” driven by a user-selected date filter? Background I have a receiving ledger with a few million rows of receiving entries.…
-
Is there a PQL equivalent to the MDX Generate function?
I have a report that I am trying to build that will display a current year period and a prior year period. The user needs to be able to select a date range.…
- Answered
Got stuck with a report? Start a discussion or help others to move forward.