Ian Macdonald's Profile - Pyramid Analytics Community Forum

Badges

Company

Pyramid Analytics

Country

Latest Posts

Re: Multi Select (All) parameters
Hi Nick, Best way to accomplish this would be to construct a dynamic List of the items in your Hierarchy thus: Then use this list, M List in this case, to populate the slicer or parameter.…
- Senior Director of Product
- Ian_Macdonald
- 2 yrs ago
- Questions & Answers
- Reported - view
Re: Display "all" in dynamic text when user selects all options in multiselect dropdown
Hi Rob, Not directly. What you could do is to measure the length of the string returned when All is selected, then if that length is found, set the text to "All Selected" otherwise the list of those…
- Senior Director of Product
- Ian_Macdonald
- 2 yrs ago
- Questions & Answers
- Reported - view
Re: Group By option for grids
Actually, it is easier to override the background colour drop zone formatting using the grid formatting options:
- Senior Director of Product
- Ian_Macdonald
- 2 yrs ago
- Questions & Answers
- Reported - view
Re: Using Variables with strings in Master flow
Hi @Niko Z Did Shai's solution work for you? Thanks, Ian
- Senior Director of Product
- Ian_Macdonald
- 2 yrs ago
- Questions & Answers
- Reported - view
Re: Group By option for grids
Hi Sophie, Yes. I think ability to hide rows / columns would be useful in a number of scenarios. But, I do have an alternative solution for you. If you drop the transaction id into the Color drop…
- Senior Director of Product
- Ian_Macdonald
- 2 yrs ago
- Questions & Answers
- Reported - view
Re: Group By option for grids
Hi Sophie, Unfortunately I can see no way to achieve this. In order to see the individual transactions, then the transaction id must be present in the report,…
- Senior Director of Product
- Ian_Macdonald
- 2 yrs ago
- Questions & Answers
- Reported - view
Re: Selection set under Data Point not possible
Hi Maaike, As the list you are counting is in the Transactions dimension, by default that is where the custom member will be placed. If you want it to be a measure,…
- Senior Director of Product
- Ian_Macdonald
- 2 yrs ago
- Questions & Answers
- Reported - view
Re: Selection set under Data Point not possible
Hi Maaike, What is the formula you are trying to create? A data point or Tuple or Record cannot have a list of members as an argument. If it did it would effectively represent a set of data points,…
- Senior Director of Product
- Ian_Macdonald
- 2 yrs ago
- Questions & Answers
- Reported - view
Re: blank row in between different values
Hi Nicholas, Yes. Here's an example. I've created a custom measure called null, set to null. A few things to note: I've used specific row formatting for the null custom measure,…
- Senior Director of Product
- Ian_Macdonald
- 2 yrs ago
- 1
- Questions & Answers
- Reported - view
Re: Measures/Dimensions caption translation
It also shows up when use the Values Chip in the filter Drop Zone:
- Senior Director of Product
- Ian_Macdonald
- 3 yrs ago
- Questions & Answers
- Reported - view
Re: Measures/Dimensions caption translation
Hi Sergio, Just noticed you're using OLAP cubes. I retested and it works exactly the same for OLAP. Do make sure though that you have checked the "Use Security and Metadata overlays" option on the…
- Senior Director of Product
- Ian_Macdonald
- 3 yrs ago
- Questions & Answers
- Reported - view
Re: Measures/Dimensions caption translation
Hi Sergio, I have no problem doing this using 2020.20. Create Role, Italian, add that Role to the model settings, make user a member of that Role, set Net Margin to be Margine netto for that role…
- Senior Director of Product
- Ian_Macdonald
- 3 yrs ago
- Questions & Answers
- Reported - view
Re: Export/Publish to google spreadsheets
Hi Olaf, Not currently. Please make an entry in the product Ideas forum for this enhancement request and we can gauge the popularity from the votes there. Hope that helps. Ian
- Senior Director of Product
- Ian_Macdonald
- 3 yrs ago
- Questions & Answers
- Reported - view
Re: Cell bars are displayed incorrectly in case the Grand Total is switched on
Marking this as answered since there has been no response to requests for further information.
- Senior Director of Product
- Ian_Macdonald
- 3 yrs ago
- Questions & Answers
- Reported - view
Re: Calculate a dimension value (numeric)
Marking this as answered since there has been no response to requests for further information.
- Senior Director of Product
- Ian_Macdonald
- 3 yrs ago
- Questions & Answers
- Reported - view
Re: Measures/Dimensions caption translation
Marking this as answered since there has been no response to requests for further information.
- Senior Director of Product
- Ian_Macdonald
- 3 yrs ago
- Questions & Answers
- Reported - view
Re: Presentation has no charts due to measures calculated
Marking this as answered since there has been no response to requests for further information.
- Senior Director of Product
- Ian_Macdonald
- 3 yrs ago
- Questions & Answers
- Reported - view
Re: How Do I Use A Small Font Size In Questions And Answers?
Marking this as answered since there has been no response to requests for further information.
- Senior Director of Product
- Ian_Macdonald
- 3 yrs ago
- Questions & Answers
- Reported - view
Re: Calculating a CLV measure
Marking this as answered since there has been no response.
- Senior Director of Product
- Ian_Macdonald
- 3 yrs ago
- Questions & Answers
- Reported - view
Re: Scheduled Model Refresh not showing under Schedule Listing
Hi Dan, David, Can you please let us know what version of Pyramid you are using where you see this behaviour? Thanks, Ian
- Senior Director of Product
- Ian_Macdonald
- 3 yrs ago
- Questions & Answers
- Reported - view
Re: Date Parameter Slicer Issues
@Jon Wright Great!
- Senior Director of Product
- Ian_Macdonald
- 3 yrs ago
- Questions & Answers
- Reported - view
Re: Adding Hyperlink to text in Publish
Hi Aaron, Use the HyperLink() function in dynamic text: I know you said "no code", but this is very simple! You will need a query associated with the dynamic Text,…
- Senior Director of Product
- Ian_Macdonald
- 3 yrs ago
- Questions & Answers
- Reported - view
Re: Date Parameter Slicer Issues
Hi Jon, Apologies that this has gone unanswered for so long. Is this still relevant or have you resolved your issues? Thanks, Ian
- Senior Director of Product
- Ian_Macdonald
- 3 yrs ago
- Questions & Answers
- Reported - view
Re: Cell bars are displayed incorrectly in case the Grand Total is switched on
Hi Markus, Please retest in the current version (2020.20). Regards, Ian
- Senior Director of Product
- Ian_Macdonald
- 3 yrs ago
- Questions & Answers
- Reported - view
Re: Calculate a dimension value (numeric)
Hi Nicholas, It's been some time since you posted, is this still relevant to you? If you can relate your currency and date and value to convert, then yes, it should be straightforward calculation.…
- Senior Director of Product
- Ian_Macdonald
- 3 yrs ago
- Questions & Answers
- Reported - view

1 13 14 15 16 17 22

Welcome to the Pyramid User Community

Pyramid User Community

Ian Macdonald

Re: Multi Select (All) parameters

Re: Display "all" in dynamic text when user selects all options in multiselect dropdown

Re: Group By option for grids

Re: Using Variables with strings in Master flow

Re: Group By option for grids

Re: Group By option for grids

Re: Selection set under Data Point not possible

Re: Selection set under Data Point not possible

Re: blank row in between different values

Re: Measures/Dimensions caption translation

Re: Measures/Dimensions caption translation

Re: Measures/Dimensions caption translation

Re: Export/Publish to google spreadsheets

Re: Cell bars are displayed incorrectly in case the Grand Total is switched on

Re: Calculate a dimension value (numeric)

Re: Measures/Dimensions caption translation

Re: Presentation has no charts due to measures calculated

Re: How Do I Use A Small Font Size In Questions And Answers?

Re: Calculating a CLV measure

Re: Scheduled Model Refresh not showing under Schedule Listing

Re: Date Parameter Slicer Issues

Re: Adding Hyperlink to text in Publish

Re: Date Parameter Slicer Issues

Re: Cell bars are displayed incorrectly in case the Grand Total is switched on

Re: Calculate a dimension value (numeric)

Home