Ian Macdonald's Profile - Pyramid Analytics Community Forum

Skip to main content

User Community

Badges

Company

Pyramid Analytics

Country

Latest Posts

Re: Add a column that shows previous year, YTD.
Hi @Ricky Melamed I'm assuming you mean the year to last year same date as this year? So today, the YTD 2024 would be the cumulative value up to 18th April 2024? I.e.…
- VP Product Management
- Ian_Macdonald
- 10 hrs ago
- Questions & Answers
- Reported - view
Re: Netto_workdays
Hi @Stefan La Rooij Here's an example of what @Obee1 is talking about: Open Formulate and select Custom Column, then choose your model. Add the DateDiff block and select the first date,…
- VP Product Management
- Ian_Macdonald
- 4 days ago
- 1
- Questions & Answers
- Reported - view
Re: How to disable slicer drop Down option in presentation
Hi @Shahzad Rizwan Err, if you don't want the user to change the slicer value, why have the slicer at all? In your underlying Discover, select the single member from the dimension you want to slice…
- VP Product Management
- Ian_Macdonald
- 4 days ago
- Questions & Answers
- Reported - view
Re: Interactive Data to change pricing
Hi @Ricky Melamed Pyramid Grids have a plethora of formatting options, but we would concede that it not in the same league as Excel. For this type of "Last Mile" formatting,…
- VP Product Management
- Ian_Macdonald
- 6 days ago
- 1
- Questions & Answers
- Reported - view
Re: Union of custom columns (Static Values)
Hi @Ananth Periyasamy Measures in a slicer and Measures based Parameters do not support Multi Select as an option. I tried a number of approaches as a workaround but hit roadblocks in each one.…
- VP Product Management
- Ian_Macdonald
- 7 days ago
- Questions & Answers
- Reported - view
Re: Date Data Points
@Mad Amruthur It works for me. Try clearing your browser cache and try again. Hope this helps, Ian
- VP Product Management
- Ian_Macdonald
- 7 days ago
- Questions & Answers
- Reported - view
Re: Need guide on 2025 Feature || New option to print a single visual in a presentation, rather than the entire slide.
Hi @Shuvankar Mondal Where the print option is located in the context menu will depend on which context menu option has bee applied in your settings. The Help section you included mentions this.…
- VP Product Management
- Ian_Macdonald
- 7 days ago
- Questions & Answers
- Reported - view
Re: Date Data Points
hi @Mad Amruthur Before we get onto the calculation side of things, you should set up your aggregate properties of your model correctly for this type of Measure.…
- VP Product Management
- Ian_Macdonald
- 7 days ago
- Questions & Answers
- Reported - view
Pyramid 2025 "Newton" - You Asked, We Delivered

Over 75% of the enhanced and new features delivered in Pyramid 2025 "Newton" were initiated by you, our customers. Here's a listing and link back to the posts in the Product Ideas Form that have been…
- VP Product Management
- Ian_Macdonald
- updated 9 days ago
- 66
- 1
- Tech Blogs & Webinars
Re: Netto_workdays
Hi @Stefan La Rooij Both dates? Are you wanting to compare dates from different date dimensions? Also, you mentioned in your post "cube". Is your data in an Analysis Services OLAP cube? Or Tablular?…
- VP Product Management
- Ian_Macdonald
- 11 days ago
- Questions & Answers
- Reported - view
Re: Exclude a specific relationship from a Discovery
Hi @itay karkason Further to Moshe's answer, you can use the "Prefix" option on your duplicated date table to change the name of the table and all it's columns.…
- VP Product Management
- Ian_Macdonald
- 2 wk ago
- Questions & Answers
- Reported - view
Re: Netto_workdays
Hi @Stefan La Rooij The example you give is creating arbitrary dates using DateTime() and AddDays(). There isn't a PQL Common DateDiff function that supports excluding weekends, outside of Tabulate.…
- VP Product Management
- Ian_Macdonald
- 2 wk ago
- Questions & Answers
- Reported - view
Re: Is there a way to disable the drop zone pop ups in Discover?
hi @Alexander Khater This is not currently possible. If this is important to you, please submit a feature request in the Product Ideas forum Thanks. Ian
- VP Product Management
- Ian_Macdonald
- 2 wk ago
- Questions & Answers
- Reported - view
Re: Cohort Chart Analysis
Hi @Rebeca Figueroa Take a look at this post. About halfway down there is an example which I think closely matches what you are trying to achieve. LMK if this helps. Ian
- VP Product Management
- Ian_Macdonald
- 2 wk ago
- 1
- Questions & Answers
- Reported - view
Re: Union of custom columns (Static Values)
Hi @Ananth Periyasamy Are you requiring the selection of groups of measures with a single click? For example with one click put all the outgoing Measures ,Expense, cost, Overhead, on the rows,…
- VP Product Management
- Ian_Macdonald
- 2 wk ago
- Questions & Answers
- Reported - view
Re: Difference between the calculations
Hi @Shuvankar Mondal I thin it is also important to understand the three different levels of calculation in Pyramid. there are Granular Calculations Semantic Calculations Context Calculations…
- VP Product Management
- Ian_Macdonald
- 2 wk ago
- 1
- Questions & Answers
- Reported - view
Re: Data Source with SSL
Hi @Andres Ventura Unfortunately we do not currently support a connection to MariaDB using SSL security certificates. Please submit a feature request in the Product Ideas if this is important to you.…
- VP Product Management
- Ian_Macdonald
- 2 wk ago
- Questions & Answers
- Reported - view
Re: Hiding of Filters in Discovery
Hi @Jeevitha Create a custom member in the Product Sub Categories which is an aggregate of the items you DO want to be considered in the query. Where you have a large number of elements,…
- VP Product Management
- Ian_Macdonald
- 2 wk ago
- Questions & Answers
- Reported - view
Re: Is there a way to apply Dynamic Masking (or something similar) to Measures?
Hi @Alexander Khater This is not currently possible. As you observe, Dynamic Masking works only with Dimension data. Blocking access to the underlying Measure through Measure Security also will not…
- VP Product Management
- Ian_Macdonald
- 2 wk ago
- Questions & Answers
- Reported - view
Re: The first workday does not appear as set up
Hi @Daniel Jaldin , @Michael Daun The First Workday in the Add Tenant dialogue has nothing to do with your models. If you consult the Help on this topic you will see that the First Workday sets the…
- VP Product Management
- Ian_Macdonald
- 2 wk ago
- 2
- Questions & Answers
- Reported - view
Re: How to do Window Aggregation calculation?
Hi @Shuvankar Mondal We don't have a context calculation as a simple SUM for which you can adjust the window over which it operates. However, there is no need as this can be easily created using a…
- VP Product Management
- Ian_Macdonald
- 2 wk ago
- Questions & Answers
- Reported - view
Re: Invitation to take part in beta testing of Pyramid 2025 Newton
@Darren Tuffs We're targeting 31st March 2025, subject to testing. Ian
- VP Product Management
- Ian_Macdonald
- 4 wk ago
- 1
- Product Announcements
- Reported - view
Re: Column width
Hi @Ricky Melamed You can resize the columns in exactly the same way as you do in excel. Position the cursor over the column dividing line, it changes to a double headed arrow,…
- VP Product Management
- Ian_Macdonald
- 1 mth ago
- Questions & Answers
- Reported - view
Re: Rename the "Grand Total" name in a grid
Hi @Yolanda Heldsinger I don't think so, but V2020 was a long time ago. I would STRONGLY encourage your organisation to upgrade ASAP, as V2020 is end of life as of 31st March 2025 (in like 3 weeks!).…
- VP Product Management
- Ian_Macdonald
- 1 mth ago
- Questions & Answers
- Reported - view
Re: is there a way to calculate an mesure avarage for the last year from yestrday?
Marking as answered as no response from poster.
- VP Product Management
- Ian_Macdonald
- 1 mth ago
- Questions & Answers
- Reported - view

1 2 3 4 5 24

Back to top

Home

View all topics