Skip to main content
User Community
Pyramid
Help
Learn
Support
Generative BI
How to enable Javascript
Sign Up
Login
Welcome to the Pyramid User Community
Pyramid User Community
Search for answers here or
ask a question
Questions & Answers
Explore Pyramid
Product
Events & News
Latest Activity
Home
Profile
Ian Macdonald
Admin
Ian_Macdonald
Senior Director of Product
UK
Follow
Joined
Fri Oct 14 14:58:14 UTC 2016
996
posts
321
likes received
13
followers
Badges
17
3
Company
Pyramid Analytics
Country
United Kingdom
Latest Posts
Re: Date filters allow range and null selection
Hi Paul, Create a parameter that contains all your "proper dates": Create a List that includes the null dates ("--") Member and the Parameter: Select the List: Se the Parameter to be of type Calendar:…
Ian Macdonald
Admin
Senior Director of Product
Ian_Macdonald
1 yr ago
Questions & Answers
Official response
Reported - view
Re: PQL for checking if date is null
Hi Paul, When Pyramid constructs its Semantic Model, each attribute / hierarchy that results is a list of unique values from the originating column. In the case of dates,…
Ian Macdonald
Admin
Senior Director of Product
Ian_Macdonald
1 yr ago
1
Questions & Answers
Answer
Reported - view
Re: Can R or Python models be easily imported into a Data Model?
Hi Robert, Yes, but it kind of depends on what they do and how they're written. You can either copy and paste the script into an R or Python block in the Data Flow,…
Ian Macdonald
Admin
Senior Director of Product
Ian_Macdonald
1 yr ago
Questions & Answers
Official response
Reported - view
Re: Date filters allow range and null selection
Hi Paul, Can I clarify a couple of things with you? Are you looking to retrieve rows for, say, a sales transaction, where the date column has not been recorded and is null, or,…
Ian Macdonald
Admin
Senior Director of Product
Ian_Macdonald
1 yr ago
Questions & Answers
Reported - view
Re: Cascading parameters
Hi Dave, The answer is broadly, yes, but if you can provide an example, of what you want to achieve, I can show how that might be implemented. Cheers, Ian
Ian Macdonald
Admin
Senior Director of Product
Ian_Macdonald
1 yr ago
1
Questions & Answers
Reported - view
Re: Identifying Duplicated Elements
Hi Jenny, In your hierarchies panel, right click on Product and choose "Aggregate / Count". Your menu may look different to mine as you will be on an earlier release,…
Ian Macdonald
Admin
Senior Director of Product
Ian_Macdonald
1 yr ago
1
Questions & Answers
Reported - view
Re: Identifying Duplicated Elements
Thanks Jenny, Yes, it should be. One more question, is your Status field in the same table as the Product Field? If not, how are the two related? Ian
Ian Macdonald
Admin
Senior Director of Product
Ian_Macdonald
1 yr ago
Questions & Answers
Reported - view
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.…
Ian Macdonald
Admin
Senior Director of Product
Ian_Macdonald
1 yr 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…
Ian Macdonald
Admin
Senior Director of Product
Ian_Macdonald
1 yr 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…
Ian Macdonald
Admin
Senior Director of Product
Ian_Macdonald
1 yr 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
Ian Macdonald
Admin
Senior Director of Product
Ian_Macdonald
1 yr 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
Ian Macdonald
Admin
Senior Director of Product
Ian_Macdonald
1 yr 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,…
Ian Macdonald
Admin
Senior Director of Product
Ian_Macdonald
1 yr 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,…
Ian Macdonald
Admin
Senior Director of Product
Ian_Macdonald
1 yr 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
Ian Macdonald
Admin
Senior Director of Product
Ian_Macdonald
1 yr 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…
Ian Macdonald
Admin
Senior Director of Product
Ian_Macdonald
1 yr 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.…
Ian Macdonald
Admin
Senior Director of Product
Ian_Macdonald
1 yr 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…
Ian Macdonald
Admin
Senior Director of Product
Ian_Macdonald
1 yr 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…
Ian Macdonald
Admin
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,…
Ian Macdonald
Admin
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…
Ian Macdonald
Admin
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
Ian Macdonald
Admin
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.…
Ian Macdonald
Admin
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:…
Ian Macdonald
Admin
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
Ian Macdonald
Admin
Senior Director of Product
Ian_Macdonald
1 yr ago
Questions & Answers
Reported - view
1
7
8
9
10
11
21
Home
Questions & Answers
Explore Pyramid
Pyramid Explore Missions
Learning Live Archive
Tech Blogs & Webinars
Pyramid Dashboard Gallery
Product
Product Announcements
Product Ideas
Current Product Ideas
Completed Product Ideas
Knowledge Base
Admin
Data Sources
Databases
Discover
Formulate
General
Install/Upgrade/Cloud/License
Model
Performance
Present
Publish
SAP
Security
Events & News
Upcoming Events & Webinars
Getting Started
Community News
Customer Success Activities
What's New
View all topics