Latest Activity

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

Date Data Points

Hello, I have a requirement to display various measures for Current Year Prior Year End Prior Qtr End Measures would be for e.g. Balance YTD Growth % (Current Month - Prior Year End Bal)/Prior Year…

Interactive Data to change pricing

Hello, I am trying to find the limits of Pyramid, so pardon me if this is impossible. I'd like to think that thee has got to be a way... even if it is complicated.…

• Answered