Latest Activity

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

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

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

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

Union of custom columns (Static Values)

I am in need of creating a static dimension with multiple measure names such as: sales, expenses, cost, count, etc. These are to be given to a multiselect dropdown in a report that gives the measure…

• 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

Netto_workdays

I'm trying to do a datediff() between two dates in my Cube, but ideally I would remove the weekends from this, like excel would do with the netto.workdays() function.…

• 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…

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

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

Cascade for date filter as Date Calendar Type

Hi, I’m working on the cascading of filters and when I use the date as a base filter (i.e) the filter based on which 2 other dimensions must be filtered,…

• 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

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

In a Discovery, how to identify records that do not have a corresponding child record

Hello, Here is the scenario. We have insurance policies in a policy table which joins to a coverage table by a policy_id primary key which is a foreign key in the coverage table.…

• 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