-
How to backup and restore a PostgreSQL database via DBeaver
This article discusses how to back up and restore your PostgreSQL database via DBeaver. There is another way to do it via the windows command line, as described in this article:…
-
Configure Model's Targets / Sources with a variable
Hi everyone, I'm wondering if there is any way to configure targets / sources with a variable or a parameters that contains a connection string ? That will help us to not update connections in every…
- Answered
-
smart discover - change order of nesting
I tried creating a smart discover. I chose 2 measures, and two dimansions. Now one dimension is on the rows, and on the columns I see the measures on top, and the dimension underneath them.…
- Answered
-
Smart discover - allow selecting custom calculation
If I create an IMDB model, I can't have an aggregated average as an intrinsic measure. If I want a measure called "avg price" it has to be a calculated measure.…
- Answered
-
Negative number formats
I have been asked to produce a report with a very particular number format, and I can't see a way to do it They want negative values to be shown in parentheses and in red- I have managed to get the…
- Answered
-
Scaling options in Present panels
The current options for scaling in presentation panels do not allow for scaling on width, so if I have a grid that's wider than the panel, the only option I have to get the columns to fit is "scale…
- Answered
-
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…
Welcome to the Pyramid User Community
Pyramid User Community