How to load data to new keyfigure

[sona_devi]

Dear All,

I am given a requirement , Please Help

i am asked to include a new KF (Number KF) in the cube

the cube is getting loaded by data source 0CO_OM_OPA_6(in between DSO)

in the data datasource there is field BELNR which loads to 0CO_DOC_NO in cube

where the logic of loading to KF  should be as follows

check the  field value BELNR in table COBK( Ex : 223931661)

check in the same table COBK   for field value REFBN(Ex :905283981)

THEN

go to table BKPF check for the field value BELNR

IF

COBK(REFBN)  Value = BKPF(BELNR) Value ( Here Ex :905283981)

THEN

GET Value of KURS2 from Table BKPF in to key figure in Cube

A small demo

TABLE                                                        TABLE

COBK                                                          BKPF

Fields                                                           Fields

BELNR  = 223931661                                BELNR  = 905283981

REFBN = 905283981                                  KURS2 = 0.50672( in to cube)

Please Advise

Thanks in Advance

Harshitha

[Former Member]

Hi Harshitha,

You can find out a data source extracting data from BKPF table and then pull this data in BW in a DSO say 'Y' or check out if there is some existing DSO getting the data from this table.

Then while updating the data from your DSO 'X' to cube, you can write a routine for the key figure to look up at DSO 'Y' and populate your key figure on the basis of BELNR and REFBN fields.

First write the select statement in start routine to pull the records from the DSO 'Y' wherever BELNR and REFBN are matching.

Then you write the logic in update routine of key figure as mentioned above.

Then do the data load from DSO to cube.

Thanks.

[cornelia_lezoch]

Hi,

your question is not planning related.

So please post it here

http://scn.sap.com/community/data-warehousing/content

regards

Cornelia