-
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.…
-
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…
-
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.…
-
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…
-
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
-
Incorrect handling of strings with different cases in in-memory
When loading data into IMDB, there is an issue with handling strings with different cases. If you create a table with identical strings but with different cases (e.g.…
- Answered
-
Extractions mensuelles
Bonjour, C'est mon tout premier post et je travaille en RH. J'ai une extraction mensuelle d'effectif que je souhaite envoyer chaque mois par mail. Donc par exemple en septembre je souhaite envoyer…
- Answered
-
Create an OR filter
Hello, I have a discover as below I want to create a filter that says either the first employee_flg = Y (table 1) or the second employee_flg (table 2) = Y Is it possible to do this in an discover ?…
- Answered
Content aside
Category actions
Rate Pyramid today:
Please rate from 1-5 Stars and click on the Star
to register your feedback.
2024 Gartner MQ for BI and Analytics
Pyramid 2023.12 Release Notes
Pyramid Tip of the Day
Discontinued OS Support for EOL Systems
Pyramid Learning Hub
Pyramid Tutorial Videos
Pyramid Support
Pyramid Help