Questions & Answers Category

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

Need guide on 2025 Feature || Delayed Slicer Execution

Hi Team, I need a guide on this below feature. Thanks, Shuv

• Answered

Need guide on 2025 Feature || New option to print a single visual in a presentation, rather than the entire slide.

Hi Team, I raised the below request sometime back Link, and I am excited to have this feature launched in the 2025 Newton Version, but I did not find any guide on how to use this. Thanks, Shuv

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

Turn off time changes

Hi everyone, I need to shut down the time changes in the platform because in my country we keep the same time throughout the year but I haven´t found out how. Has anyone done it before?

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

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

Cohort Chart Analysis

Hello! Cohort Chart: Requirement : Cohort view (table or chart) to visualize these recurring orders by showing the average order value and also the percentage of customers who place recurring orders…

• Answered

Is there a way to disable the drop zone pop ups in Discover?

I want to be able to turn off the drop zone pop ups. I'd like this specifically for the 'Analyze Further' use case, but I would be satisfied with disabling it entirely.…

• 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

Exclude a specific relationship from a Discovery

Hi everyone, I'm working with a data model that includes multiple relationships between fact tables and a date table. Currently, there's an existing relationship between a certain table and another…

• Answered

Difference between the calculations

Currently, I am diving deep into more of the calculations, and this brings me to a confusion that I would like to understand. I would like to know the differences between these calculations and how…

• Answered

Building cascading filters/slicers that contain only relevant values of charts at the presentation layer

I have a main slide where there are around 10 global filters/slicers, and the slide contains more than 6 charts. What my need is to have these filters to be cascaded and also these filters should…

How to do Window Aggregation calculation?

I would like to know how we can create Window Aggregate calculations such as SUM(Sales) Over(Partition by Invoice Number) can be done in Pyramid Analytics.…

• Answered

Purpose of the different filter panels

Can I get some guidance on using the different filter panels across the Pyramid Analytics? Filtering using the Filter panel in the drop zone Filtering using the Filter button from the Ribbon…

• Answered

The first workday does not appear as set up

I noticed that my Date Calendar Slicer shows the first workday as Sunday, even though I've set it correctly in Tenant / Tenant Default Settings. Is there maybe another way to setup this? If not,…

• Answered

Is there a way to apply Dynamic Masking (or something similar) to Measures?

My team and I would like to create a grid discovery for external users. We would like the values from certain Measures to be encrypted to external users,…

• Answered

Global variable doesn't update when new model is processed

Hello, I'm trying to use a conditional to check the most recent run date column in a model and compare it with today's date. I'm hoping to create a crude validation that will email stakeholders and…

• Answered

Hiding of Filters in Discovery

I am using two filters, I need to hide one of them. Is there a possibility to make it hidden in discovery and not presentation. Thanks in advance. Jeevitha

• Answered

Data Source with SSL

Hi, I want to connect a MariaDB database as a data source, but it requires an SSL certificate (ca-cert.pem, client-cert.pem, and client-key.pem). What are the steps to do this?

• Answered

Pyramid doesn't recognize addresses

I have 1 column with full addresses; not multiple columns that separate the Street Address, city, postal code, country. When I am modeling the data, the address is recognized as a string.…

• Answered