CubeDataReservationAcquire

Post Reply
Dimix
Posts: 13
Joined: Fri Jan 15, 2016 2:53 pm
OLAP Product: TM1
Version: 10.2.2
Excel Version: 2013

CubeDataReservationAcquire

Post by Dimix » Mon Oct 09, 2017 5:08 pm

I'm working on a customized workflow for a customer, and for that purpose I use CubeDataReservationAcquire to take ownership. It works great in TM1 10.2.2, but I can't get it to work in Planning Analytics 2.0.

A simple test that describes the issue:

TM1 10.2.2
sUser = 'Donald';
sCube = 'Profit_and_Loss';

sAddress = '|||tpn:5621530|||';
CUBEDATARESERVATIONACQUIRE ( sCube, sUser, 1, sAddress );

sAddress = '|||tpn:5721525|||';
CUBEDATARESERVATIONACQUIRE ( sCube, sUser, 1, sAddress );

This is how it looks like for Donald, the correct cells are open for editing. i.e. Cost center tpn:5621530 and tpn:5721525.
Capture.PNG
Capture.PNG (4.68 KiB) Viewed 88 times
Planning Analytics 2.0
I now do the same in Planning Analytics 2.0 (demo environment hosted by IBM). The process runs without errors, but only cells related to Organization 1700 is open for editing, all others are locked.

sAddress = '1003|||||||||';
CUBEDATARESERVATIONACQUIRE ( sCube, sUser, 1, sAddress );

sAddress = '1700|||||||||';
CUBEDATARESERVATIONACQUIRE ( sCube, sUser, 1, sAddress );

Capture2.PNG
Capture2.PNG (6.94 KiB) Viewed 88 times
Interestingly enough, it works if I take ownership of the consolidated node, @2000, i.e. all nodes on the lowest level are open for editing.

What makes me a bit confused, is that CUBEDATARESERVATIONGET indicates that Organization 1700 AND 1003 are correctly reserved, but only 1700 is available.

"20171009145034|Donald|1700|||||||||"
"20171009145023|Donald|1003|||||||||"

Current status for cells related to 1003:
Capture3.PNG
Capture3.PNG (2.87 KiB) Viewed 88 times
I have double-checked the settings in the two versions, e.g. DATARESERVATIONMODE is set to REQUIREDSHARED, but can't find any differences. What have I missed, are there any new settings in Planning Analytics I should be aware of? Should I be able to reserv multiple indivual nodes in Planning Analytics?

Post Reply