-
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…
-
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…
Welcome to the Pyramid User Community
Pyramid User Community