Cube Data reservation Acquire
Posted: Tue Sep 04, 2018 12:24 pm
Hello,
We have issue that one user take ownership of the node in application and another user want to load Actual data but we have received following error:
"200+EUOTHV_110","xxx","Memberships fees","Final mapping","Yes",Data Source line (203) Error: Data procedure line (38): A Pre-existing data reservation is required before performing an update to Cube "OPEX_Budget".
Then we have fund a TI function CubeDataReservationAcquire and we have decided to take reservation for user which load data and after reload release the same. Now we have an issue with this function that we are receiving following error:
"200+BEV_110","621100_110","00043_110","Local Currency","Budget","Version 1","AC201601","Amount","92.62000000000001",Data Source line (1) Error: Data procedure line (38): Wrong Number of Dimension Elements.
A TI function code is following:
CubeDataReservationAcquire('OPEX_Budget',TM1User(), 1, Cost_Center_MCR_Approval_hierarchy|GL_Accounts_MCR|v_Suppliers|Planning_currency|Scenario|v_AV|Periods|OPEX_measures);
We have following dimension variables:
http://prntscr.com/kqggmy
And the code in data is following:
http://prntscr.com/kqghoz
Does anybody have some experience with this function or with such cases?
Thanks!
We have issue that one user take ownership of the node in application and another user want to load Actual data but we have received following error:
"200+EUOTHV_110","xxx","Memberships fees","Final mapping","Yes",Data Source line (203) Error: Data procedure line (38): A Pre-existing data reservation is required before performing an update to Cube "OPEX_Budget".
Then we have fund a TI function CubeDataReservationAcquire and we have decided to take reservation for user which load data and after reload release the same. Now we have an issue with this function that we are receiving following error:
"200+BEV_110","621100_110","00043_110","Local Currency","Budget","Version 1","AC201601","Amount","92.62000000000001",Data Source line (1) Error: Data procedure line (38): Wrong Number of Dimension Elements.
A TI function code is following:
CubeDataReservationAcquire('OPEX_Budget',TM1User(), 1, Cost_Center_MCR_Approval_hierarchy|GL_Accounts_MCR|v_Suppliers|Planning_currency|Scenario|v_AV|Periods|OPEX_measures);
We have following dimension variables:
http://prntscr.com/kqggmy
And the code in data is following:
http://prntscr.com/kqghoz
Does anybody have some experience with this function or with such cases?
Thanks!