TI process to update Approval Hierarchy from file
Posted: Thu Apr 09, 2015 12:46 pm
Hello everyone,
I have been trying to make a turbo integrator process that update a dimension, which works perfectly fine.
The problem is that dimension have an approval hierarchy subset so I need the process to update it as well, since it has to be static and therefore I can't write an MDX expression to make it dynamic.
In the Epilog tab, right after updating my dimension, I added this code to update the subset:
But the result I get doesn't place leaf elements under their parents elements. Oddly enough though, consolidated elements are placed under their respective parents and are expanded. This is the result I get:
The appropriate result would have to be this way:
How do I get the preferred result ? And are there implications to altering the approval hierarchy other than having to redefine security and redeploy the application ?
Thank you for your help !
I have been trying to make a turbo integrator process that update a dimension, which works perfectly fine.
The problem is that dimension have an approval hierarchy subset so I need the process to update it as well, since it has to be static and therefore I can't write an MDX expression to make it dynamic.
In the Epilog tab, right after updating my dimension, I added this code to update the subset:
Code: Select all
SubsetDeleteAllElements('MyDimension', 'MySubset');
vIdx = DIMSIZ('MyDimension');
while (vIdx > 0);
vElName = DIMNM('MyDimension', vIdx);
SubsetElementInsert('MyDimension', 'MySubset', vElName, 0);
vIdx = vIdx - 1;
end;
Code: Select all
[-] Element 8
[-] Element 7
[+] Element 6
[+] Element 5
Element 4
Element 3
Element 2
Element 1
Code: Select all
[-] Element 8
[-] Element 7
[-] Element 6
Element 3
Element 2
Element 1
[-] Element 5
Element 4
Thank you for your help !
