-
How to apply borders, based on grouped columns
We tried to apply border, based on vertically grouped column. Specifically, we need to apply the border like the following image. The main column contains three child columns.…
- Answered
-
Learning Live: Demystifying Data Science
About this Video: Data Science is one of the hot topics in Business Analytics for a while. But seeing it implemented in actual Daily Reporting and Workflow is not as common as you could think.…
-
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 there an example of how to use the API's to export a discovery as a PDF?
Hello, I've read that it's possible through the API's to export discoveries. Does anyone have example code of how to export a discovery to a PDF using the API's? Thanks, Rob Clark
- Answered
-
Use API's to extract data from a discovery
Hello, Is there a way to make an API call to export data from a specific Discovery? Thanks, Rob
- Answered
-
Find Difference between two dates
Hi All, We need to find difference between two date dimensions present in our model. Is it possible to do it using formulate?
- Answered
-
What is a "Subquery mode" ?
Note: "Sub Query" mode is only applicable to Microsoft Analysis Services data sources. Microsoft SSAS has a limitation that the "where" clause of the MDX statement can't accept more than one element…
-
No proxy account was set for user (2020.10)
When content is from an MS OLAP /Tabular data source, after upgrading to Pyramid 2020.10 RTM the following message is shown when opening some content for the master user:…
-
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,…
-
Create a horizontal percent calculation
Hi all, is ther any possibility in Pyramid to calculate how many percent 21 - others form the sub total is? I would like to create a new culomn in wich Pyrmaid should wirte the percent for every…
- Answered
-
Multiselect Dynamic measure
Hello! Is it possible to use multiselect with Dynamic measures? The way I tried in the picture is not working. Kind regards, Dennis.
- Answered
-
Retrieving XMLA to analyze cube structure
Below are instructions on how to get the cube structure (dimensions, hierarchies, measures…) It can help the Pyramid development team debug cases where the query fails to get the cube metadata.…
-
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.…
-
Gauge titles
Hi all, is there a way to get rid of the second part of the gauge title? It is 'All' for all of my graphs, so in this instance it's redundant. Thanks, Verity
- Answered
-
Address within Maps
Hi, How do you pinpoint an exact address in the maps discovery in Pyramid? I'm trying to pinpoint the location of multiple offices for a company. The address are across multiple states.…
- Answered
-
Union: Adding Attributes to a Node
How do you Map Your Measures? You have numbers accrued in a database or excel for months, but nobody has taken an interest in them. You want to unleash the can of worms, so to speak,…
-
Displaying only yesterdays Date
The data my company collects is a day behind, is there a way to show just the data information from yesterday? Ex: Today is 4/10, the most recent data I have and want to show in the discovery is 4/9?…
- Answered
-
Data Visualization Tutorial
One of the key drivers in the Pyramid 2018 design was the data visualization engine and the flexibility it affords to users in visualizing data for analytics through a huge number of combinations…