User Community

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

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…

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

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

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

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

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