Latest Activity

PDF Export Looks Different Than Presentation View

Hi everyone, I’m running into an issue with formatting when exporting to PDF and wanted to check whether this is expected behavior or if I’m missing a setting.…

Secure/Masked Variables for Python Scripts

Hello PA Team, I have a request regarding security in Python/R scripts within Data Flows. Currently, I haven't found a secure way to pass sensitive credentials (like DB passwords or API keys) into a…

Pyramid and Elasticsearch

Hi Everyone, Is there a way to connect pyramid to Elasticsearch?

• Answered

Formulate with condition if measure is blank

I'm trying to subtract one measure from another only if the second measure has a value. If not, the formula should return empty. The below is not working.…

• Answered

Troubleshooting intermittent "Grey Screen" crashes in Content Explorer

Hello Community! I am running Pyramid version 2024.03.002. I am facing a recurring but inconsistent stability issue where the UI completely crashes to a "Grey Screen" while I am working.…

Parent-Child Sales Aggregation Issue

HI Let’s say we have a single DB table that has sales data at the state level and population data at the city level and is pulled into PYRAMID using the direct query model (CUSTOM QUERY TABLE).…

• Answered

Best Practice for a "Read-Only" Pro User in a CI/CD Environment

Hello PA Team, I'm looking for a best practice or architectural advice for a common CI/CD scenario that I'm struggling to implement. I need to configure a Pro user profile for my production…

Filter

Hi Team, How can I create a date filter for “previous working day”? I need it so that when a user logs in on Monday, the “previous day” filter returns Friday’s data (skipping Saturday and Sunday).…

• Answered

Bug Report - Calendar Slicer Disables Previous Full Week if Current Day Data is Filtered Out

Hello PA Team, I'm reporting a bug in the Calendar Slicer logic when using "Weeks" granularity. Scenario: I have a data model where data is filtered strictly "before today" (date < today()).…

How to Show Multiple Grand Totals without Repeating Measure Under Each Column

I want to show the current sales values per day for the current month with the grand total to the left. As show below. This is easy enough. However I want to add two extra (in yellow) grand total…

• Answered

Small Number Suppression for charts

Hello, I've gotten small number suppression with a custom string to work for matrix reports. However, I would like to know if there is way to have small number suppression and even complementary…

• Answered

Help: Alert Only on Sales > 0

Has anyone set up an Alert rule that triggers only when a minimum threshold is met or exceeded, even if the current dataset shows zero sales? I’m trying to create logic where an alert triggers only…

Is there a way to view the lineage data as a table ?

Hi, Is there a way to view the lineage data as a table ? The graphic linage view is very useful however when there many items, on the screen, it is not possible to comprehend the scope of the data…

• Answered

Parent-Child Sales Aggregation Issue

Hi Team, Lets say we have sales at parent level in base dataset1 and same is assigned to the corresponding children in dataset2. The total sales should remain 60 even when displayed at child level…

• Answered

Technical Questions on LLM/GenAI Architecture and Data Flow

Hello PA Team, I'm looking for a deeper technical understanding of how the GenAI/LLM integration works, specifically regarding data flow and security. I've seen the general documentation,…

• Answered