-
Transfering IMDB models from one environment to another.
Transferring models and data between different environments can be a straightforward process by exporting and importing the ETL and re-executing it in the destination environment (provided that all…
-
Adding an empty measure column to a Discovery
Adding columns is basically done by creating and selecting Calculated members/measures into the Columns selection area. In this case, the requirement is to add an empty column to discovery,…
-
Publication with a dynamic current period
In a publication, users can only add the Current Date from the Dynamic Text dropdown. But if another time period is needed and it's available in the model, here is how to show it in your publication.…
-
Creating an IMDB Time column in the Model designer
In the current version of Pyramid (2020.10), the Time type column is not supported when creating an IMDB model. As a result, it will appear in a Discovery report but it will not be possible to…
-
Creating a Date Time intervals in Data modeling tool
When creating a SQL based model, you can create a time interval column using a custom "Date time" type column (i.e 12:00,12:15,12:30,12:45, 13:00). To do this,…
-
How to apply Cumulative Function (Percent of Total) of rows/columns in Charts.
The "Percent of Total" calculation is a context calculation that is designed to factor the "shape" of the query in determining the scope of the calculation.…
Badges
Latest Posts