Allocations in BPC NW -- Possible to use a Memory Variable?

[TedemanCPA]

Hi all,

Got a question here to pose to anyone for some ideas.  We're trying to enhance the performance of an allocation we've written using pretty standard BPC Script Logic.

Essentially, it's just two steps to allocate some data on the basis of, say, Total Sales across the organization.  So, we use some *WHEN/IS/REC logic to

essentially accumulate the Total Sales, then we run the allocation with that total:

Step1

*WHEN ACCOUNT

*IS BAS(TOTAL_SALES)

*REC(FACTOR=1,  ACCOUNT=TEMP_STAT1,  DATASRC=TEST )

*ENDWHEN

*COMMIT

Step2

*RUNALLOCATION

*USING/TOTAL

*DIM  ACCOUNT     WHAT=ACCOUNT_123;   WHERE=<<<;   USING=TEMP_STAT1;   TOTAL=<<<;

*ENDALLOCATION

Question:  Is there any way to run that accumulation to a memoriy variable (e.g. [ACCOUNT].[#TEMP_STAT1])?  Maybe write it afterwards?  Or any other ways to boost the processing time of these>

Thanks,

[Former Member · Accepted solution]

Hi Garett,

No, in NW version you have to store that data and clean it up afterwards. But there is an OSS Note 1620934 - Improve the performance of allocation that does it for you.

Regards,

Gersh

[TedemanCPA · Accepted solution]

Hi Gersh,

That kind of confirms what we were thinking. 

But, it looks like the note you had there was to apply SP05 to EPM 10.  We're doing a BPC 7.5 project in this case.  Admittedly, I had that in the tags, but I shouldn've put the version in the title of the post.

Thanks,

Garrett

[Former Member · Accepted solution]

Hi Garrett,

Sorry, I missed that. Since allocation didn't change from 7.5 to 10.0 SAP is probably working on down-porting that Note. You can send an OSS Message asking when it will be ready for 7.5.

Regards,

Gersh

[TedemanCPA · Accepted solution]

Gersh,

Ok, definitely appreciate the info.  I'll go ahead and follow-up with an OSS.

Thanks,

Garrett