-
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 create a loss triangle in Pyramid Analytics
Does anyone know of a way to create a loss triangle in Pyramid Analytics?
- Answered
-
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 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,…
-
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 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…
-
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.…
-
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 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 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.…
-
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…
-
Learning Live: Creating Custom Visuals
About this Video: Pyramid offers a broad variety of visualizations out of the Box in Discover. In some cases there are specific visualizations that are better to explain the data set in question.…
-
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.…
-
Learning Live 2024: Pyramid 2023 Update
About this Video: In this Episode of Learning Live we will give you an update and overview of the new features and improvements that have been included in the Product since the launch of Pyramid…
-
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…
-
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,…
-
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,…
-
How can I get the count of days for every month using Formulate (Custom column)?
I need to get the count of days in each month using the custom column option in a formula or any other ways in Discover. Does anyone have a solution for this?
- 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
-
Tip of the Day - Multiselect Slicer Elements
Our video of the day looks at the new multi-select capabilities for slicers. Multi-select drop down slicers let you select multiple slicer elements simultaneously and filter the query by those…
-
Time Intelligence Wizard
Is there something like the Time Intelligence Wizard available in Pyramid 2018?
- Answered
-
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…
-
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 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,…