-
2020.10 Feature Focus: Data Catalog – Self-Building Capabilities (Part 1)
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…
-
Authentication by Azure Active Directory (AAD)
Dear Pyramid, on behalf of my company's system admin I would like to ask the following question: Are there any plans to support native Azure Active Directory Authentication using Microsofts…
- Answered
-
Multi-factor Authentication
Is there a way to enable multi-factor authentication (MFA)? If not directly through Pyramid, is there third party tools to provide something like this?…
- Answered
-
Pyramid 2020.20 Issues Addressed
The following list enumerates all the main bug fixes in the 2020.20 version. Back to Pyramid 2020.20 release announcement Model Fixed an issue where unexpected results were returned in Discovery…
-
Calculations using dynamic text
I am trying to find a way to create a dynamic text based on other dynamic text in the presentation slide So I have a DT [Outstanding amount] and another [Disputed amount] I want to add a third to…
- Answered
-
How to create a loss triangle in Pyramid Analytics
Does anyone know of a way to create a loss triangle in Pyramid Analytics?
- Answered
-
Europe Design Theme
Hi, Where can I get the Europe Design Theme .i.e. download it. I seem to have written over it by accident. All part of learning. Regards Kate
- Answered
-
Combine members of different dimensions as a new dimension
Hello I am trying to create a new dimension by combining members from two other dimensions. Is this possible? For example: Combining a member from the Product dimension with a member from the…
- Answered
-
Could we desactive the option "analyse further"?
Hi everyone, i made some discoveries and i need to desactivate the option "analyse further" for viewer user. I've tried profil, execution parameter in discovery or presentation.…
- Answered
-
Example of how to use the new Embed framework in Pyramid 2020.11 onwards
Below is a simple sample code example of how to use the new embed framework. Update the username, password and contentID(to get the ID, right click on the item to embed >Metadata) to those relevant…
-
Tooltip Name include
When hovering over data in a Discover, the specified tooltip data is shown in the window but it can be difficult to link the data to the title of the tooltip if similar data is shown in the tooltip.…
- Answered
-
Stacked and non stacked chart together
Hi I have four measures, one being premium, and then an set of data of claims split by type, I want to see the premium as one colour in its own bar, and then the 3 claim types stacked together…
- Answered
-
Can you drill down by column instead of cell?
For example i have a date hierarchy for years , quarters and months. The user want to click on inception date hierarchy and drill down from years to quarters so the entire presentation shows all…
- Answered
-
Hide unwanted subtotals
Hello, I'm wondering if it is possible, when including subtotals in a grid, to select which columns you want the subtotals to show for? Currently when subtotals are added,…
- Answered
-
Background Colour cells based on IF formula
As per the above, I have created an IF formula to specify what colour I want the cell to be, based on the value of the measure. This doesnt seem to work no matter what I try when dragging the…
- Answered
-
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
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