Ian Macdonald's Profile - Pyramid Analytics Community Forum

Badges

Company

Pyramid Analytics

Country

Latest Posts

Re: Managing Bookmarks when Replacing a Present
Hi @Heinrich Nel Closing this thread as no response after more than 3 months. Please reopen / reply to this post if further information is required. Ian
- Senior Director of Product
- Ian_Macdonald
- 3 mths ago
- Questions & Answers
- Reported - view
Re: Is there a way to view expired conversations?
Hi @Robert Clark The conversations are stored in the Pyramid repository, but currently are not exposed in any formal way. You could dig around in the repository tables to try and find them,…
- Senior Director of Product
- Ian_Macdonald
- 3 mths ago
- Questions & Answers
- Reported - view
Re: How to get the SQL text of the executed SQL Query Node into a variable
Hi @Kush Maniar It would seem not. Closing this thread as no response after 1 month. Please reopen / reply to this post if further information is required. Ian
- Senior Director of Product
- Ian_Macdonald
- 3 mths ago
- Questions & Answers
- Reported - view
Re: How to Identify Pyramid Workflows that are Using Python Scripts
hi @Raveena Mariappan , It would seem not. Closing this thread as no response after 1 month. Please reopen / reply to this post if further information is required. Ian
- Senior Director of Product
- Ian_Macdonald
- 3 mths ago
- Questions & Answers
- Reported - view
Re: Incorrect handling of strings with different cases in in-memory
@TKH TKH reloading or restarting?
- Senior Director of Product
- Ian_Macdonald
- 3 mths ago
- Questions & Answers
- Reported - view
Re: Incorrect handling of strings with different cases in in-memory
@TKH TKH Did you restart the IMDB Server after changing the .ini file? Ian
- Senior Director of Product
- Ian_Macdonald
- 3 mths ago
- Questions & Answers
- Reported - view
Re: Advanced Totals: Only sum up current turnover of a year
Hi @Jona Löneke When you have different Measures in your grid, you can change the totals logic and/or suppress totals for specific Measures. However, we can't do that when it is the same Measure,…
- Senior Director of Product
- Ian_Macdonald
- 3 mths ago
- Questions & Answers
- Reported - view
Re: Download Pyramid Discovers on a schedule to an OS folder
Hi @Mad Amruthur No, the identity that the Pyramid Server is running under. If you're running it on a Windows server, it will likely be the machine name on the network.…
- Senior Director of Product
- Ian_Macdonald
- 3 mths ago
- Questions & Answers
- Reported - view
Re: YTD and Prior YTD Measures
BTW, This cumulative measure can be used in conjunction with Year and other time period filters to show the cumulative total (YTD): Ian
- Senior Director of Product
- Ian_Macdonald
- 3 mths ago
- 1
- Questions & Answers
- Reported - view
Re: YTD and Prior YTD Measures
Hi @Daniel Van Wyk We can take a different approach to this. Essentially a YTD function returns the cumulative value of the measure. starting at beginning of the Year.…
- Senior Director of Product
- Ian_Macdonald
- 3 mths ago
- 2
- Questions & Answers
- Reported - view
Re: Download Pyramid Discovers on a schedule to an OS folder
Hi @Mad Amruthur It is the Pyramid Server that needs rights to the folder, as well as you, the user. Hope that helps. Ian
- Senior Director of Product
- Ian_Macdonald
- 3 mths ago
- Questions & Answers
- Reported - view
Re: Calculating a Rolling Average Containing Empty Values
Hi @John Fonte@Michael Daun@Vijayan Krishnan In some circumstances you can also use the built in "Fill the Blanks" function in Discover. Here we have Returns by full week with Show Empties on:…
- Senior Director of Product
- Ian_Macdonald
- 3 mths ago
- Questions & Answers
- Reported - view
Re: Download Pyramid Discovers on a schedule to an OS folder
Hi @Mad Amruthur , You can subscribe to a discover and create a schedule whereby the output in Excel format is automatically sent to you, but only via the Pyramid Bulletin board,…
- Senior Director of Product
- Ian_Macdonald
- 3 mths ago
- Questions & Answers
- Reported - view
Re: Incorrect handling of strings with different cases in in-memory
Hi @TKH TKH Also, remember that the Pyramid semantic model is a multidimensional model and is using the Strings column to create a DIMENSION (or Attribute if you prefer) in its dimensional model,…
- Senior Director of Product
- Ian_Macdonald
- 3 mths ago
- Questions & Answers
- Reported - view
Re: how to ALTER in-Memory DB table and add new columns?
Hi @anonymous client , IMDB is a compressed, column-store in-memory relational database. The important bit here is the "compressed, column-store". This means the data has been compressed and the…
- Senior Director of Product
- Ian_Macdonald
- 4 mths ago
- Questions & Answers
- Reported - view
Re: Rolling average on a switch list
Hi @Katie Easton , No, you cannot insert a Measure List into a DataPoint. However, you can insert a Parameter into a DataPoint that is built using a List of Measures.…
- Senior Director of Product
- Ian_Macdonald
- 4 mths ago
- Questions & Answers
- Reported - view
Re: Rolling average on a switch list
Hi @Katie Easton , In what hierarchy is your calculation residing? Pyramid is able to create calculations in all hierarchies, not just Measures. Check where your calculation is located and search…
- Senior Director of Product
- Ian_Macdonald
- 4 mths ago
- Questions & Answers
- Reported - view
Re: Loading present via URL with filters and targets….but cross model mapping needs to be tailored
Hi @anonymous client Have you tested this in isolation? I.e., just the cross model mapping from the Discover without mini tabs or anything? Does that work? Once it does,…
- Senior Director of Product
- Ian_Macdonald
- 4 mths ago
- Questions & Answers
- Reported - view
Re: A quirk when installing Pyramid on Linux - Host Name Issue
Hi @Dmitri Kanounnikov , Thanks for the 'heads-up'! Ian
- Senior Director of Product
- Ian_Macdonald
- 4 mths ago
- Questions & Answers
- Reported - view
Re: Automatically save Present filters to original discovery report
hi @Rebeca Figueroa , I'm still confused by this and I don't see any answers to my questions here. Can you please explain the precise process you want to achieve? Thanks, Ian
- Senior Director of Product
- Ian_Macdonald
- 4 mths ago
- Questions & Answers
- Reported - view
Re: Automatically save Present filters to original discovery report
Hi @Rebeca Figueroa I'm not sure what '"Present" mojo' means. Can you explain the scenario you are working with and why you need to do this? Are you talking about edit or run time in Present? Thanks,…
- Senior Director of Product
- Ian_Macdonald
- 4 mths ago
- Questions & Answers
- Reported - view
Re: Log Storage Table in Pyramid Repository Database
Hi@Raveena Mariappan , As of Pyramid 2023, as part of the install routine, we shipped a Pyramid Usage Model, which mapped certain tables from our repository containing the logs to a Pyramid Direct…
- Senior Director of Product
- Ian_Macdonald
- 4 mths ago
- Questions & Answers
- Reported - view
Re: Fixed Static Parameter
Here's the Custom Column script to create the Binned Values attribute: CASE([SalesData].[Sales]*5>=1 && [SalesData].[Sales]*5<=1000, "1 - 1,000",[SalesData].[Sales]*5>=1001 && [SalesData].…
- Senior Director of Product
- Ian_Macdonald
- 4 mths ago
- 2
- Questions & Answers
- Reported - view
Re: Fixed Static Parameter
As a KPI: Cheers!
- Senior Director of Product
- Ian_Macdonald
- 4 mths ago
- 1
- Questions & Answers
- Reported - view
Re: Fixed Static Parameter
Hi @Len Stockdale Create a new Custom Column in Formulate. Create a CASE statement that inspects the value of No. Rows in your situation, Sales*5 (to get a suitable range of values) in my scenario,…
- Senior Director of Product
- Ian_Macdonald
- 4 mths ago
- Questions & Answers
- Reported - view

1 2 3 4 5 22

Welcome to the Pyramid User Community

Pyramid User Community

Ian Macdonald

Re: Managing Bookmarks when Replacing a Present

Re: Is there a way to view expired conversations?

Re: How to get the SQL text of the executed SQL Query Node into a variable

Re: How to Identify Pyramid Workflows that are Using Python Scripts

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

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

Re: Advanced Totals: Only sum up current turnover of a year

Re: Download Pyramid Discovers on a schedule to an OS folder

Re: YTD and Prior YTD Measures

Re: YTD and Prior YTD Measures

Re: Download Pyramid Discovers on a schedule to an OS folder

Re: Calculating a Rolling Average Containing Empty Values

Re: Download Pyramid Discovers on a schedule to an OS folder

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

Re: how to ALTER in-Memory DB table and add new columns?

Re: Rolling average on a switch list

Re: Rolling average on a switch list

Re: Loading present via URL with filters and targets….but cross model mapping needs to be tailored

Re: A quirk when installing Pyramid on Linux - Host Name Issue

Re: Automatically save Present filters to original discovery report

Re: Automatically save Present filters to original discovery report

Re: Log Storage Table in Pyramid Repository Database

Re: Fixed Static Parameter

Re: Fixed Static Parameter

Re: Fixed Static Parameter

Home