issue with infocube

[Former Member]

Hi BW gurus

I have an issue where the extractor is having two project values like X and Y for those projects the amount is getting zero values but when

the data is loaded to BI infocube the amount field is getting populated with some values like 20634,though the backend has zero values for amount

Regards,

Siva

[Former Member]

Hi Siva,

  Check the Transformation Field routine,Start Routine and end routine   for any code available and also check in CMOD for any Customer exit written for Populating those fields.

Thanks

Arun

[snitwipro]

Please check if there is any code written in the customer exit, Try a test extraction with RSA3. Also check for the start routine, field routine and end routine and see if any such code written for the problematic field.

Regards

Sourav

[former_member202718]

Hi Siva,

Apart from what other Friends suggested.

From ECC ,Are you using the Right Datsource/KPIs for comparison with right filter and the right Key Figure in BW.

Can you tell us which Datasource you are using.Also usually we have filters such as Currency Type,Value Type,Version.

The same filters needs to be used in BW as well.

rgds

SVU

[Former Member]

Hi Siva,

1) First check the Data flow for the Infocube from top to bottom.

2) Check the amount values for those projects from top to bottom layers one by one.

3) There you can catch at which level the values got changed.

4) Now at that level which it got changed check the transformation with all the routines like start,end. expert and field routines. also check at DTP level if any routine is written.

5) Based on this analysis definitely you should be able to find the root cause.

Regards,
Rakesh

[former_member182470]

Check in PSA-->DSO(if you have)-->Cube. Somewhere the data is getting updated in BW side through some routine or some other logics.

If you want to correct them in BW, just do selective deletion for those projects and run repair full load infopackage for them.

[Former Member]

Hi Siva,

Check the mappings between source and target; and also the mode of key figure (whether its additive or overwrite).

It also depends what extractor you are using; whether full or delta and the records that you are pulling coming first time or already available.

Interesting will be to check in DSO first; what values are coming there. If DSO active table is correct with the records or not.

And this issue may come because of DSO change log also if any selective deletions are done.

Hope this will solve your issues otherwise provide more details if none of above is the case.

Regards,

Anil

[Former Member]

Hi Siva,

Please confirm the value of Amount in  InfoCube for X & Y projects before loading it from ECC.

I mean, Cube shows summation of keyfigures(amounts) for same keyfields check this possibility also.

Also, Check for the possibilities of any routines or formulas on Amount or Direct Mapping is mapped correctly.

Harshawardhan.

[anshu_lilhori]

Hi,

Please check the mapping between source and target field.

Check for routines like field level or start or end routine exits.

Any routine at DTP level.

Regards,

AL

[RamanKorrapati]

Hi Siva,

Check at transformation level, is there any start/end/field level routines.check on rule detail at transformations against Amount object.

you can check whole data flow.

1. ECC side Tx - RSA3, check data amount values

2. at PSA Level

3. At after data source , check at next target level.

some where you may be maintained a routine to fill this amount based on something.

pls check the data flow.

Thanks