-
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
-
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
-
Pyramid Installation with Service Account
Hello, When executing the unattended installer for IMDB the systemctl service and few folders inside /opt/Pyramid were created with the user "Pyramid". In our environment we must use only a service…
-
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
-
Is there a way to get the current logged in user?
I want to retrieve the current logged in user. The API Gets details for the current user. (pyramidanalytics.com) returns "devservicerw" as the current user,…
- Answered
-
Free Text Parameter interacting with Present content
Hello I have the following use case issue that I cannot resolve. I need to place a free text numeric input field onto a present and get that to interact with a Discover to act as a filter.…
- Answered
-
Calculating a Rolling Average Containing Empty Values
I noticed that whenever a cell is empty, Pyramid excludes it from the average. For example, if week1 = 1, week2 = 0, week3 = 5, Pyramid excludes the week 2 element from the calculation (i.e.…
- Answered
-
Publication Performance
I have a 5 page Publication with over 300 dynamic text elements and 4 Discovers. I work in Higher Education and this is an academic program profile that looks at 5 years of data for a degree major.…
- Answered
-
YTD and Prior YTD Measures
Desired Outcomes: I want to perform month-over-month analysis, comparing prior year-to-date (PYTD) figures with current year-to-date (CYTD) figures, and calculate the difference for each month.…
- Answered
-
how to ALTER in-Memory DB table and add new columns?
i have a large model that i don't want to wipe out and rebuild. i was hoping to learn syntax for sql script to "alter table [tableName] Add [tableName].[newColumn] char(8)" type of command.…
- Answered
-
Rolling average on a switch list
I have a discovery which is driven by a switch list containing two parameters. I would like to be able to apply a rolling average on each of the values when selected,…
- Answered
-
A quirk when installing Pyramid on Linux - Host Name Issue
We ran into an odd issue with Pyramid installation on Linux (Ubuntu). The installation was failing for no good reason. And there is no point in delving into the logs as the solution was found.…
- Answered
-
Loading present via URL with filters and targets….but cross model mapping needs to be tailored
I have been expanding a dashboard that’s really resonating with our internal users. When opening the “present” directly it lands with a date filter using “current date”.…
- Answered
-
Error When Adding Web Panel In Present
When I try to add a link to the web page illustration in Present, I keep on getting a error message as seen in the attached image. When I was following the Pyramid Help Page for Web Panels https:…
- Answered
Got stuck with a report? Start a discussion or help others to move forward.