Ian Macdonald's Profile - Pyramid Analytics Community Forum

Badges

Company

Pyramid Analytics

Country

Latest Posts

Re: Can you rename "Default Section" in a presentation?
2020.02.084 is available now from the customer portal. Ian
- Senior Director of Product
- Ian_Macdonald
- 4 yrs ago
- Questions & Answers
- Reported - view
Re: Continuous date table
Hi Olga, We are currently developing this feature for a future release, so keep your eye on the product announcement forum for this in the coming months.…
- Senior Director of Product
- Ian_Macdonald
- 4 yrs ago
- Questions & Answers
- Reported - view
Re: Multiple Members Search
You can run multiple searches and add the results together using the "Found Elements" and "Selected Elements" panels. In this example, I have search for Zip codes containing 123 and selected them…
- Senior Director of Product
- Ian_Macdonald
- 4 yrs ago
- Questions & Answers
- Reported - view
Re: Calculation turns wrong after drill-down
Hi Markus, Please retest in the new release, 2020.01.121. There is a fix in there described as follows: Fixed an issue where the Percent Of Total context function had an incorrect format when using…
- Senior Director of Product
- Ian_Macdonald
- 5 yrs ago
- Questions & Answers
- Reported - view
Re: Cell bars are displayed incorrectly in case the Grand Total is switched on
Hi Markus, Please resubmit this into the Ideas forum. Thanks, Ian
- Senior Director of Product
- Ian_Macdonald
- 5 yrs ago
- Questions & Answers
- Reported - view
Re: Rank
Hi Nicholas, As Imbar says, with regards to the Rank() function, this is currently only available within the “Common” functions, not the semantic model functions.…
- Senior Director of Product
- Ian_Macdonald
- 5 yrs ago
- Questions & Answers
- Reported - view
Re: Connecting multiple Excel selections to Python script 'easily'
Hi Frank, Just duplicate the Python Block and connect it to each of the select blocks for each of your Excel tabs. Multiselect block is designed for when you have multiple tables of data upon which…
- Senior Director of Product
- Ian_Macdonald
- 5 yrs ago
- Questions & Answers
- Reported - view
Re: Mapping challenge
Hi Patou, You will have to use member security to limit what that user can see, or use the username() function in a calculation to identify that person's local city.…
- Senior Director of Product
- Ian_Macdonald
- 5 yrs ago
- Questions & Answers
- Reported - view
Re: How to call existing formula in a new formula
Hi Sunilk, You've already written it, mostly! In FORMULATE, write: IF([measures].[annual sales]>0,"High", IF([measures].[annual sales]<0,"Medium", IF([measures].…
- Senior Director of Product
- Ian_Macdonald
- 5 yrs ago
- Questions & Answers
- Reported - view
Re: calling stored procedure dynamically
Hi Rajramesh, I'm not sure I understand your question. Do you mean call a Stored Procedure dynamically from the Discover View? If so, that cannot be done.…
- Senior Director of Product
- Ian_Macdonald
- 5 yrs ago
- Questions & Answers
- Reported - view
Re: How to set Custom Order
Otherwise, right click on the blue attribute chip and use "Custom Order", then select the members in the order you want them to appear: Hope that helps. Ian
- Senior Director of Product
- Ian_Macdonald
- 5 yrs ago
- Questions & Answers
- Reported - view
Re: How to Implement Push Notification
Hi Sunilk, You can create "Push" notifications in two main ways in Pyramid, using Publish, or User Defined Alerts. Both these topics are rather long to go into here,…
- Senior Director of Product
- Ian_Macdonald
- 5 yrs ago
- Questions & Answers
- Reported - view
Re: How to remove Grid header deatils
Or simply make the foreground text colour transparent.
- Senior Director of Product
- Ian_Macdonald
- 5 yrs ago
- Questions & Answers
- Reported - view
Re: SSAS: Formulate across cubes and/or databases
Hi Markus, SSAS MDX does provide a cube LOOKUP() function that allows you to lookup values and strings from another cube in the same database. However, as the MDX documentation says,…
- Senior Director of Product
- Ian_Macdonald
- 5 yrs ago
- Questions & Answers
- Reported - view
Re: Default Chart colors (White text on white background)
Hi Katherine, The Chart colours, text foreground and background and many other settings are controlled by Themes. Whichever Theme is set to be your default will define the initial colours and fonts.…
- Senior Director of Product
- Ian_Macdonald
- 5 yrs ago
- Questions & Answers
- Reported - view
Calculating Moving Averages in Pyramid IMDB

Introduction When looking at trends over time, there is often the need to smooth out the individual values by using a Moving Average (MAv). The MAv smooths out the peaks and troughs,…
- Senior Director of Product
- Ian_Macdonald
- updated 5 yrs ago
- 234
- 2
- Tech Blogs & Webinars
Re: Rolling Average IMDB Model
Ah! It occurred to me after I had written the above, that in fact, we only need to test the Sales value for null for the first element in the moving average. I.e.…
- Senior Director of Product
- Ian_Macdonald
- 5 yrs ago
- Questions & Answers
- Reported - view
Re: Rolling Average IMDB Model
Hi Alec, Currently, the CurrentMember() function does not actually return the name of the current member, so the range approach will not work. We hope to add this functionality in a future version…
- Senior Director of Product
- Ian_Macdonald
- 5 yrs ago
- Questions & Answers
- Reported - view
Re: SSAS drillthrough
Hi Rob, I've tested against the latest release and you are correct. I'm not sure if this is by design or an error. Please resubmit this issue through our support team for resolution. Hope that helps.…
- Senior Director of Product
- Ian_Macdonald
- 5 yrs ago
- Questions & Answers
- Reported - view
Re: Locking down a Pyramid 2018 Model
Hi Brian, When you say "model" are you referring to the model definition in the content store, or the actual database the model defines? If the former,…
- Senior Director of Product
- Ian_Macdonald
- 5 yrs ago
- Questions & Answers
- Reported - view
Re: Dynamic Eliminations
Hi Rob, I have tried recreating the solution in Pyramid that my BI Office Blog described. However, I have found that creating a crossjoin set, whereby the set contains elements from a hierarchy or…
- Senior Director of Product
- Ian_Macdonald
- 5 yrs ago
- Questions & Answers
- Reported - view
Re: Ordering the Months
Hi Katherine, First, I would try to contact whoever created the model and ask them to change it so that the MonthName is ordered correctly. This will save a load of time and effort in future.…
- Senior Director of Product
- Ian_Macdonald
- 5 yrs ago
- Questions & Answers
- Reported - view
Re: Dynamic Eliminations
Hi Rob, TBH, I haven't tried it in Pyramid. I'll take a look and let you know. Watch this space. Ian
- Senior Director of Product
- Ian_Macdonald
- 5 yrs ago
- Questions & Answers
- Reported - view
Re: Is there a way to create groups and then filter within those groups
Hi Katherine, You can use the Variable Lists options to achieve this. Effectively you are creating your groups or Lists, then have a Variable displayed as a drop down,…
- Senior Director of Product
- Ian_Macdonald
- 5 yrs ago
- Questions & Answers
- Reported - view
Re: Ordering the Months
Hi Katherine, You do not mention if you are using the Pyramid IMDB engine (or other SQL based DB), or connected to some other analytic engine (like SSAS or SAP HANA).…
- Senior Director of Product
- Ian_Macdonald
- 5 yrs ago
- Questions & Answers
- Reported - view

1 16 17 18 19 20 21 22

Welcome to the Pyramid User Community

Pyramid User Community

Ian Macdonald

Re: Can you rename "Default Section" in a presentation?

Re: Continuous date table

Re: Multiple Members Search

Re: Calculation turns wrong after drill-down

Re: Cell bars are displayed incorrectly in case the Grand Total is switched on

Re: Rank

Re: Connecting multiple Excel selections to Python script 'easily'

Re: Mapping challenge

Re: How to call existing formula in a new formula

Re: calling stored procedure dynamically

Re: How to set Custom Order

Re: How to Implement Push Notification

Re: How to remove Grid header deatils

Re: SSAS: Formulate across cubes and/or databases

Re: Default Chart colors (White text on white background)

Calculating Moving Averages in Pyramid IMDB

Re: Rolling Average IMDB Model

Re: Rolling Average IMDB Model

Re: SSAS drillthrough

Re: Locking down a Pyramid 2018 Model

Re: Dynamic Eliminations

Re: Ordering the Months

Re: Dynamic Eliminations

Re: Is there a way to create groups and then filter within those groups

Re: Ordering the Months

Home