Skip to Content
author's profile photo Former Member
Former Member

issue with infocube

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

Add a comment
10|10000 characters needed characters exceeded

Related questions

9 Answers

  • Posted on Aug 28, 2013 at 05:36 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Aug 28, 2013 at 06:27 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Aug 28, 2013 at 06:53 AM

    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.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 28, 2013 at 07:12 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Aug 28, 2013 at 07:16 AM

    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.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 28, 2013 at 07:33 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Aug 28, 2013 at 07:55 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 28, 2013 at 10:20 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 29, 2013 at 07:22 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.