Skip to Content
avatar image
Former Member

Merging hierarchy data from SAP BW with flat data from Universe

Apr 10, 2017 at 09:52 AM | 209 Views

Dear All,

I'm looking for a solution to merge hierarchichal data from SAP BW with flat data structures from a realational universe.

Universe Data:

- OrgUnit Number (8-digit number)

- Staff ID (4-digit number as Dimension)

- Counter for Staff ID

BEx Data

- OrgUnit (Hierarchy Dimension, shows OrgUnit Name)

- OrgUnit Number (Attribute, 8-digit number)

- OrgUnit Name (Attribute, 60 characters)

- Counter

Merged Dimension on OrgUnit Number from Universe and BEx Data. For details see Screenshot "Data Structure".

The merge is correct and the count for distinct Staff IDs is correct for the corresponding leaf of the Hierarchy. Now I want Web Intelligence to sum up along the Hierarchy. For details see Screenshot "Result vs. Expectation".

Any help on this topic is highly appreciated.

Regards,

Jason

result-vs-expectation.png (41.3 kB)
data-structure.png (10.7 kB)
SAP BusinessObjects - Web Intelligence (WebI)
hierarchy | merged dimensions | universe data | bex query data
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    avatar image
    Koen Hesters
    Apr 10, 2017 at 12:39 PM

    check out

    http://trustedbi.com/tag/sap/

    Merging SAP and non-SAP data: Overcoming Hierarchies

    Grtz

    Koen

    Add comment
    10|10000 characters needed characters exceeded

    • Koen Hesters Former Member
      Apr 21, 2017 at 12:17 PM

      Jason,

      if you set the hierarchy display as key, is that the same key as you show in your screenshot ?

      if yes you can add an attribute containing the text and use that next to your hierarchy