-
Tip & Trick Pre-Query Slicers
Pre-query Slicers allow users to set the slicer selections for specified slicers and parameters upon opening the Discovery report, before the query is loaded.…
-
Tip of the Day - How to lock colors of a member in a Report
How to lock the color of a member in a Report When you build a visualization, Pyramid automatically and dynamically assigns the colors in the Graph to the Members.…
-
Tip of the Day - How to use Calendar Slicers
How to use Calendar Slicers in a Discover Pyramid offers a variety of slicers for you to work with your data. Our Calendar filter is a very powerful tool that offers a lot more than just picking a…
-
How to build a cascading filter in Discover
How to use the cascade option in a Discover In this how to article, we will show you how to do to build a slicer that changes based on another slicer selection.…
-
Tip of the Day - Customize your Search with a Multi Item Slice Search
How to build a custom search with a Multi Item Slice Search Pyramid offers you ten different types of filtering in the Filter menu drop zone, ranging from simple filter slicers to more options like…
-
Tip of the Day - How to create a switch list in a report
How to switch between two sets measures list in a report If you want to display different sets of measures in a Report, you can do so by creating a variable list in Discover.…
-
How to use Dynamic Text (Hebrew)
Using Dynamic Text in a Presentation in a few steps This video shows the multiple types of usages for Dynamic Text in Present סרטון שמציג את השימושים השונים של טקסט דינמי בתוך דשבורד.
-
Dashboard 101 (Hebrew) יצירת דשבורד באופן יעיל
Creating a Dashboard in a few simple steps. Please find attached a video describing how to create dashboards efficiently with Present. It covers design logic, content interaction & slicers. .…
-
Using same parameter for same model but pointing at different tables
Hi All, I have a model that creates some simple data sets. They are linked by location but each of them also have a parameter of "online sale" where a column states 1 or 0.…
- Answered
-
How to use KPIs and Gauges in a Dynamic Way
How to use KPIs and Gauges in a Dynamic Way The Use Case Working with a customer, I recently ran into an interesting use case that required dynamic band values in a KPI and a gauge view.…
-
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 - 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.…
-
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…
-
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,…
-
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,…
-
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…
-
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…
-
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