Ian Macdonald's Profile - Pyramid Analytics Community Forum

Skip to main content

User Community

Badges

Company

Pyramid Analytics

Country

Latest Posts

Re: Lien entre différentes requêtes dans un modèle qui ne fonctionne plus
Hi @Pinvidic Julie First thing is to run the Analyzer against the Present. This will identify any mismatches in your analytic objects and your Model definition and guide you on how to resolve them.…
- VP Product Management
- Ian_Macdonald
- 29 min ago
- Questions & Answers
- Reported - view
Re: Selecting Multiple Dimensions at Once
Hi @John Fonte No, you cannot do this currently. You can "Combine" multiple hierarchies and then use the combined hierarchy, use CTRL-Click for disparate items,…
- VP Product Management
- Ian_Macdonald
- 46 min ago
- Questions & Answers
- Reported - view
Re: Using CustomerID instead of their address to look up location
Hi @Stefano Sena OK, but Google maps knows nothing about your Customer ID. All it knows is how to plot a lat/long on the map, geocoded from the address you are passing to it.…
- VP Product Management
- Ian_Macdonald
- 2 wk ago
- Questions & Answers
- Reported - view
Re: Using CustomerID instead of their address to look up location
Hi @Stefano Sena You can use anything you like to filter the data before you send it onto Google Maps. I'm not quite sure what it is you are asking. Can you please clarify? Thanks, Ian
- VP Product Management
- Ian_Macdonald
- 2 wk ago
- Questions & Answers
- Reported - view
Re: Questions About Altering Available Print/Export Options
Hi @Alexander Khater You an turn off the ability to Export/Print from Present using the Runtime Settings. You can only turn this functionality on or off,…
- VP Product Management
- Ian_Macdonald
- 2 wk ago
- 1
- Questions & Answers
- Reported - view
Re: Synchronization of two slicers
Hi @Jona Löneke Have you considered or looked at Model Mapping? This allows you to map one dimension to another so that a single slicer can affect analytic content from different models or different…
- VP Product Management
- Ian_Macdonald
- 2 wk ago
- 2
- Questions & Answers
- Reported - view
Re: Interaction between P&L and waterfall chart
Hi @Jona Löneke Yes, this is possible, You will need to use a dynamic set driven by a parameter that returns the children of the selected row in the Accounts hierarchy.…
- VP Product Management
- Ian_Macdonald
- 2 wk ago
- Questions & Answers
- Reported - view
Re: Is it possible to do a "Count IF" in a Dynamic Text data set?
Bah! @imbar beat me to it. Had exactly the same Loop() code as him! Ian
- VP Product Management
- Ian_Macdonald
- 2 wk ago
- Questions & Answers
- Reported - view
Re: Union of custom columns (Static Values)
Hi @Ananth Periyasamy I have a workaround for this, although it does require the forthcoming release, 2025.01, which supports the StrtoSet() function for Measures. Prior to 2025.…
- VP Product Management
- Ian_Macdonald
- 2 wk ago
- Questions & Answers
- Reported - view
Re: Text indicator to show % change from previous period
@Ricky Melamed Have a read of this Help page and this page for an example. hope that helps. Ian
- VP Product Management
- Ian_Macdonald
- 1 mth ago
- Questions & Answers
- Reported - view
Re: Add a column that shows previous year, YTD.
Hi @Ricky Melamed It works fine for me: Make sure you've saved your Discover before putting it on the Present slide. For the list, select your Years individually in the Standard List block (don't use…
- VP Product Management
- Ian_Macdonald
- 1 mth ago
- 1
- Questions & Answers
- Reported - view
Re: Add a column that shows previous year, YTD.
Hi @Ricky Melamed This is not the right way to think about this type of calculation. It is a semantic calculation, not a table row calculation. I.e. it uses the dimensional model in order to perform…
- VP Product Management
- Ian_Macdonald
- 1 mth ago
- Questions & Answers
- Reported - view
Re: Add a column that shows previous year, YTD.
Hi @Ricky Melamed Taking my assumption above as true, there are numerous ways you can achieve this, here's one of them. Create a new Formulate calculation against your model and drag the "Current…
- VP Product Management
- Ian_Macdonald
- 1 mth ago
- 1
- Questions & Answers
- Reported - view
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
- 1 mth 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
- 1 mth 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
- 1 mth 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
- 1 mth 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
- 1 mth 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
- 1 mth 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
- 1 mth 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
- 1 mth 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 1 mth ago
- 104
- 2
- 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
- 1 mth 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
- 1 mth 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
- 1 mth ago
- Questions & Answers
- Reported - view

1 2 3 4 5 24

Back to top

Home

View all topics