Ian Macdonald's Profile - Pyramid Analytics Community Forum

Skip to main content

User Community

Badges

Company

Pyramid Analytics

Country

Latest Posts

Re: Identifying Duplicated Elements
Hi Jenny, This problem falls into the category that requires analysis / calculation from the underlying table of data that makes up your dimension / attributes.…
- VP Product Management
- Ian_Macdonald
- 2 yrs ago
- Questions & Answers
- Reported - view
Re: Multi-measure pie charts
Hi dgf, It is unusual in most data analytics models to have multiple Measures that together make up the total of that Measure. Usually there is a single Measure and that is split out by the Members…
- VP Product Management
- Ian_Macdonald
- 2 yrs ago
- 1
- Questions & Answers
- Reported - view
Re: Get data from 2 months ago
Hi dgf, The first thing we need to do is establish the current month and the previous month. There are many ways we could do this, but an elegant and simple way is to use your existing data to do…
- VP Product Management
- Ian_Macdonald
- 2 yrs ago
- 1
- Questions & Answers
- Reported - view
Re: Analyse Further Multiple Measures on 1 Line Chart
FYI, everybody, it ha been brought to my attention that my answer above applies to Pyramid 2023. Another good reason to upgrade! Ian
- VP Product Management
- Ian_Macdonald
- 2 yrs ago
- 2
- Questions & Answers
- Reported - view
Re: real time data refresh
@Ilya Tsyrulnik https://help.pyramidanalytics.com/Content/Root/MainClient/apps/Present/Present%20Pro/functions/Presentation%20Timer.htm?Highlight=auto%20refresh
- VP Product Management
- Ian_Macdonald
- 2 yrs ago
- 1
- Questions & Answers
- Reported - view
Re: real time data refresh
Hi Ilya, Yes, for Presentations. In the Presentation Tab menu you should find this button: Click on this and you can set either to cycle through the slides,…
- VP Product Management
- Ian_Macdonald
- 2 yrs ago
- Questions & Answers
- Reported - view
Re: Analyse Further Multiple Measures on 1 Line Chart
Hi Natalie-Anne, It works for me. When you take the second measure, hover it over the "Values" heading in the DropZone and you should get a slide off "Y2 Axis" option,…
- VP Product Management
- Ian_Macdonald
- 2 yrs ago
- Questions & Answers
- Reported - view
Re: LineBreak in a measure
Hi Michael, No, there does not appear to be a way to do this. Sorry, Ian
- VP Product Management
- Ian_Macdonald
- 2 yrs ago
- Questions & Answers
- Reported - view
Re: Get data from 2 months ago
Hi dgf, There are a number of different ways you can achieve this. To find the best solution for your specific requirements we'll need to know a little bit more about how you want to use the…
- VP Product Management
- Ian_Macdonald
- 2 yrs ago
- Questions & Answers
- Reported - view
Re: Decision Intelligence Blog: Reports, Dashboarding and Color Blindness
Great content Sandra, thanks! As a follow up, there is a section in our Help on creating accessible content, a downloadable PDF guide with examples and a downloadable PDF of Pyramid VPAT declaration.…
- VP Product Management
- Ian_Macdonald
- 2 yrs ago
- Tech Blogs & Webinars
- Reported - view
Re: Decision Intelligence Blog: How to choose the right calculation method in Pyramid
Hi Debora, Thanks for your contribution, it's great to see our customers and partners sharing and learning together! Knowing which calculation type to use is very important in order to get the right…
- VP Product Management
- Ian_Macdonald
- 2 yrs ago
- 3
- Tech Blogs & Webinars
- Reported - view
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…
- VP Product Management
- Ian_Macdonald
- 2 yrs 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,…
- VP Product Management
- Ian_Macdonald
- 2 yrs 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…
- VP Product Management
- Ian_Macdonald
- 2 yrs ago
- Questions & Answers
- Reported - view
Re: Gantt chart?
Hi, To confirm, Gantt charts will be available in the Marketplace with Pyramid 2023. Ian
- VP Product Management
- Ian_Macdonald
- 2 yrs 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.…
- VP Product Management
- Ian_Macdonald
- 2 yrs 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:…
- VP Product Management
- Ian_Macdonald
- 2 yrs 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
- VP Product Management
- Ian_Macdonald
- 2 yrs 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,…
- VP Product Management
- Ian_Macdonald
- 2 yrs 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…
- VP Product Management
- Ian_Macdonald
- 2 yrs 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…
- VP Product Management
- Ian_Macdonald
- 2 yrs 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.…
- VP Product Management
- Ian_Macdonald
- 2 yrs 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…
- VP Product Management
- Ian_Macdonald
- updated 2 yrs ago
- 4replies
- 149
- 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,…
- VP Product Management
- Ian_Macdonald
- 2 yrs 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
- VP Product Management
- Ian_Macdonald
- 2 yrs ago
- Questions & Answers
- Reported - view

1 15 16 17 18 19 28

Back to top

Home

View all topics