-
Setting dimension elements to a secondary axis
Hi, I don't know if the following is even possible using an OLAP cube model. I'm looking to create a graph to view the YoY data with the percentage change overlaid on the secondary axis as a line…
- Answered
-
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.…
-
Obtaining accurate summations in a Many-to-One Relationship
I am having trouble grouping lines correctly so that I can get accurate totals. The basic premise is as follows: We are trying to transition away from buying item A and instead encouraging buying…
- Answered
-
How to build a Waterfall Charts with Context Calculations
How to build a Waterfall Charts with Context Calculations Waterfall Charts are a great way to see contributions to a resulting value in an easy way. With Context Calculations the Waterfall represents…
-
How to build an Accounting Table with Images and Links
How to build an Accounting Table with Images and Links Working with the more advanced functionalities of Discover can be seen as daunting, but don’t be afraid.…
-
How to build Aggregates with Context Calculations
How to build Aggregates with Context Calculations Working with the more advanced functionalities of Discover can be seen as daunting, but don’t be afraid.…
-
How to use Measure Lists and Parameters
How to use Measure Lists and Parameters 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 way…
-
How to build a Tree Map Chart with Measure
How to build a Tree Map Chart with Measure Tree Maps are a powerful visualization if well used and understood. Using Grouping and Measures we are able to create very insightful Tree Map Charts.…
-
How to cluster outliers and add regression lines
How to cluster outliers and add regression lines Working with the more advanced functionalities of Discover can be seen as daunting, but don’t be afraid.…
-
How to use the List Builder to create a Word Cloud
How to use the List Builder to create a Word Cloud Working with the more advanced functionalities of Discover can be seen as daunting, but don’t be afraid.…
-
How to include all Context in Action when Jumping from Present to Discover
I want to create a jump to content item action on a Present that carries over all filter values placed on a Discover in the Present. In a Present, I have a Discover with multiple slicers interacting…
- Answered
-
Is it possible to toggle between 3 different date fields on a Present
I have a present with discovers that all are based on time. They show information about loans that have been created over the past X amount of time. This is grouped by a total for each past…
- Answered
-
Pyramid Community Weekly Wrap Up - April 13th
Dear Users, in German we have a saying, everything that lasts longer than three times, is a tradition. So welcome to the fourth Weekly Wrap up. Lets see what happened Big News 2023 Gartner Magic…
-
Creating a dynamic parameter for a date range
Hi Everyone, I am trying to figure out a solution for the following issue. We have a contract with a start date and and a end date dimension. We want to select the active contracts within a year.…
- Answered
-
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,…
-
Learning Live: Visual Formatting
About this Video: In this video we give you a deep dive into the Formatting options in Discover. Covering a broad spectrum of different possibilities with plenty of live examples.…
-
Learning Live: Using KPIs and Gauges
About this Video: In this video we give you an overview the use of KPI's and Gauges and how to usefully implement them into Pyramid Reports. Content: Lets check out this session,…
-
Learning Live: How to use Themes in Pyramid
About this Video: In this video we give you an overview about how you can use themes in a variety of modules in Pyramid. This will help you to get a consistent look and feel across all reports.…
-
Getting Started with Pyramid
In our first session, we will cover the basic getting started workflow from Quick Model, to Discover and finally Present. These examples are simple and designed to acquaint you with the product.…
-
How to combine elements under single header
Hi all, I am looking to combine a group of elements (R1, R2, R3) to create element R which I can use in a Discover Matrix Grid. If I add R1, R2, and R3 to a list then my list of elements looks like…
- Answered
-
How to hide Microsoft SQL databases that a user does not have access to
By default even if a user does not have access to an Microsoft SQL database they can still view it when logging into SQL Management studio. Therefore the same behavior will be seen in Pyramid when…
-
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…
-
How to I show data point that do not have a value
Hi, I have a report, where we don't have sales data for the time period, but I want to show the empty cells on the report . Like in this example 123456 didn't show up. Who could help me to solve this.…
- Answered
-
Pyramid Data Tip of the Day - AI Driven Forecasts
Video of the Day – AI-Driven Forecasting Captions. Our video of the day looks at the new AI-driven forecasting captions. When setting up advanced forecasting,…