Ian Macdonald's Profile - Pyramid Analytics Community Forum

Skip to main content

User Community

Badges

Company

Pyramid Analytics

Country

Latest Posts

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.…
- VP Product Management
- Ian_Macdonald
- 5 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…
- VP Product Management
- Ian_Macdonald
- 5 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…
- VP Product Management
- 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
- VP Product Management
- 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.…
- VP Product Management
- 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…
- VP Product Management
- 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.…
- VP Product Management
- 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].…
- VP Product Management
- 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.…
- VP Product Management
- 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
- VP Product Management
- 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,…
- VP Product Management
- Ian_Macdonald
- 5 yrs ago
- Questions & Answers
- Reported - view
Re: How to remove Grid header deatils
Or simply make the foreground text colour transparent.
- VP Product Management
- 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,…
- VP Product Management
- 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.…
- VP Product Management
- 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,…
- VP Product Management
- Ian_Macdonald
- updated 5 yrs ago
- 240
- 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.…
- VP Product Management
- 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…
- VP Product Management
- 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.…
- VP Product Management
- 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,…
- VP Product Management
- 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…
- VP Product Management
- 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.…
- VP Product Management
- 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
- VP Product Management
- 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,…
- VP Product Management
- 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).…
- VP Product Management
- Ian_Macdonald
- 5 yrs ago
- Questions & Answers
- Reported - view
De-Duplicating Data Sets with Pyramid

Introduction Following on from my previous blog on de-duplicating records using Python, I was curious to see if I could achieve the same result with some creative use of the standard Pyramid Model…
- VP Product Management
- Ian_Macdonald
- 5 yrs ago
- 132
- 2
- Tech Blogs & Webinars

1 18 19 20 21 22 23 24

Back to top

Home

View all topics