Questions & Answers Category

Selecting Multiple Dimensions at Once

Hey all, This is a simple question about whether a certain functionality exists in Pyramid. Is a user able to select multiple dimensions and add them simultaneously?…

• Answered

Formatting for stacked bar charts

Hey guys! I'm wondering why Pyramid doesn't show the sum over the data labels below the stacked bars but in the middle. There are also no options in the formatting panel to change this.…

• Answered

Lien entre différentes requêtes dans un modèle qui ne fonctionne plus

Bonjour, un modèle a été crée, mais les liens entre les différentes requêtes ne fonctionnent plus : les filtres d'une requête ne peuvent pas être utilisés pour une autre requête et vice versa...…

% of max calculation changes on context.

I've noticed that the context of the % of max calculation changes depending on if you have 'values' in the columns drop zone or not. When included it separates the calculation by column (each column…

• Answered

Filtering on 2 dimensions and counts

Hi community, I am struggling to do something that I think should be possible so asking for help here I have a star schema modelled in snowflake and a Direct Query model in Pyramid consisting of a…

How to determine DataFlow NodeID?

Good day everyone, I try to automate the change of data models via the Pyramid API. But I can't find a function to get the Node ID of an existing model.…

Calculation of a ratio

Dear Community, I would like to supplement the presentation of a profit and loss statement with a ratio. This should always show the percentage of the upper node.…

How to use the 'Publication Print' click action to apply slicers from a presentation

I am attempting to export a matrix-grid discovery to an Excel file on a presentation by using the publication print click action. I am having difficulties getting the discovery within my Publish file…

• Answered

The unrestricted rights of administrators

I would like to talk about the very extensive authorizations of the Enterprise and Domain Admins. Although I also have a corresponding product idea/feature request in mind for the problem described…

• Answered

Using CustomerID instead of their address to look up location

Hello, Part of a dashboard we're making will use google maps imbedded API and dynamic URL to show the customer's location. I'm wondering how we can use a CustomerID to filter the map,…

• Answered

Questions About Altering Available Print/Export Options

I have two related questions: 1. Is it possible to disable certain export options in PresentPro? I am working on a Dashboard in Present Pro and the visuals and intended use-case for the Dashboard are…

• Answered

Synchronization of two slicers

I have two slicers in a dashboard, each of which should always output the same thing. This means: if I change one of the two, the other should synchronize and display the same.…

• Answered

Backport /API3/dataSources/getImdbResources API to 2024 LTS

I'm currently working with the Pyramid 2024 LTS version and have identified a potential area for improvement regarding the monitoring of In-Memory Database (IMDB) resources.…

• Answered

How to manage security with migrations between environments?

Hello, We need some assistance in migrating security between environments, specifically security roles on artifacts (Discovers, Models, Presents, etc.) We are using the "Migrate Content" option,…

• Answered

Is it possible to do a "Count IF" in a Dynamic Text data set?

I have a grid that contains a number of rows and what I want to do is count the ones that are above or below a certain number. For example, let's say that I have a growth percentage and I want to…

• Answered

Instance URL Not Saved After Logout (iOS)

Hello PA team, I've noticed that the Pyramid mobile application for iOS does not save the Instance URL after the user logs out or the session expires. Users of the Pyramid mobile app on iOS are…

• Answered

Interaction between P&L and waterfall chart

A dashboard consists of two elements A P&L table and a waterfall chart should interact. If you click on a line in the P&L table, e.g. sales, the waterfall chart should display the actual-to-plan…

• Answered

Usage of the Count Function in Present

This may be a pretty basic question: I have a presentation that allows users to select multiple elements from a slicer. I would like to place a dynamic text box that displays the count of selected…

• Answered

Metadata Management for Data Governance

Hello, I just wanted to check if anyone has Pyramid discovers, present and models integrated to a metadata management tool like Collibra, Apache Atlas or Openmetadata The intent is to be able to…

Top 10 filter doesn't take each year into account separately.

I have data setup in pie graphs showing products ordered in each year. When I trellis them so that multiple years are shown, and then add a TOP10- filter it doesn't show me the TOP10 products ordered…

• Answered

Add a column that shows previous year, YTD.

I have sales for a few years in a grid, but want to add a column between 2024 and 2025 that shows the 2024 YTD. I assume that this can be done using time intelligence or formulate,…

• Answered

Text indicator to show % change from previous period

I want my text indicator to show the % change from the previous period. Ie. If the sales in 2024 were $100 and the sales in 2025 were $110, I want the text indicator to show 10%

• Answered

horizontal scroll

I'm assuming this is simple - and yet I cannot figure it out. My tables isn't that wide, there is no reason that it should have the horizontal scroll bar. How do I eliminate it?

Join with a constant

Hello, In a direct query model, is it possible to have a join with a constant value ? For e.g. can I have the join as tableA.date = tableB.date tableA.type = 'Type1' another join tableA.date = tableC.…

• Answered

How to disable slicer drop Down option in presentation

I have created a presentation in pyramid and want to show preselected value in slicer. So that user can't change value from slicer drop down

• Answered