Skip to Content
avatar image
Edward Masarri

Loads from one DSO to Another with Fewer keys

Mar 10, 2017 at 09:31 PM | 1.1k Views

Hi Friends,

Env BW 7.4 on hana

I have question regarding moving data from one standard DSO to another with fewer keys in the second level DSO.

First layer staging DSO for FI GL 10 extractor

Keys

Account, company code, fiscalyearperiod,RTCUR, Zfield, other fields

Zfield is a concatenation field of profitcenter and segment, as we exhausted all the keys of the DSO

Second layer DSO

Account, company code, fiscalyear period,profit center, segment, other fields(same as the first level)

In the 2nd level we split up the Zfield to profit center and segment. RTCUR is not being used in this level as we do not need it for further reporting

the data part is 0credit, 0debit and 0balance - standard sap content

The transformation for the data part is set to "overwrite" in the aggregation.

Here is one sample of data in the first level dso

Account Company Zfield RTCUR 0balance ....

XXX YYY 1001100 EUR 5000

XXX YYY 1001100 GBP 450

XXX YYY 1001100 USD 1600

2nd level DSO

Account Company profitcenter segment 0balance ....

XXX YYY 1001 100 7050

Is this a normal behaviour, does the data from the first level actual get cumulative before being fed to the second level.

I would assume as the amounts are set to overwrite, we might get the last record that got updated to the DSO, in whatever order it is.

Thanks for your time.

Ed.

BW (SAP Business Warehouse)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

5 Answers

  • Best Answer
    avatar image
    Former Member
    Mar 16, 2017 at 07:03 AM

    difficult to analyze it from the far.

    Please check your company code currency and document currency. Maybe they aren't in accordance with any currency. Check t-codes: OX02 and OB22 (ECC source system).

    Furthermore if you have a BW testing system with reliable data in the underlying ECC source system try the following.

    Delete all data from 2nd level DSO, thereafter add RTCUR in the 2nd level DSO and make a reload from 1st DSO.

    Did you already check the data quality of 1st level DSO. Are the data there correct?

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Edward Masarri
    Mar 13, 2017 at 01:15 PM

    Friends, your inputs are highly appreciated.

    PS - There is no selection for semantic keys.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Edward Masarri
    Mar 13, 2017 at 02:10 PM

    Thanks Thomas for your reply.

    We were having significant differences in balances that we get from Totals(GL10) and Line item(GL14) extractor. We raised a note with SAP, and they asked us to include RTCUR as a key figure in GL10's first level DSO, and do not move forward as its not used in reporting.

    The aggregation behaviour of the infoobject 0balance is "Sum". However we were are mapping in the transformation, the aggregation is set to
    "Overwrite"

    Process flow with standard DSO's is already in production. But will definitely explore the option of advanced DSO.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Mar 13, 2017 at 02:01 PM

    Hi

    Why don't you need the currency as important key field? Check to use a semantic partitioned DSO or as you alreaday uses BW 7.4 on HANA the advanced DSO with over 120 possible key fields.

    Check the aggregatrion behaviour of your key figures again.

    Thanks

    T.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Mar 13, 2017 at 02:18 PM

    why do you use an DSO in the second level layer?

    Can you please attach a scan of the transformations between 1.st and 2.sd DSO and another one for the aggregation behaviour of the key figures on 2nd level DSO?

    Add comment
    10|10000 characters needed characters exceeded