-
Pyramid #DataTipoftheDay on Youtube
Video of the Day - Chatbot AI-Designer Our video of the day is about one of the new features in our latest release Pyramid 2023.11 Watch a 2 minute Demo of our Chatbot AI-Designer for Present and…
-
Tip of the Day - How to Replace Nulls with Zeros
How to Replace Nulls with Zeros This tip will walk you through how to manipulate a column within Model, to replace NULLS with Zeros, using the convert and replace nodes within a data flow.…
-
Tip of the Day - How to format a measure that is in seconds as hours minutes and seconds
How to format a measure that is in seconds as hours minutes and seconds Imagine you have a table column in a model that represents the duration of a period in seconds,…
-
How to use AI driven forecasting captions
How to use AI driven forecasting captions Pyramid allows you to add an AI driven forecast to your data based on a variety of algorithms. In the video below we show you how you can change the Captions…
-
How to: Create a dynamic set of dates
Question: How to create a dynamic set of dates During a recent discussion we got asked how to create a dynamic set of dates. There are two approaches to the tasks,…
-
Tip of the Day - Time Calculation Wizard
How to use the Time Calculation Wizard Time calculation wizard in Discover is designed to help users quickly and easily generate a variety of date time calculations to be used in your analysis,…
-
Pyramid #DataTipoftheDay - Google Search Hack
If only I could find everything on google... In a recent conversation someone asked for the best way to search for technical information on Pyramid. We offer a rich portfolio of support articles on…
-
Pyramid Data Tip of the Day - Metadata Tooltips and Clickthrough
Video of the Day – Metadata Tooltips and Clickthrough Our video of the day looks at metadata tooltips and click through in the Formulate app. When working in the Formulate script editor,…
-
Pyramid Data Tip of the Day - Hierarchical Support in Context Calculations
Our video of the day looks at the new hierarchical support for context calculations. Context functions let users build calculations that can only be resolved efficiently in the context of a report.…
-
Tip of the Day - Custom Totals by Measure
Video of the Day – Custom Totals by Measure Our video of the day looks at Custom Totals by Measure. Adding grand totals and sub-totals to your grids provides additional context and information.…
-
How to chart the Top 5 along with an aggregate of the Other
How to chart the Top 5 along with an aggregate of the Other In a Question in the Q&A Section of the Community User @Bruce Campbell asked how to combine the Top 5 of a list with an Aggregate of the…
-
How to Customize Totals in a Grid
How to customize the totals in a grid When you add totals to your Grid Pyramid automatically adds the sum of the columns. Sometimes this does not give you the optimal result.…
-
How to combine Values from different Measures in one chart
How to combine Values from different Measures In this question we got from a customer, the user tried to combine two values who are in different measures into one single chart.…
-
How to add subtotals for % Values to sum up to 100% in the category
Question: How to add subtotals for % to sum up to 100% for the category In a recent internal discussion we came across this question and wanted to share the solution to a broader audience.…
-
How to: Extract all data from Reports while removing report filters
How to Extract all data from reports while removing report filters Users might have Discover reports with existing filters (for example filtering the report to only display the top 10% of customers)…
-
How Pyramid Determines the Maximum Number of Rows in Reports and Queries
In Pyramid Analytics, managing data queries efficiently is critical for system performance and memory usage. Understanding Query Limit Settings The below settings are located in the Admin Console…
-
How to build Aggregate blocks for a Dimension
How to build Aggregate blocks for a Dimension When you are working with larger lists it is often necessary to define groups of elements into a single aggregated element that contains the totals for a…
-
How to use a Report or Page Trigger to generate a Publication when criteria are met
How to use a Report or Page Trigger to generate a Publication when criteria are met When you offer to trigger a report or page from your Publication, it only makes sense to start the process if the…
-
Resolving Issues with Real-Time Monitoring in Pyramid 2023
In Pyramid 2023, the "In Memory DB Status” feature, provides real-time monitoring of an In-Memory Database’s (IMDB) CPU, RAM, and HDD usage. If you encounter issues with this feature not displaying…
-
How to create a parameter driven list and search across multiple attributes
How to creating a parameter driven list and search across multiple attributes Imagine we have a long list of Values in a table. Now we want to filter out all lines that contain certain values but…
-
Tip of the Day - GenBI directly on SAP HANA and SAP BW
GenBI from Pyramid works with all sorts of Data Sources, in this video we look at the direct access to SAP HANA and SAP BW from the same dashboard. Pyramid does NOT use the ODP API to access and…
-
Tip of the Day - Dynamic dimensions and measures
How to create dynamic dimensions and measures that can be exchanged This tip & trick has been provided by @Michael Daun who created this solution while working on a project What to we want to achieve…
-
Tip of the Day - How to integrate content to Salesforce
How to integrate content from Pyramid into Salesforce Create Content in Pyramid In this document we are showing how you can embed a present object from Pyramid into Salesforce,…
-
Tip of the Day - Multi-lingual GenBI (spanish and german)
These Generative BI examples show how Pyramid can operate with multiple languages – both for the user and the database! Watch how users can talk in their native language (for example German and…
-
Tip of the Day - Five Key Elements of Gen-BI
A short explanation of the 5 foundational elements or pillars of Pyramid’s Generative BI strategy. It highlights what matters in implementing a Gen-BI capability and how Pyramid facilitates these…
Search for answers here or ask a question