-
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 loss triangle in Pyramid Analytics
Does anyone know of a way to create a loss triangle in Pyramid Analytics?
- Answered
-
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,…
-
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 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 connect Google Sheets to Pyramid
Pyramid can model and blend numerous complex data sources for basic or advanced analysis. The quick tutorial below shows how you can use Pyramid to access and import data stored in a Google Sheet,…
-
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 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 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 create a Sankey Chart and Cascading Slicers
How to create a Sankey Chart and Cascading Slicers Working with the more advanced functionalities of Discover can be seen as daunting, but don’t be afraid.…
-
How to add Date Part and use Eliminations
How to add Date Part and use Eliminations Date Part offers a smart way to group information in a table and get a better overview on repetitive patterns.…
-
How to build logical categorizations (Bins)
How to build logical categorizations (Bins) Working with the more advanced functionalities of Discover can be seen as daunting, but don’t be afraid. Use the Tips & Tricks series to give you a quick…
-
How to build visualization according to the IBCS Standard
How to build visualizations according to the IBCS Standard Based on Ideas from our Customers we added a new set of visualizations to Pyramid visualization library that allow users to build Reporting…
Search for answers here or ask a question