on 10-30-2009 8:27 AM
hello experts,
i am new to bpc & script logic.(sap nw 7.0 bpc). i need to use dummy variables to temporarly store values, i've tried to use the prefix ' # ' but not helping it. do you have any suggestions?
thanks in advance.
petercan
Hello,
as far as I know there is no such kind of variables in SAP BPC.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Peter,
I can confirm Dzimitry's answer. I did an extensive test of this functionality several months ago and it does not exist in the form you are looking for. Actually, I believe it is possible to assign values to temporary # members in BPC Netweaver MDX. However since there is no *GO statement in BPC Netweaver, it is impossible to read from these temporary members in any useful way.
In BPC MS, the *GO statement seems to write all temporary values into a buffer where they are merged with values on the database, so from the point of view of the script logic it appears that values are on the database itself and participate in roll-ups and other calculations. This was very useful for certain types of calculations. I've seen it used for currency conversion in multiple categories without actually copying LC data, for example. However, this is not possible in the NW version. On the other hand, the NW version does not suffer the same drawbacks from having large volumes of data resident on the database that the MS version does, so you can actually just create your "temporary" data in the application with very little performance impact.
Ethan
User | Count |
---|---|
6 | |
5 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.