-
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…
- 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
-
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?
- Answered
-
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…
- 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
-
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
-
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…
- Answered
-
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
Got stuck with a report? Start a discussion or help others to move forward.