Questions & Answers Category

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…

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…

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…

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

Can I have list of all the cshids used to divert help button

• Answered

Hide or Unhide Slicers

Hi, Does anyone know of a way dynamically hide/ unhide slicers. I have a report where a user has multiple optional slicers e.g SKU Code, Barcode, Secondary SKU Code or Product Description.…

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

Changing the background or font of 1 cell

I have a table jam packed with information, but I need 1 cell (in my case it is a specific element within a dimension) to have a red background. How do I go about doing that?

"Last N Weeks" Function in Calendar Slicer is Misleading

Hello PA Team, I'm reporting a highly confusing behavior in the Calendar Slicer that appears to be a UI/UX bug. Steps to Reproduce: In Discover, add a date hierarchy to the Filters zone to create a…

• Answered

Using Regular Expressions to replace

Hello, Is there a way to use regular expressions to search and replace?

• Answered

Is there a way to show a measure only once when we have repeating dimension values?

We have a scenario where an insurance policy has multiple drivers. However, there is only one insurance premium at the policy level. If we add drivers to a discovery with a measure it replicates the…

• Answered

Minimum Date

Hi all, I'm looking to find the first time a customer quoted. I have a transactional table with customer dimension and a quote date dimension. I want to aggregate the dates by customer and return the…

• Answered

PYTD vs YTD Comparison , while Not Showing Dates

I have a request which i cannot seem to get working correctly without showing dates. I want to compare suppliers YTD spend vs PYTD spend, so only dates up to today for this year and last.…

• Answered

Binary Code to HTML in Pyramid

We have a BINARY column in Snowflake that contains file data in raw bytes . This column is being surfaced in our Pyramid data model. Can Pyramid natively convert this binary field into a renderable…

• Answered

End of Month custom column (EOMONTH formula)

Is there way to convert dates to End of Month date using formula like EOMONTH. In our system, we do not load data for Sundays or Holidays and I would like to use the EOMONTH formula to convert any…

• Answered

How do I upload my corporate font?

We have a corporate font, which isn't available on the standard fonts lift in Pyramid. How do I add it? It's on my computer, but not available on Pyramid.

• Answered