cancel
Showing results for 
Search instead for 
Did you mean: 

dummy (memory) variables

Former Member
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hello,

as far as I know there is no such kind of variables in SAP BPC.

Former Member
0 Kudos

hmm.. i've seen it in bpc for ms 5.0, that's why i've asked.

thanks.

esjewett
Active Contributor
0 Kudos

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

Answers (0)