HP 11.1.2.1 - multidim array in a script / Loop block in calc manager
Hi,
I have a script where I absolutely need to use a variable. The problem is that this variable varies on Period and Account which are both dense. I can use an array to make it vary on one of the dense dimensions. ie : if I use ARRAY myVar[Period] the variable varies on Period, if I use ARRAY myVar[Account] it varies on account, but it's impossible to make it vary on both dimensions... so at the moment I'm using ARRAY myVar[Account] and I can run my rule for only one period at the time.
Basically, I'd need ARRAY myVar[Period][Account].
I tried to use the "LOOP" block in the calculation manager, to try to loop on periods. When using the Loop object, the calculation manager offers me to select functions such as @RELATIVE("yearTotal", 0) as the parameter of the loop, but it doesn't validate. Esb tech_ref says that the parameter could only be an integer.
Anyway, I'm stuck and I can't believe it's impossible to do such a simple thing with a powerful tools like Essbase.
Please advise.
Thanks in advance !
Regards,
JM.
Edited by: endy on Jun 13, 2011 6:57 PM