-
How to define a Design Theme for grids with a single-color background?
I'm afraid this is almost becoming a feature request, but maybe I've overlooked something... I would like to define a Design Theme that provides a completely single-color background for grids, e.g.…
- Answered
-
Calculating percentiles
Hi. I'm trying to get some percentiles (10,25,50,75,90) from my data. First, I tried with the percentile PQL function, but it has the restriction of being attached to the Dimension provided in the…
- Answered
-
Add a total line to a graph.
Hi I have a person wanting a chart they can do in Tableau. In the picture attached the graph shows this information from Pyramid. The chart shows above the sections a total line.…
- Answered
-
Alternate header row shading
I'd like to extend the alternate shading to the header row and not just the data rows. How do I go about that? I didn't see anywhere in formatting to do this.…
- Answered
-
How to add a CountRows Functionality in Pyramid
Hi Pyramid team, I would like to request the addition of CountRows functionality in Pyramid, similar to the feature in DAX (Power BI). Currently, we need a function that can count the number of rows…
- Answered
-
Date Range Slicer for Two Dates on a table
Hello, I have two dates in my table: Contract Date and Execution Date. I do not need to apply the date range slicers on both dates at the same time. I am using @Param to create the First and the Last…
- Answered
-
How do I select multiple reports or formulates to open at once
Sometimes we're editing a set of reports at once or multiple formulates, it would be helpful to be able to multi-select pieces of content and open them all at once instead of having to do it…
- Answered
-
Maps in Pyramid
Hi, I am struggling to create a map at a region level for kenya, there is region level data in the model as you can see in the first snip below, however when I try to use this data to build a map at…
- Answered
-
Using same parameter for same model but pointing at different tables
Hi All, I have a model that creates some simple data sets. They are linked by location but each of them also have a parameter of "online sale" where a column states 1 or 0.…
- Answered
-
Using measure as an attribute
While working on a report I came across this issue: I have a list of accounts/ For each account, I have the number of days in which it was recommended. “Count recommendation date” is a measure that…
- Answered
-
Sorting on Multiple Columns in Model
Hello Community, I have a use case where I need to sort a data set first on column A and then, retaining this order, on column B. From what I gathered, the Sort node allows only one column at a time.…
- Answered
-
Request for help with upgrade to JDK > 17.0.9 in Pyramid Build
I have installed Pyramid 2023.14.100 (September release) on an internal company server with an NCL license. I noticed that the JDK version of the build is currently 17.0.2.…
- Answered
-
How to create quantities sales report
Hi, I coudn't find answer on my question anyware so just creating new topic... I want to create a report for specific departments and subdepartments which will show me units sales of all product…
- Answered
-
Help needed with Box plot on Discover
Hi Pyramid Community, I was building a box plot to be used in a dashboard. However, for one of the attributes, the box plot seemed very off compared to the data points.…
- Answered
-
Help needed with Real-time data input and String search
Hello Pyramid Community, I wanted help with 2 items: 1) I am working on building a pyramid dashboard which simulates pricing decision. For this simulation,…
- Answered
-
Schedule Model Refreshes for a window of time
Hello, Is it possible to schedule a model refresh every M - F between 8 AM and 6 PM every 15 mins ? I know I can setup multiple schedules one every Mon every 15 mins,…
- Answered
-
PeriodstoDate (MDX) for InMemory (PQL) List
Hello Community, Is there any way to create a PeriodstoDate List for a InMemory Datamodell? It seems that InMemory Modell List's work only with PQL Code (look pic.1) pic.…
- Answered
-
Limitation on the Number of Items in the Favorites List
Hello PA Team! Problem Description: When adding more than 20 items to the favorites list, items beyond the 20th are not displayed in the list. Steps to Reproduce: Open the favorites list.…
- Answered
-
Discrepancy Between Displayed Rows in Visualization and Row Limit
Hi PA Team! When using a visualization with a large table (e.g., containing millions of rows), there is a discrepancy between the number of displayed rows and the established limit (e.g.…
- Answered
-
Replace no values with -, N/A, or no data
Hi! I've read the two threads on replace null with 0 and @Moshe Yossef 's thread on a join that looks like it has no data but the ifnull doesn't work because of no data in the fact table.…
- Answered
-
Where can I find the query text information in the Pyramid repository database?
I'm building a transaction logs dashboard and can get most details from the transactionView table, but I can't find the query text information. Is the query text stored in the Pyramid repository…
- Answered
-
Top 10 By Measure
Hi I am trying to resolve the following use case: I have a table in my DW that contains the a list of tables, their size in GB, dates and schema. I need to create a Discover that will show me the top…
- Answered
-
Leveraging Filters, Lists, Measures, etc.
I have three tables: kris_base, risks_base, and kris_risks_bridge. From my Risks_base, in a matrix, I'm pulling in the Risk Category field that gives me a listing of Risks.…
- Answered
-
Conditional formatting in tabular grid
I have a RAG column that has the values - Green, Yellow, Red. I want to replace these words in my tabular grid discovery with a green circle, when its Green, yellow circle, when Yellow,…
- Answered
-
Service_name values in server_log_requests table.
Hi PA team! The server_log_requests table in the Pyramid database contains information about user actions, but the values in the service_name column are not always clear.…
- Answered
Content aside
Category actions
Rate Pyramid today:
Please rate from 1-5 Stars and click on the Star
to register your feedback.
BARC 2025 BI and Analytics Survey
Pyramid 2024 LTS Release Notes
Pyramid 2023.15 Release Notes
Pyramid Tip of the Day
Pyramid Learning Hub
Pyramid Tutorial Videos
Pyramid Support
Pyramid Help