-
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…
-
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…
-
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…
-
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
-
Execution Solve Order Explanation
Morning all, Question around formulates and solve orders, we have had a couple of situations recently that has caused some issues that was resolved by adjusting the solve order on formulates.…
- Answered
-
Choose which 6 options are available on the popup
Within Present, when a user hovers over content there is a popup with 6 options to choose from: Can I change which items I want to display?
- Answered
-
Attach pdf as an attachment in email node
Hi, Is there a way to attach a PDF when sending an email? Thanks, Raveena
- Answered
-
Can Supabase be used for the Pyramid repository?
Hello, Is it possible to use Supabase (https://supabase.com/), which is a Postgres based database as a service, as the repository database for Pyramid Analytics?…
- Answered
-
Clarification regarding the model_name column
Hello PA Team! While exploring the Pyramid repository database, I came across something I'd like to clarify. I noticed that in the public.server_log_transaction table,…
- Answered
-
Dynamic formulation for full year / rolling 13 months
Hello everyone, We currently use the following formulations to ultimately display the rolling last 13 months ("Rollierend") or the entire year ("Gesamtjahr") via a button in the dashboard.…
- Answered
-
Adding Security to a Dimensions so only a small group of users can see and use it
Hi is there a way to have a dimension that only a small group can see and us it? I want to use a dimension in a report but I want to be the only person to be able to select it.…
- Answered
-
Best Practice for Isolating Self-Service Workloads in a Single Installation
Hello PA-Team, I'm looking for advice on a common enterprise challenge: how to ensure the stability of my critical corporate reports in a mixed-use environment where self-service users are also…
- Answered
-
When search for contains, how to specify?
Just say I have a dimension, "Model" and within Model there is an element "THIS IS AN EXAMPLE". I want to be able to search for "IS" without "THIS" being shown as a result.…
- Answered
-
Specify an indicator on a specific dimension's element.
Is it possible to use a KPI as an indicator only on selected elements within a dimension? Currently when I drag the KPI into the indicator, it will apply it to all the elements.
- Answered
Got stuck with a report? Start a discussion or help others to move forward.