-
Listing all the dimensions of a hierarchy in a Discovery
I receive multiple requests from users to display multiple levels of a hierarchy in a Discovery. For example rather than just a profit centre name displayed,…
- Answered
-
Text to Dynamic Caption
Hi Hopefully an easy one, im looking to add the word "and Prior" to the following dynamic caption text ToString(DateFormat(AddYears(Date(),-2), "YYYY") ) I did think it would be…
- Answered
-
Values appearing as -0 for one user, when they should be %
I'm stumped by this display issue one of our users has, and I hope someone can point me in the right direction for how it can be solved. In every discover (or in present where a discovery is being…
- Answered
-
Using URL Parameterization
I am currently trying to figure out how to parametrize a URL in order to link directly to a Present whose data would be filtered by the other application.…
- Answered
-
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,…
Welcome to the Pyramid User Community
Pyramid User Community