Skip to Content

Issue :: Duplicate records in cube against a single record in DSO

Hello experts ,

I am facing an issue in reporting cube contents through BEx. I have below data in DSO and subsequent cube.

DSO Contents-

                         Field A     Field B     Field C     Amt1     Amt2     Currency

Record 1          A               B               C          100          100          D

Cube contents-

                         Field A     Field B     Field c     Amt1     Amt2     Currency

Record 1          A               B               C          100          0          D

Record 2          A               B               C           0            100       E

I have checked transformation between DSO and Cube and there is no routine between these amount fields. Please help me in getting a similar data record in cube as well.

-Mandar

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Sep 05, 2014 at 10:58 AM

    Apparently it seems the issue with the currency object.Please check if the same keyfiugre infoobjects are used in DSO And cube or not.

    Regards,

    AL

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 05, 2014 at 11:00 AM

    at cube transformations please check if any rule groups exist.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member mandar athavale

      I asked about rule group have you checked.

      Based on rule group same record can be splited and assign amount values to another key fig.

      please check about rule group at your transformations.

  • Sep 05, 2014 at 11:29 AM

    Hi,

    it should in one records in cube.

    how many request in cube one or two?

    delete all reqeust form cube put it in the one request in cube.

    then check the data in cube.

    Thanks,

    Phani.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 05, 2014 at 12:28 PM

    Hi Mandar,


    As already  told by others in this thread, it seems due to the currency mapping.

    both KFs are having same currency unit assinged it seems, whiel creating KF. but your amounts are coming different currency.

    so. create the second amount KF with differnt currency object. and in infocube , map the correct curreny field.

    Regards,
    Sakthi

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member mandar athavale

      Hi Mandar,

      I thought you are having 2 currency fields in source as below:

      Amount_KF1 , Curr_field1, Amount_KF2, Curr_field2.

      Your both amount KFs have the same currency/uom (lets say 0DOC_CURRCY) assigned . So while mapping  in the infocube, respective currency fields mapped to the same target(0DOC_CURRCY). I thought this could have caused some issue.

      But you already confirmed, you have only one currency in your source, so you can ignore this.

      Regards,

      Sakthi.