-
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
-
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
-
Automatically save Present filters to original discovery report
Hello Pyramid Community: I need the filters applied in "Present" mojo to be automatically saved in a original "Discovery Report" What is the more efficient way to configure this?
- Answered
-
How to Identify Pyramid Workflows that are Using Python Scripts
I have saved some generic Python scripts under Formulate > Scripts for users to utilize in their workflows. These Python utils are packaged as a WHL file, installed in Pyramid,…
- Answered
-
Log Storage Table in Pyramid Repository Database
I want to make the system logs and scheduled job logs visible to users by creating a dashboard in Pyramid. Is there a table in the Pyramid repository database that stores these logs? If so,…
- Answered
-
Fixed Static Parameter
Hi I'm new to Pyramid. How do I create in a report or KPI that has a fixed static parameter please. I want a report or KPI that counts a distinct value when a range is between 1 and 1000.…
- Answered
-
How to Limit Color Logic to a Single Column
In the screenshot, there is a color-coded "Med Surg Supply Cost / Equiv. Patient Day" measure, where the red-green split is based off the average of those values. How do I 1.…
- Answered
-
Formatting For Multi-Select Drop Down
Is there a way to make the search box in the multi-select drop down the same size as the slicer elements? It seems I can change the size of the elements but the search box stays the same size.
- Answered
-
How can I get the count of days for every month using Formulate (Custom column)?
I need to get the count of days in each month using the custom column option in a formula or any other ways in Discover. Does anyone have a solution for this?
- Answered
-
Difference in Filters
In Model, what is the difference between filtering on a table node and with a filter node? 1. Filter on the Table node: 2. Filter node after the month:
- Answered
-
Is there a way to get the modelId for the /API3/dataSources/addRolesToModel API without using the Admin Console?
The /API3/dataSources/addRolesToModel API requires an itemId as an input parameter. To obtain the itemId, I currently need to navigate through the Admin Console by going to Source Manager >…
- 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