-
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…
-
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 use "Custom Colors" in the "Color" Drop zone to set a specific color to a specific value in a grid.
1) Create a new formula in the formulations app 2) Create an "IF" statement based on a measure using the "RGB" function and save it. Use an RGB Color picker such as the one here to get the correct…
-
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 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,…
-
Time Intelligence Wizard
Is there something like the Time Intelligence Wizard available in Pyramid 2018?
- Answered
-
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.…
-
NEW: Explore Pyramid - monthly Data Challenge Environment
Trickle your Brain and keep Learning Right before the Weekend, we are happy to give you the exclusive chance to start playing with the brand new Explore Pyramid Environment and begin your first…
-
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: 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,…
-
Conditional Formatting
I have been converting reports from BI Office to Pyramid 2018 and I have run into a snag. Note that this report was imported from BI Office to Pyramid 2018 using the conversion tool.…
- Answered
-
Why are my formulas not showing up
I have a handful of formulas that execute successfully in a Public Content folder. However, in Discover, only 2 of them show up Even if it is a blank discover panel.…
- Answered
-
How to share Pyramid Reports and Dashboards in Microsoft Teams
The easier Users can get access to information, the better. One way to bring Data to End Users it to integrate it into internal communication platforms like Teams.…
-
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.…
-
How to set default value to Slicer(Filter) ?
I have week number Slicer(filter). If my current week is 47 then i want to set 47 in slicer.
- Answered
-
Dynamic texts for Slicers
Hi Folks, I am trying to use Dynamic text in Pyramid analytics 2018 which is based on the slicer (single select-drop down) so that the Presentation header in each slide changes with the slicer…
- Answered
-
Learning Live: Custom Machine Learning with Learn/Predict Scripts
About this Video: In this video we give you an overview about how to run Custom Machine Learning in Pyramid with Learn and Predict Scripts. How it is developed,…
-
Learning Live: The Hub and Personalized Dashboards
About this Video: In this video we give you overview about a new feature in the platform: 'The Hub'. These Hub provides a method to display individual content when users log into the platform -…
-
Number Formatting in Discovery
Hi all, I have the attached discovery prepared from the attached data model. I am having trouble displaying the variance information as a percentage rather than a number format.…
- Answered
-
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
-
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,…
-
Combining two discovery tables in present
Hi We have two tables which we are trying to merge. The left one defines top 20 suppliers with their market share in cur month, previous month, cur ytd, current ytd.…
- Answered
-
Data Label Formatting on Average Measurements
Hi, I've created a discovery which has two axis. The first axis (bar) to show quantity and the second axis (line) to show percentage of sales. What we would like to do is show another line on the…
- Answered
-
Percentage points change
Hi We are looking at a solution to create point percentage change column. In the given example we would like to create a measure that can be calculated on percentages,…
- Answered
-
Learning Live: Enriching Data with Python Scripts
About this Video: In this video we give you an overview about how you can enrich your analytics data with Python Script. Content: Lets check out this session,…
