-
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