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
Consolidator Rule - Issue With Sandbox
-
- 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
Not sure but what if you prefix the elements with the dimension and hierarchy names?
Maren
Maren