-
Stop distribution of when 'Finished with Errors'
When a publication finishes with errored queries, the report is still distributed - this causes confusion for end users as it appears there is missing data.…
- Answered
-
Notification of Publication Failure
Hello, Is there a way that users can be notified when a publication fails? I can see this previous question which showed there is a repository table to see this in BI Office,…
- Answered
-
How to revert back to a previous version of Pyramid
On this page, you will find how to revert back your Pyramid version to a previous one. Pre-requisites: A backup of the Pyramid repository from the version you wish to revert back to.…
-
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…
-
Present - Runtime Settings on slides, reports
Under Runtime Settings in Present, I see two options: Global-Scope and Slide-Scope. What do these mean? I also would like to know if I can apply different runtime settings to different slides in…
- Answered
-
Implementing row level security on any database
Row-level or ‘Member-level’ security is a fundamental requirement in most analytic projects controlling which data items different users can view and analyze,…
-
Time intelligence: Date-time calculations made simple
This is the third blog in the series on how Pyramid brings time intelligence into analytics. As covered in my previous blogs on time-intelligence, adding date-time groupings into your data makes the…
-
Time intelligence: Date-time groupings for better visibility
This is the second blog in the series on how Pyramid brings time intelligence into analytics. In my previous blog post, I introduced the concept of grouping amounts in data periods by adding date…
-
Time intelligence: A critical element in all analytic projects
This is the first blog in a series on how Pyramid brings time intelligence to analytics. The two core challenges Date-time groupings and “buckets” Central to most analytic systems is the requirement…
-
Time intelligence: Custom calculations for greater perspective
This is the fourth blog in the series on how Pyramid brings time intelligence into analytics. My previous posts on time-intelligence covered Pyramid’s powerful and automatic date-time calculation…
-
Time Intelligence: How date lists and ranges accelerate insights
This is the fifth blog in the series on how Pyramid brings time intelligence into analytics. In my previous blogs, I demonstrated how Pyramid provides automatic date parameters to interrogate…
-
Overlaying columns/bars with integrated variances (IBCS)
Dear Community, the following picture is taken from the IBCS v1.1 (2017). Is there a chance to create something like that with Pyramid? At least something that comes close to it?…
- Answered
-
PQL Custum Measure: modify value before passing to aggregation
How can one create a custom measure that involves modifying a column before passing it to an aggregation function? For a example, consider calculating the average of squares of a column.…
- Answered
-
Pyramid 2020.17 Released
Pyramid 2020.17 has been released and includes a small collection of fixes. Importantly, it includes the last preview release of the Kubernetes version before it is officially RTM'ed.…
-
Pareto Analysis: Using the 80/20 Rule
In this second post on my three-part series on contextual calculations, I examine how Pyramid can quickly create business calculations like Pareto with just a few clicks.…
-
Stop Writing Code: Running Totals Made Easy
In this part 1 of my blog series on contextual calculations, I explore running totals in Pyramid. Running or cumulative totals allow business users to see how different metrics add up from the first…
-
Calculating differences without code
In part 3 of my blog series on contextual calculations (see part one and part two), I cover the powerful ability to calculate differences between current and previous row values for a metric and…
-
Cumulative context but to exclude specific status measures (unable to reproduce solution)
Hello, Background: We use Pyramid 2020.13.100 against a SSAS datasource. I'm trying to make the graph above, my assumption is that I should be able to do that if I'm able to make the accompanying…
- Answered
-
Colorizing in Discover does not work as expected
Dear all, a client of mine tries to colorize the budget deviation with itself as shown in the attached video. When he colorizes "all" then it works perfectly as well as when he colorizes only the…
- Answered
-
Remove expand icon of hierarchy within a matrix
Hello all, I would like to remove the expand icon in a matrix from one specific hierarchy. Do you have any idea how to solve this? I want to remove the expand or "+" icon from the product hierarchy.…
- Answered
-
2020.10 Feature Focus Datavard Glue: SAP ERP Data Modeling
2020.10 is the latest release from Pyramid Analytics. It extends the functionality introduced in our major 2020 release. This is one in a series of posts that highlights some of the major new…
-
2020.10 Feature Focus: Audit Trail Framework
2020.10 is the latest release from Pyramid Analytics. It extends the functionality introduced in our major 2020 release. This is one in a series of posts that highlights some of the major new…
-
2020.10 Feature Focus: Present Lite
2020.10 is the latest release from Pyramid Analytics. It extends the functionality introduced in our major 2020 release. This is one in a series of posts that highlights some of the major new…
-
2020.10 Feature Focus: Data Catalog - Toolkit (Part 2)
2020.10 is the latest release from Pyramid Analytics. It extends the functionality introduced in our major 2020 release. This is one in a series of posts that highlights some of the major new…
-
2020.10 Feature Focus: Flow Grids and Flow Charts
2020.10 is the latest release from Pyramid Analytics. It extends the functionality introduced in our major 2020 release. This is one in a series of posts that highlights some of the major new…
Welcome to the Pyramid User Community
Pyramid User Community