-
New Pyramid Release Framework
Starting in Q4-2024, Pyramid Analytics will offer a new software release framework, providing a choice between ‘Long Term Support’ and ‘Feature Version Support’ releases.…
-
Managing Bookmarks when Replacing a Present
Good day, We and our clients are equally thrilled by the Bookmarks feature. It's a fantastic addition to the user experience. We just have a question around the feature's management.…
- Answered
-
Is there a way to view expired conversations?
Hi All, Once a conversation is expired, is there a way to go back and see it. I can't seem to find anything in the documentation to explain how to do this or what happens to expired conversations.…
- Answered
-
How to get the SQL text of the executed SQL Query Node into a variable
I have an SQL query executing as an SQL Script Node in the Master flow. This SQL query is dynamic, as it inserts values like process_id and dynamic database_name,…
- 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
-
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
-
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
-
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
-
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
-
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
-
Pyramid Community Weekly Wrap Up - August 30th 2024
Dear Community, Back from my holiday. First thing on Monday I checked, if there are any new developments in the Community and YES! There are new Leaders in the Top Contributor Lists.…
-
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
-
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
-
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
-
Congratulations – Level 3 Certified: Immanuel Gem - Tigma Tech
Pyramid Certified Level 3 Announcement Tigma Tech grows their group of fully certified consultants at an impressive speed, this week I am happy to announce that Immanuel Gem also has completed his…
-
Pyramid Community Weekly Wrap Up - August 16th 2024
Dear Community, to our new members, thank you for signing up this week. This is the first step in your journey to get better reports and results from Pyramid.…
-
Congratulations – Level 3 Certified: Steve Devine - Camden AI
Pyramid Certified Level 3 Announcement Make that three fully certified Consultants at Camden AI. Growing the list of our Partners who have shown to be up to date with the latest addition in the…
-
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
-
Talk to your Data and See It on the Map
Conversational BI with Pyramid and Mapbox In a recent Webinar, our own @Joe Beaubien talked with Cris Byers from our Partner Mapbox about the potential of using GenBI in combination with their…
-
Congratulations – Level 3 Certified: Nanmaran Pandiduri - Tigma Tech
Pyramid Certified Level 3 Announcement To see Tigma Tech adding certified consultants at a regular basis is a great proof of the growing number of joint projects.…
-
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
-
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
-
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
-
Pyramid Community Weekly Wrap Up - August 9th 2024
Dear Community, "working behind the scenes week" means preparing some changes for the Community and the Learning Hub, where can't wait to publish the updates.…

