Consolidator Rule - Issue With Sandbox

Post Reply
chewza
Posts: 100
Joined: Tue Aug 17, 2010 11:51 am
OLAP Product: TM1
Version: 9.5
Excel Version: 7

Consolidator Rule - Issue With Sandbox

Post by chewza » Mon Jul 27, 2020 9:44 am

Hi Guys

I am using the following consolidator rule for the "All Months" Element:
['Cashflow', 'Closing Balance', 'Amount', 'All Months'] = c:['December'];

It works perfectly, but with sandboxes it does not seem to "activate"
In a sandbox, it adds up the closing balance of all months rather than using the closing balance for December.

Any ideas?

Many thanks!!

Regards
Chris

MarenC
Posts: 108
Joined: Sat Jun 08, 2019 9:55 am
OLAP Product: Planning Analytics
Version: Planning Analytics 2.0
Excel Version: Excel 2016

Re: Consolidator Rule - Issue With Sandbox

Post by MarenC » Mon Jul 27, 2020 2:20 pm

Not sure but what if you prefix the elements with the dimension and hierarchy names?

Maren

Post Reply