-
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
-
Pyramid Community Weekly Wrap Up - Sept 13th 2024
Dear Community, the most important news of this week is the Announcement of the New Pyramid Release Framework. Starting in Q4-2024, Pyramid Analytics will offer a new software release framework,…
-
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
Content aside
Topic 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