Ian Macdonald's Profile - Pyramid Analytics Community Forum

Badges

Company

Pyramid Analytics

Country

Latest Posts

Re: Line chart - multiple items, all one colour
Hi Adam, For Vertical trellis, just move the Geography attribute Chip to the Vertical Trellis drop zone. You can then scale the charts to fit and make a common vertical scale and common X axis to…
- Senior Director of Product
- Ian_Macdonald
- 4 yrs ago
- Questions & Answers
- Reported - view
Re: Cumulative context but to exclude specific status measures
Hi again, You asked for some examples of creating cumulative totals. This, again, makes use of the upgraded CurrentMember function, usually in combination with the Range function.…
- Senior Director of Product
- Ian_Macdonald
- 4 yrs ago
- 1
- Questions & Answers
- Reported - view
Re: SSAS: Formulate across cubes and/or databases
Hi Markus, The answer remains the same I'm afraid. It is not currently possible to create calculations across Pyramid Models. Of course, you can always query your databases,…
- Senior Director of Product
- Ian_Macdonald
- 4 yrs ago
- 1
- Questions & Answers
- Reported - view
Re: Cumulative context but to exclude specific status measures
Hi Nick, Yes, you can. This relies on the upgraded CurrentMember() PQL function which in 2020.10 returns the Member Name where required instead of just the value.…
- Senior Director of Product
- Ian_Macdonald
- 4 yrs ago
- Questions & Answers
- Reported - view
Re: Cumulative Rate Changes
BTW - Your cumulative (compound) rate change numbers don't look right. My numbers match exactly the numbers generated by Excel when I prototyped the calculations to make sure I understood them…
- Senior Director of Product
- Ian_Macdonald
- 4 yrs ago
- 1
- Questions & Answers
- Reported - view
Re: Cumulative Rate Changes
Hi Dan, I have some good news and some (slightly) bad news... The good news is: The (slightly) bad news, or, depending on how you see it, more good news, is that this requires Pyramid 2020.10.…
- Senior Director of Product
- Ian_Macdonald
- 4 yrs ago
- 1
- Questions & Answers
- Reported - view
Re: Click or drag to add measure - any difference?
Hi Adam, The Values drop zone lists all the Measures that are taking part in the query. The orange Values Chip represents all the Measures in the Values Drop Zone.…
- Senior Director of Product
- Ian_Macdonald
- 4 yrs ago
- Questions & Answers
- Reported - view
Re: Motion ranking
In this scenario, we are wanting to keep the query as generated by creating the grid, with Manufacturers sorted within each month. By placing Manufacturers into the colour drop zone,…
- Senior Director of Product
- Ian_Macdonald
- 4 yrs ago
- Questions & Answers
- Reported - view
Re: Last updated date & time
@Fadiel Ras Last Process date is available as a system field in v2020.10.xxx due a on a couple of weeks' time. Ian
- Senior Director of Product
- Ian_Macdonald
- 4 yrs ago
- Questions & Answers
- Reported - view
Re: Motion ranking
Make sure the Category drop zone is empty. Items (Manufacturers in my case) chip in Colour and Months in Motion for the Column chart.
- Senior Director of Product
- Ian_Macdonald
- 4 yrs ago
- Questions & Answers
- Reported - view
Re: Motion ranking
Hi Adam, Your post needs to be approved by the moderators of the forum before it appears in the Q&A, so that's why your post does not appear immediately.…
Attachment
- Senior Director of Product
- Ian_Macdonald
- 4 yrs ago
- Questions & Answers
- Reported - view
Re: Unique Customers count that bought multiple items at a site
Quick clarification. You say guns, bows, ammo etc are attributes. Is that correct or are they members of a product attribute, like say product category?
- Senior Director of Product
- Ian_Macdonald
- 4 yrs ago
- Questions & Answers
- Reported - view
Re: Drill Through within Measure?
Angela, I'm currently writing up a blog on this topic, I'll post a link here when it is ready. Meanwhile, I notice from your example report that you are connecting to a SQLServer Analysis Services…
- Senior Director of Product
- Ian_Macdonald
- 4 yrs ago
- 2
- Questions & Answers
- Reported - view
Re: Blank Pages
Hi Wayne, Yes there is. Take a look at Page Triggers in Publications. This allows you to test on values in a grid and then decide whether or not to print that page.…
- Senior Director of Product
- Ian_Macdonald
- 4 yrs ago
- Questions & Answers
- Reported - view
Re: Load a whole folder and append multiple same-structure CSV file
Hi Gauthier, I've moved this post from the BI Office (our old platform) Q&A to the Pyramid Q&A as you had accidentally posted it to the wrong Forum! The functionality you want exists today in the…
- Senior Director of Product
- Ian_Macdonald
- 4 yrs ago
- 2
- Questions & Answers
- Reported - view
Re: Find Difference between two dates
Hi, There is a Pyramid function DateDiff() that can be using in formulate to calculate the difference between two dates in various units. See https://help.pyramidanalytics.…
- Senior Director of Product
- Ian_Macdonald
- 4 yrs ago
- Questions & Answers
- Reported - view
Re: Stacked Visualizations
Hi, Please try this again. Later releases of Pyramid have enhancements to many chart formatting requirements, including multiple stacked measures: Hope that helps. Ian
- Senior Director of Product
- Ian_Macdonald
- 4 yrs ago
- Questions & Answers
- Reported - view
Re: Cube measure format options
Yes, just click into the text box and type your own format string.
- Senior Director of Product
- Ian_Macdonald
- 4 yrs ago
- Questions & Answers
- Reported - view
Re: Horizontal bar chart with two values
Certainly it is possible in V2020. I believe this was supported in one of the later 2018 releases. Ian
- Senior Director of Product
- Ian_Macdonald
- 4 yrs ago
- Questions & Answers
- Reported - view
Re: Usage statistics
Hi Jared, You can find details on how to implement this at https://community.pyramidanalytics.com/t/m2a7cd/pyramid-usage-model-and-analysis Hope that helps. Ian
- Senior Director of Product
- Ian_Macdonald
- 4 yrs ago
- Questions & Answers
- Reported - view
Re: Sqoop import to HCatalog/Hive - table not visible
Hi Priyanka, Are you sure you have submitted this question to the right vendor product forum? It doesn't seem to be anything to do with Pyramid Analytics! Ian
- Senior Director of Product
- Ian_Macdonald
- 4 yrs ago
- Questions & Answers
- Reported - view
Re: Can you drill down by column instead of cell?
Hi Nicholas, If I understand you correctly, you are wanting to effectively swap the Attribute from Years to Quarters to Months etc., and show all the Years, Quarters, Months etc.…
- Senior Director of Product
- Ian_Macdonald
- 4 yrs ago
- Questions & Answers
- Reported - view
Re: How to set default value to Slicer(Filter) ?
Hi Chris, Are you wanting to default the slicer to the specific value 47 or the latest (last) value dynamically? Yes, there are ways to achieve the filtering requirements you specify.…
- Senior Director of Product
- Ian_Macdonald
- 4 yrs ago
- Questions & Answers
- Reported - view
Re: Sort multi-select Slicer
Hi Chris, Create a List of the dates you require, then sort the list descending and save it. Then use the List to populate the slicer: Hope that helps. Ian
- Senior Director of Product
- Ian_Macdonald
- 4 yrs ago
- Questions & Answers
- Reported - view
Re: Is there any way to get notified when a scheduled Model Data Flow fails?
Hi Aryat, The functionality you are looking for is available in Pyramid 2020, known as Model Flows. Depending on the outcome of the processing in the example below,…
- Senior Director of Product
- Ian_Macdonald
- 4 yrs ago
- 1
- Questions & Answers
- Reported - view

1 16 17 18 19 20 21 22

Welcome to the Pyramid User Community

Pyramid User Community

Ian Macdonald

Re: Line chart - multiple items, all one colour

Re: Cumulative context but to exclude specific status measures

Re: SSAS: Formulate across cubes and/or databases

Re: Cumulative context but to exclude specific status measures

Re: Cumulative Rate Changes

Re: Cumulative Rate Changes

Re: Click or drag to add measure - any difference?

Re: Motion ranking

Re: Last updated date & time

Re: Motion ranking

Re: Motion ranking

Re: Unique Customers count that bought multiple items at a site

Re: Drill Through within Measure?

Re: Blank Pages

Re: Load a whole folder and append multiple same-structure CSV file

Re: Find Difference between two dates

Re: Stacked Visualizations

Re: Cube measure format options

Re: Horizontal bar chart with two values

Re: Usage statistics

Re: Sqoop import to HCatalog/Hive - table not visible

Re: Can you drill down by column instead of cell?

Re: How to set default value to Slicer(Filter) ?

Re: Sort multi-select Slicer

Re: Is there any way to get notified when a scheduled Model Data Flow fails?

Home