Consolidator Rule - Issue With Sandbox

Post Reply
chewza
Regular Participant
Posts: 156
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 »

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
Regular Participant
Posts: 436
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 »

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

Maren
Post Reply