Skip to Content
0
May 30, 2016 at 03:40 PM

Look Up Script Dump

28 Views

Hi Experts,

I 'm trying to calculate the value of a KPI wich is (the value of currentday -Value of previous day )/2 , I added an attribute in my time dimension manually where I did the previous time, and I use Look Up in the script but when I try to execute it , it's giving me a dump.

1-

*SAP_BW 740 0009 SAPKW74009 SAP Business Warehouse

*CPMBPC 801 0009 SAPK-80109INCPMBPC CPM Business Planning and Consolidation

2- DUMP

3-I Have 2 dimensions KPI_CDG and Time dimension Temps. and the model is called Indi_Financiers

TIME:02015.01,2015.02,2015

KPI_Extraction :Capital....

4-Default.LGF

5 'm trying to calculate the value of a KPI wich is (the value of currentday -Value of previous day )/2

6-this is the script i'm trying

*LOOKUP Indi_Financiers

*DIM PRV: TEMPS=TEMPS.PREV

*ENDLOOKUP

*WHEN KPI_CDG

*IS KPI10406

*REC(EXPRESSION=(%VALUE%-LOOKUP(PRV))/2,KPI_CDG =KPI1021)

*ENDWHEN

*COMMIT

7- Data like 7800

8-

I can't do it .

thank you

Attachments

DUMP.PNG (28.2 kB)