-
How to update the Pyramid repository credentials.
Issue: Some organizations security policy require a change of passwords periodically, in which case the Pyramid repository credentials may need to be updated in the Pyramid config.ini.…
-
Pyramid 2020.18 Released
Pyramid 2020.18 has been released and includes a collection of numerous fixes. Software The main installer files can be downloaded from the Pyramid Customer Portal.…
-
How to calculate aggregate correctly without using underlying details
Hello, Background: We use Pyramid 2020.15.046 against a SSAS datasource. I want to calculate the amount of interesting clients per location without using clients in the table,…
- Answered
-
Colouring different parts of a dynamic text sentence.
As per the above mentioned, is it possible to colour different sections of a sentence that are based entirely on dynamic text - or made in the dynamic text editor?…
- Answered
-
Pyramid's Calculation Engine Explained
Pyramid includes a sophisticated, multi-tiered calculation engine designed to handle the full spectrum of calculations often required in solving analytic questions and problems.…
-
Aggregating clients for a location while taking into account other locations
Good morning, background: we use Pyramid 2020.15.046 against a SSAS datasource, tabular model. I have a user wish, which I don't know how to build. The user wants to know for a certain location how…
- Answered
-
How can a mobile viewer user add favourites?
Hi, We have mobile viewer users, I just told one of them to add something to their favourites but the option doesn't seem to be there. I have had a look on the app and can't find it either,…
- Answered
-
Adding a custom map
Hi i've converted a Mapinfo TAB file to Geojson format using an online service and uploaded the .geojson file to Pyramid, I can pick that custom map as a property for the relevant dimension in a…
- Answered
-
Export List of Pyramid User Accounts
Is there a way of exporting a full list of user accounts on Pyramid, along with related information (e.g. Roles, Profiles etc.)
- Answered
-
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…
Content aside
Topic actions
Rate Pyramid today:
Please rate from 1-5 Stars and click on the Star
to register your feedback.
BARC 2025 BI and Analytics Survey
Pyramid 2024 LTS Release Notes
Pyramid 2023.15 Release Notes
Pyramid Tip of the Day
Pyramid Learning Hub
Pyramid Tutorial Videos
Pyramid Support
Pyramid Help