Ian Macdonald's Profile - Pyramid Analytics Community Forum

Badges

Company

Pyramid Analytics

Country

Latest Posts

Re: Sequential sorting of a single dimension by multiple measures
Hi Dave, The simple answer is yes and no! If you are connected to an MDX source (SSAS OLAP, Tabular or SAP BW) then the answer is yes. It will require scripting a dynamic list through Formulate in…
- Senior Director of Product
- Ian_Macdonald
- 1 yr ago
- Questions & Answers
- Reported - view
Re: Export date member column to excel as date and not Text
Hi Farhat, By "date column formatted as date and not text" I presume you mean in Excel's internal representation of dates. Excel stores dates as the number of days since 1900-01-01,…
- Senior Director of Product
- Ian_Macdonald
- 1 yr ago
- 3
- Questions & Answers
- Reported - view
Re: Preview the Publication
Hi Siva, There is no Preview option, but as the authoring experience is wysiwyg, it shouldn't really be necessary. If you need to test the slicers, running it interactively with one slicer value…
- Senior Director of Product
- Ian_Macdonald
- 1 yr ago
- Questions & Answers
- Reported - view
Re: Gantt chart?
Hi, To confirm, Gantt charts will be available in the Marketplace with Pyramid 2023. Ian
- Senior Director of Product
- Ian_Macdonald
- 1 yr ago
- 1
- Questions & Answers
- Reported - view
Re: Use a formulate to set the default parameter value
Hi Nick, As the default month (last month) will vary as the months go by, the options for the default parameter value don't let you dynamically change the default value.…
- Senior Director of Product
- Ian_Macdonald
- 1 yr ago
- 1
- Questions & Answers
- Reported - view
Re: From and To Parameters not working in dashboard.
Hi Nick, Make sure that only one of the target parameters is selected in the interaction. you can see here that both target parameters are selected, leading to the warning:…
- Senior Director of Product
- Ian_Macdonald
- 1 yr ago
- Questions & Answers
- Reported - view
Re: How to save the Analysis measures.
Hi @siva sankar, The only way I know to access the Forecast Values is via Dynamic Text in Present and Publish. It is not accessible in Formulate for the reason I specified above. Hope that helps. Ian
- Senior Director of Product
- Ian_Macdonald
- 1 yr ago
- Questions & Answers
- Reported - view
Re: How to save the Analysis measures.
Hi @Ove Sandau Not currently. The idea behind context calculations is that they are quick and easy, but limited in scope to the current query. If you want more sophisticated calculations,…
- Senior Director of Product
- Ian_Macdonald
- 1 yr ago
- Questions & Answers
- Reported - view
Re: Connecting with Anaplan
Hi Sean, We don't have an Anaplan connector and accessing data within Anaplan would seem to be achieved by use of their API. You can use the Python Source Block in model to write a routine to…
- Senior Director of Product
- Ian_Macdonald
- 1 yr ago
- Questions & Answers
- Reported - view
Re: Send Multiple discovery in single Excel sheet
Hi Viji, No, this is the way it works by design. It is designed as a "Data Export" rather then a formatted Excel report export. It is expected that the data tables produced will in some way be used…
- Senior Director of Product
- Ian_Macdonald
- 1 yr ago
- Questions & Answers
- Reported - view
Re: How to save the Analysis measures.
Hi Siva, The reason you cannot share these calculations is because they are "Context" calculations, i.e. they are calculated within the scope of the query results.…
- Senior Director of Product
- Ian_Macdonald
- 1 yr ago
- Questions & Answers
- Reported - view
How to bring up a second filter/slicer when selections are made in the first one?

In a recent Question on the Q&A Section from @Rory Sinclair we got asked: How to build the report so that choosing a particular selection in a slicer in a present brings up a secondary slicer based…
- Senior Director of Product
- Ian_Macdonald
- updated 1 yr ago
- 56
- 1
- Present
Re: "Classic Pivot table" design
Hi Niclas, You cannot use the different levels in the hierarchy as individual attributes in this way. In most well designed Cubes, if there is a hierarchy of attributes,…
- Senior Director of Product
- Ian_Macdonald
- 1 yr ago
- Questions & Answers
- Reported - view
Re: "Classic Pivot table" design
Hi Niclas, Just drop your additional hierarchies / attributes into your Rows DropZone: Hope that helps. Ian
- Senior Director of Product
- Ian_Macdonald
- 1 yr ago
- Questions & Answers
- Reported - view
Pyramid 2023 Limited Testing Program release 2 available now!

I’m pleased to inform our customers that the Pyramid 2023 “Archimedes” Limited Testing Program Release 2 (LTP2) is now available for download. This release has many fixes for customer reported…
- Senior Director of Product
- Ian_Macdonald
- updated 1 yr ago
- 145
- Product Announcements
Re: Can I bring up a second filter/slicer when certain selections are made in an initial one?
Hi anonymous client, Sorry, I misunderstood your requirements. Yes, you can cascade slicers (filters) in any way you choose. Trick here is use parameter driven dynamic sets, i.e.…
- Senior Director of Product
- Ian_Macdonald
- 1 yr ago
- Questions & Answers
- Reported - view
Re: Install or Add new Python packages
And a direct link to the PDF that details this: https://community.pyramidanalytics.com/media/download/80jac9/Pyramid_TipsandTricks_January2023.pdf
- Senior Director of Product
- Ian_Macdonald
- 1 yr ago
- Questions & Answers
- Reported - view
Re: Can I bring up a second filter/slicer when certain selections are made in an initial one?
Hi Rory, Yes, it's possible, but requires a little bit of configuration. Effectively, we are wanting to perform conditional content display. I.e., as you say,…
- Senior Director of Product
- Ian_Macdonald
- 1 yr ago
- 3
- Questions & Answers
- Reported - view
Re: CSV File Export - Scientific Format
Hi Yakov, I've found an S3 resource and written a CSV file to it and when reading it out again, my numbers are normal, not scientific notation. Can you share the model data flow that you are using?…
- Senior Director of Product
- Ian_Macdonald
- 1 yr ago
- 1
- Questions & Answers
- Reported - view
Re: CSV File Export - Scientific Format
Hi Yakov, I can't reproduce your problem. In my tests the numbers always come out as I see them in preview when output to CSV. I've tried Float, Double and Decimal (38.…
- Senior Director of Product
- Ian_Macdonald
- 1 yr ago
- Questions & Answers
- Reported - view
Re: Data Model - ML - Linear Regression
Hi Jyotsna, There isn't a prebuilt block for Linear Regression. Instead, use the "Market Place" block and search the tags for Regression, then download the LR Python script. Hope that helps. Ian
- Senior Director of Product
- Ian_Macdonald
- 1 yr ago
- 1
- Questions & Answers
- Reported - view
Re: Database Training Model Error
Hi David, It looks like there is something wrong with your installation / configuration. I suggest you open a ticket with our support team who are better placed to help you trouble shoot your issues…
- Senior Director of Product
- Ian_Macdonald
- 1 yr ago
- Questions & Answers
- Reported - view
Re: Bell curve graph
Hi Heide, Do you have some examples you can share of what you are trying to achieve? Your request for help is a bit vague at the moment, so anything you can share to illustrate what you are wanting…
- Senior Director of Product
- Ian_Macdonald
- 1 yr ago
- Questions & Answers
- Reported - view
Re: Sourcing Reporting Services Output in a Data Model
Hi Jason, You can configure a SSRS report as an Atom Data Feed. https://learn.microsoft.com/en-us/sql/reporting-services/report-builder/generate-data-feeds-from-a-report-report-builder-and-ssrs?…
- Senior Director of Product
- Ian_Macdonald
- 1 yr ago
- Questions & Answers
- Reported - view
Re: Restricting Access based on User rather than Role
Hi Rory, Content in Pyramid is secured by Role membership. It is not possible to define access to Content Folders by individual user. Hope that helps. Ian
- Senior Director of Product
- Ian_Macdonald
- 1 yr ago
- 1
- Questions & Answers
- Reported - view

1 9 10 11 12 13 22

Welcome to the Pyramid User Community

Pyramid User Community

Ian Macdonald

Re: Sequential sorting of a single dimension by multiple measures

Re: Export date member column to excel as date and not Text

Re: Preview the Publication

Re: Gantt chart?

Re: Use a formulate to set the default parameter value

Re: From and To Parameters not working in dashboard.

Re: How to save the Analysis measures.

Re: How to save the Analysis measures.

Re: Connecting with Anaplan

Re: Send Multiple discovery in single Excel sheet

Re: How to save the Analysis measures.

How to bring up a second filter/slicer when selections are made in the first one?

Re: "Classic Pivot table" design

Re: "Classic Pivot table" design

Pyramid 2023 Limited Testing Program release 2 available now!

Re: Can I bring up a second filter/slicer when certain selections are made in an initial one?

Re: Install or Add new Python packages

Re: Can I bring up a second filter/slicer when certain selections are made in an initial one?

Re: CSV File Export - Scientific Format

Re: CSV File Export - Scientific Format

Re: Data Model - ML - Linear Regression

Re: Database Training Model Error

Re: Bell curve graph

Re: Sourcing Reporting Services Output in a Data Model

Re: Restricting Access based on User rather than Role

Home