Ian Macdonald's Profile - Pyramid Analytics Community Forum

Badges

Company

Pyramid Analytics

Country

Latest Posts

Re: Seeking to Apply Security to End Users on 'Analyze Further' option for discovery
Hi @Alexander Khater Rather than restricting the content based on calculated filters etc., where you need to restrict access to specific rows based on the user id,…
- Senior Director of Product
- Ian_Macdonald
- 3 days ago
- Questions & Answers
- Reported - view
Re: Improved Support for Data Models with Different Granularities
Hi @TKH TKH Why complicate things with a bridge table? It's not needed. Just join your calendar table to your Actuals by Date and your Plan by Month, either the 1st of the month date or the year…
- Senior Director of Product
- Ian_Macdonald
- 11 days ago
- Questions & Answers
- Reported - view
Re: Headcount from the previous month automatically updated on the 1st of the month
Hi @Frédéric WILHELM Here's a solution using dynamic lists. It relies on the fact that you never have a headcount measure value for a future date. Create a Formulate list using your model.…
- Senior Director of Product
- Ian_Macdonald
- 2 wk ago
- Questions & Answers
- Reported - view
Re: Headcount from the previous month automatically updated on the 1st of the month
Hi @Frédéric WILHELM From your post and the code you quoted, I deduce that you are working with Analysis Services using MDX. Analysis Services does not have a DateTime data type.…
- Senior Director of Product
- Ian_Macdonald
- 2 wk ago
- Questions & Answers
- Reported - view
Re: Headcount from the previous month automatically updated on the 1st of the month
Hi @Frédéric WILHELM Just to clarify, you want the headcount as of the previous DAY, or the headcount of the previous MONTH? Do you have an existing Measure of headcount? If you do,…
- Senior Director of Product
- Ian_Macdonald
- 2 wk ago
- Questions & Answers
- Reported - view
Re: Having trouble to make an average over a created column
Hi @Friedrich Schmid , OK. Your issue in your example is that you are basing the last six months off the current member, which is defined by your slicer.…
- Senior Director of Product
- Ian_Macdonald
- 2 wk ago
- Questions & Answers
- Reported - view
Re: Having trouble to make an average over a created column
hi, @Friedrich Schmid Are you wanting to display the average across six months for each day of the month? So for example, the average value of Day 1 over the six months? Please clarify. Thanks, Ian
- Senior Director of Product
- Ian_Macdonald
- 3 wk ago
- Questions & Answers
- Reported - view
Re: String Display
@Sanjai Sorry, I missed a "d" in the function name. It should be FormattedData(0,3) If you right click on the cell in question, you can pick the function off the list.
- Senior Director of Product
- Ian_Macdonald
- 3 wk ago
- Questions & Answers
- Reported - view
Re: IN operator in Pyramid Formulate (Custom Column)
Hi @Mad Amruthur , Try HasItem(). See Help: https://help.pyramidanalytics.com/Content/Root/developer/reference/fx/PQL/Common/String/HasItem.htm?Highlight=hasitem Hope that helps. Ian
- Senior Director of Product
- Ian_Macdonald
- 3 wk ago
- 1
- Questions & Answers
- Reported - view
Re: String Display
Hi @Sanjai Try FormatteData(0,3) instead. Hope that helps. Ian
- Senior Director of Product
- Ian_Macdonald
- 3 wk ago
- Questions & Answers
- Reported - view
Re: Incorrect handling of strings with different cases in in-memory
@TKH TKH It is the underlying database that defines how Pyramid's queries are interpreted. For example, when populating a slicer, you can configure if the Pyramid query uses Group By or Distinct to…
- Senior Director of Product
- Ian_Macdonald
- 3 wk ago
- 1
- Questions & Answers
- Reported - view
Pyramid 2024 LTS "Fibonacci" Released

Pyramid 2024 LTS "Fibonacci" has been released. It is a Long Term Support version designed for stable functionality with extended security maintenance, but without new features over its lifetime.…
- Senior Director of Product
- Ian_Macdonald
- updated 3 wk ago
- 192
- 5
- Product Announcements
Re: Reuse Data Models to Build other data models.
Hi @Cesar Jaitman Labaton Take your data flows for the products and finance models and change the target so that they write their tables of data to the same database.…
- Senior Director of Product
- Ian_Macdonald
- 1 mth ago
- Questions & Answers
- Reported - view
Re: Ability to make number of user inputs dynamic
Hi @Pranoy Karun Vijay , You can use the advanced search option available in multi select slicers to enter lists of values to match to the slicer values: Like Christian,…
- Senior Director of Product
- Ian_Macdonald
- 1 mth ago
- Questions & Answers
- Reported - view
Re: Is there a way to communicate with external models real-time
Hi @Pranoy Karun Vijay The short answer is no. You could potentially take your value and pass it to some external system via a parameterised HTML link in a Web window on the slide and that web page…
- Senior Director of Product
- Ian_Macdonald
- 1 mth ago
- 1
- Questions & Answers
- Reported - view
Re: Sub Total Color Formatting - to be exported in Excel
Hi @Aaron Yohannan If you take your formatted Discovery and use it to populate a Tabulate sheet, then export that as an Excel file, it will preserve the subtotal formatting. That's one option.…
- Senior Director of Product
- Ian_Macdonald
- 1 mth ago
- Questions & Answers
- Reported - view
Re: Is there a way to set a process to automatically copy a presentation from folder to another?
Hi @Jack Massey Unfortunately no, not in the general UI. This could be achieved using the Pyramid API…
- Senior Director of Product
- Ian_Macdonald
- 1 mth ago
- Questions & Answers
- Reported - view
Re: How can we give a specific colour to Subtotals in a schema?
@Michael Daun We need to understand why my approach does not work for you. That's very strange. I've got pretty close to what you are looking for: Just the grand total in bottom right hand corner to…
- Senior Director of Product
- Ian_Macdonald
- 1 mth ago
- Questions & Answers
- Reported - view
Re: How can we give a specific colour to Subtotals in a schema?
@Aaron Yohannan SubTotal formatting of background colour does not export to Excel. Ian
- Senior Director of Product
- Ian_Macdonald
- 1 mth ago
- Questions & Answers
- Reported - view
Re: Sub Total Color Formatting - to be exported in Excel
Hi @Aaron Yohannan SubTotal formatting of background colour does not export to Excel. Ian
- Senior Director of Product
- Ian_Macdonald
- 1 mth ago
- Questions & Answers
- Reported - view
Re: Access Multiselect Parameters values in Formulate
Hi @Raja Sambasivam , Unfortunately, there is no way currently to accurately retrieve the captions of selected members in a multiselect parameter. We can "manually" traverse the list of members in…
- Senior Director of Product
- Ian_Macdonald
- 1 mth ago
- 3
- Questions & Answers
- Reported - view
Re: How can we give a specific colour to Subtotals in a schema?
Hi @Aaron Yohannan , @Michael Daun is correct in that the subtotals colour is set in the grid formatting, not the theme. Click on the Format control when in the Grid sub menu:…
- Senior Director of Product
- Ian_Macdonald
- 1 mth ago
- Questions & Answers
- Reported - view
Re: How to define a Design Theme for grids with a single-color background?
Hi @Michael Daun Something like this? Theme attached. Hope that helps. Ian
Attachment
- Senior Director of Product
- Ian_Macdonald
- 1 mth ago
- Questions & Answers
- Reported - view
Re: Calculating percentiles
Hi @Jair Rangel In what context are wanting to calculate the percentile? The Percentile function returns the defined percentile from a list of values of a Measure.…
- Senior Director of Product
- Ian_Macdonald
- 1 mth ago
- 1
- Questions & Answers
- Reported - view
Re: How to create quantities sales report
Hi @Lukasz Godon Fair enough! Ok, what is your starting position? What data do you have and in what format? If you can share an example of dummy or anonymised data in the same format,…
- Senior Director of Product
- Ian_Macdonald
- 1 mth ago
- Questions & Answers
- Reported - view

1 2 3 4 5 22

Welcome to the Pyramid User Community

Pyramid User Community

Ian Macdonald

Re: Seeking to Apply Security to End Users on 'Analyze Further' option for discovery

Re: Improved Support for Data Models with Different Granularities

Re: Headcount from the previous month automatically updated on the 1st of the month

Re: Headcount from the previous month automatically updated on the 1st of the month

Re: Headcount from the previous month automatically updated on the 1st of the month

Re: Having trouble to make an average over a created column

Re: Having trouble to make an average over a created column

Re: String Display

Re: IN operator in Pyramid Formulate (Custom Column)

Re: String Display

Re: Incorrect handling of strings with different cases in in-memory

Pyramid 2024 LTS "Fibonacci" Released

Re: Reuse Data Models to Build other data models.

Re: Ability to make number of user inputs dynamic

Re: Is there a way to communicate with external models real-time

Re: Sub Total Color Formatting - to be exported in Excel

Re: Is there a way to set a process to automatically copy a presentation from folder to another?

Re: How can we give a specific colour to Subtotals in a schema?

Re: How can we give a specific colour to Subtotals in a schema?

Re: Sub Total Color Formatting - to be exported in Excel

Re: Access Multiselect Parameters values in Formulate

Re: How can we give a specific colour to Subtotals in a schema?

Re: How to define a Design Theme for grids with a single-color background?

Re: Calculating percentiles

Re: How to create quantities sales report

Home