Skip to Content
0
Former Member
Sep 23, 2012 at 02:04 PM

BPC Script

87 Views

Hi BPC Expert,

I have a simple script logic as such below:

*XDIM_MEMBERSET CATEGORY=BUDGET

*LOOKUP SALES

*DIM JA:ACCOUNT=ST41000000

*DIM MEASURES=PERIODIC

*ENDLOOKUP

*WHEN ACCOUNT

*IS ACC110

*REC(EXPRESSION=LOOKUP(JA)+%VALUE%, ACCOUNT=ST41000000)

*ENDWHEN

*COMMIT

The script ran well and gave me the right results. Unfortunately, while end user ran that script more than one click and not any changes on data and another parameter, BPC system give the wrong result because BPC accumulates it value.

Please BPC expert share with me, If end users not change any data or anything and would like to run BPC package more than one click, BPC will replace its value.

Thank you for your attention.

Kind Regards,