-
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
-
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
-
Remove top rows and preserve column headers
Hello. Is there a way (other than R or Python) to import an excel file, remove for example the top 10 rows, AND THEN promote the NEW TOP row (previously 11th row) to become the file headers.
- Answered
-
Creating a formulate based on the caption of the current member for a different dimension
I have two year year dimensions, lets say [A].[Year] and [B].[Year], I am trying to get the value of the B year based on the selected value of the A year in a slicer.…
- Answered
-
Advanced Totals: Only sum up current turnover of a year
Hey guys! Is it possible to only sum up the turnover of a current year? (Advanced Totals) In my discovery I've got two data types in the columns. One for the current year (2024),…
- Answered
-
Download Pyramid Discovers on a schedule to an OS folder
Hello, Just wanted to check if there is a way we can have the discovers run automatically and land an excel file into an OS folder (Windows or a Samba file share) Thanks Mad
- Answered
Got stuck with a report? Start a discussion or help others to move forward.