Ian Macdonald's Profile - Pyramid Analytics Community Forum

Skip to main content

User Community

Badges

Company

Pyramid Analytics

Country

Latest Posts

Re: How to Show Multiple Grand Totals without Repeating Measure Under Each Column
Hi @Luke Dyer The trick here is make sure that your calculated totals are placed in the Date dimension, rather than the Measure dimension and specify the Measure to be used.…
- VP Product Management
- Ian_Macdonald
- 7 days ago
- 1
- Questions & Answers
- Reported - view
Re: Add "Select All" Option to Multi Select Tree
@TKH TKH Please submit in Current Ideas Forum. Thanks. Ian
- VP Product Management
- Ian_Macdonald
- 11 days ago
- Questions & Answers
- Reported - view
Re: Allow users to view model processing logs with out having admin rights
Hi @Michael Raam If this is a new / enhanced feature request, can you please submit via the Current Product Ideas forum? Thanks. Ian
- VP Product Management
- Ian_Macdonald
- 11 days ago
- Questions & Answers
- Reported - view
Re: Small Number Suppression for charts
Hi @James Santos Can you show examples what you've done with grids and how it doesn't apply to charts? Thanks, Ian
- VP Product Management
- Ian_Macdonald
- 11 days ago
- Questions & Answers
- Reported - view
Re: Is there a way to view the lineage data as a table ?
Hi @Michael Raam , Not currently. Have you tried using the new(ish) JSON Extract block in model? It's in the Column Operations section. Hope that helps. Ian
- VP Product Management
- Ian_Macdonald
- 11 days ago
- Questions & Answers
- Reported - view
Re: Parent-Child Sales Aggregation Issue
Hi @Raveena Mariappan Firstly, I would question your data modelling here. Presented with your dataset 2 as a table, all database systems will return 120 for the total Sales.…
- VP Product Management
- Ian_Macdonald
- 11 days ago
- Questions & Answers
- Reported - view
Re: Technical Questions on LLM/GenAI Architecture and Data Flow
Hi All, See my response inline below: What data is sent? When a GenAI feature is used, what exactly is included in the payload sent to the external LLM provider? For example,…
- VP Product Management
- Ian_Macdonald
- 3 wk ago
- 1
- Questions & Answers
- Reported - view
Re: Allow users to view model processing logs with out having admin rights
Hi @Michael Raam If they can't create schedules, what's the point of them seeing the logs? They won't be able to do anything about any issues... Confused. Ian
- VP Product Management
- Ian_Macdonald
- 3 wk ago
- Questions & Answers
- Reported - view
Re: Dynamic week formula
Hi @Lars Tintelnot In the absence of a reply to my question, I'll assume that the days to add up can cross month boundaries. We need to identify the day of the week form your Date Field.…
- VP Product Management
- Ian_Macdonald
- 3 wk ago
- Questions & Answers
- Reported - view
Re: Can I have list of all the cshids used to divert help button
Hi @Nandita Gupta We've shared the list with you by Private Email. Hope that helps. Ian
- VP Product Management
- Ian_Macdonald
- 3 wk ago
- Questions & Answers
- Reported - view
Re: Dynamic week formula
Hi @Lars Tintelnot When you say "The logic should also respect month and year change" what do you mean by that? That the results should only include dates WITHIN a particular month / year?…
- VP Product Management
- Ian_Macdonald
- 3 wk ago
- Questions & Answers
- Reported - view
Re: Allow users to view model processing logs with out having admin rights
Hi @Michael Raam IF the users have a scheduled model they can view the activity through the Schedule Manager. They obviously can't view other people's schedules,…
- VP Product Management
- Ian_Macdonald
- 3 wk ago
- Questions & Answers
- Reported - view
Re: Can I have list of all the cshids used to divert help button
Hi @Nandita Gupta I need to check two things: 1. Can we easily export the list from our Help authoring software (it will be a very long list!)? 2. Are we happy to share it? I'll get back to you.…
- VP Product Management
- Ian_Macdonald
- 4 wk ago
- Questions & Answers
- Reported - view
Re: Reset query context on a click action
No reply after two months, so setting status to answered.
- VP Product Management
- Ian_Macdonald
- 1 mth ago
- Questions & Answers
- Reported - view
Re: "Last N Weeks" Function in Calendar Slicer is Misleading
Hi @TKH TKH If you consider this to be a bug, then please open a support ticket on this topic. If you are making an enhancement request, please repost in the Current Product Ideas Forum.…
- VP Product Management
- Ian_Macdonald
- 1 mth ago
- 1
- Questions & Answers
- Reported - view
Re: Workflow Versioning
@Stefano Sena If you edit a Data Model and simply save it as new version, then you are simply saving your edits to the Model and not overwriting the previous version.…
- VP Product Management
- Ian_Macdonald
- 1 mth ago
- 2
- Questions & Answers
- Reported - view
Re: Service Instance Memory Limits
Hi @Mad Amruthur ,@Surya Sankar Note also that there are limits to what can be exported to Excel based on the capacity of the client machine connected to Pyramid.…
- VP Product Management
- Ian_Macdonald
- 1 mth ago
- Questions & Answers
- Reported - view
Re: Can I have list of all the cshids used to divert help button
Hi @Nandita Gupta I'm not sure what you are asking for. Can you explain a bit more? Thanks, Ian
- VP Product Management
- Ian_Macdonald
- 1 mth ago
- Questions & Answers
- Reported - view
Re: Workflow Versioning
Hi @Stefano Sena Read this Help page and come back here if you have any further questions. Generally, Save as New Version will do exactly that, it will create a new version and NOT overwrite the…
- VP Product Management
- Ian_Macdonald
- 1 mth ago
- Questions & Answers
- Reported - view
Re: Hide or Unhide Slicers
Hi @Linda Cowie ,@Ove Sandau Ove is right, this is the right way to approach this. Take a look at this Help page for more detailed examples of how to set it up. Hope that helps! Ian
- VP Product Management
- Ian_Macdonald
- 2 mths ago
- Questions & Answers
- Reported - view
Re: Binary Code to HTML in Pyramid
Hi @RAJESH Gonuguntla This is not currently possible. Sorry about that. Ian
- VP Product Management
- Ian_Macdonald
- 2 mths ago
- 1
- Questions & Answers
- Reported - view
Re: Minimum Date
Hi @Daniel Quinonez You can create these Measures directly from your Date Attribute. Right click on your Date, select Aggregate, then Min or Max. This will generate the min or max date for anything…
- VP Product Management
- Ian_Macdonald
- 2 mths ago
- 1
- Questions & Answers
- Reported - view
Re: Is there a way to show a measure only once when we have repeating dimension values?
Hi @Robert Clark Make sure your subtotal settings are set to AGGREGATE and not SUM and it should give you the right answer. Hope that helps. Ian
- VP Product Management
- Ian_Macdonald
- 2 mths ago
- 1
- Questions & Answers
- Reported - view
Re: Minimum Date
Hi @Daniel Quinonez The easiest way to achieve this is to create a Measure from your Date dimension in your model and use the Minimum aggregation method.…
- VP Product Management
- Ian_Macdonald
- 2 mths ago
- 1
- Questions & Answers
- Reported - view
Re: Using Regular Expressions to replace
Hi @Stefano Sena Not directly in the Replace block. As you illustrate, you can use Regular Expressions to search for strings, but not use them to replace.…
- VP Product Management
- Ian_Macdonald
- 2 mths ago
- Questions & Answers
- Reported - view

1 2 3 4 5 28

Back to top

Home

View all topics