-
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.…
-
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.…
-
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).…
-
Pyramid and Elasticsearch
Hi Everyone, Is there a way to connect pyramid to Elasticsearch?
-
Formula for measure filtered by a dimension
I have the fact and dimension tables below: SourceType dimension · SourceType 1 · SourceType 2 · SourceType 3 · SourceType 4 Event fact · Count of events I would like to 1) create a formula which…
-
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
-
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…
-
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
-
DistinctCount with filter
I have a fact table Impressions (ImpressionID, DeviceID, AudienceID) and two dimension tables Devices (DeviceID, DeviceType, etc) Audiences (AudienceID, AudienceType,…
- 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
-
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
-
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
-
Negative Duration in Task Manager / te_task table
Hello PA Team, I've encountered a strange issue where some tasks in the Task Manager display a negative duration. It looks like the task "ended" before it even "started".…
-
Favorited Folders Lose Hierarchy in Selection Dialogs
Hello PA Team, I'd like to report a problematic behavior that affects user experience when configuring actions. The Issue: When a folder is added to Favorites,…
-
Dynamic week formula
Hello everyone, I am looking for a solution to create a formula in an in-memory model that outputs the following: On Monday: all new orders received on last Friday, last Saturday or last Sunday.…
- Answered
-
Allow users to view model processing logs with out having admin rights
Hi, I'm looking for a way to allow users to view model processing logs with out having admin rights. Currently to allow users to view model processing logs I also must give them permissions to have…
- Answered
-
Multi-Highlight inconsistency / Bug
Morning all I have a query regarding the user of multi-Highlight mode and Multi-Select (Ctrl-Click Select) We have a present, which has multiple discovers with different dimensions depicted as graphs,…
-
Tooltip: URL as Dircet-Link and not as a text
Dear Community, is it possible to insert a URL, which is reffering to another Doashbaord, into Tooltip as a direct link? It would scale up the UX to click on the URL directly and not to copy and…
- Answered
-
Highlight Configured Domain Controller in LDAP Diagnostics
Hello PA Team, Continuing the topic: https://community.pyramidanalytics.com/t/g9y1nml I'd like to propose a usability enhancement for the LDAP System Diagnostics page.…
-
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
-
Workflow Versioning
Hello, Can I please be pointed to an article that goes into a little more depth on 'Save as New Version' in the model workflow? I'm trying to find more information on how the different versions of…
- Answered
-
Service Instance Memory Limits
Hello, I did not find anything in the community on service instance memory limits and hence posting this as an FYI in case others run into it. Had an issue where the users could not download a…
- Answered
-
custom visual access restriction
I am preparing a custom visual to show list of all the dashboards shared with the particular user group folder lying inside workgroup content folder. I need help in setting up restrictions within…
- Answered
Got stuck with a report? Start a discussion or help others to move forward.