-
How to: Display Daily Data in a Calendar View
How to: Display Daily Data in a Calendar View When you are working with Daily Data it will sometimes make sense to display the information in a Calendar view.…
-
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 - 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…
-
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,…
-
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…
-
Pyramid #DataTipoftheDay on Youtube
In the future you will get small #tips&tricks for Pyramid in our Youtube Channel Make sure you follow our channel. Here is the first one from our development team.…
-
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.…
-
Tip of the Day - use formulate to calculate percentages of some elements
Our video of the day looks at a way to calculate percentages of elements A question came up from a client on how to calculate the percentage of two elements in a dimension from the total of this…
-
How to add a Custom Visual
How to add a Custom Visual Pyramid offers a broad spectrum of standard visualizations that are available to users in the Discover App. In order to include additional visualizations,…
-
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 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…
-
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.…
-
How to add and work with Bookmarks
How to add and work with Bookmarks For frequent users of reports with many slicers, choosing pre-saved filter combinations for your area of interest can be a significant time saver.…
-
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…
-
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 - GenBI vs GenAI explained
The implementation of GenAI into the every day processes of you company is one of the top discussion topics. The Terminology and Differences are misty and could be misleading.…
-
How to use a chart to filter other charts
How to use a chart to filter other charts In a question in the Q&A Section of the Community we got asked how to interact several charts so that they work as actual filters not just highlighting the…
-
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…
-
Tip of the Day - Visual Tool Tips
Create custom graphic tool tips that display a given data discovery or presentation when hovering over a specified measure in a selected visualization. The report displayed in the tool tip is…
-
Tips & Tricks: How to identify duplicated elements
How to identify duplicated elements? A recent Question on the Community asked what would be a good way to identify duplicates. E.g. where an Element has been assigned a Status twice where it only…
-
How to build a Customized E-Mail Template
How to Build a Customized E-Mail Template Distributing Information on a regular basis is a key component of every BI Strategy. Sending e-mails in a fashion that is recognizable and individualized is…
-
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.…
-
Pyramid #DataTipoftheDay No.2 on Youtube
In the future you will get small #tips&tricks for Pyramid in our Youtube Channel Make sure you follow our channel. Here is the second one from our development team.…
Search for answers here or ask a question