Skip to Content
0

Merging hierarchy data from SAP BW with flat data from Universe

Apr 10, 2017 at 09:52 AM

197

avatar image
Former Member

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

10 |10000 characters needed characters left characters exceeded

Hi,

You can try this:

=if([OrgHier].isleaf =1) then Count([Staffid])

Thanks,

Jothi

0
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
Koen Hesters Apr 10, 2017 at 12:39 PM
0

check out

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

Merging SAP and non-SAP data: Overcoming Hierarchies

Grtz

Koen

Show 2 Share
10 |10000 characters needed characters left characters exceeded
Former Member

Hi Koen,

Thank's for the great link. It's really helpful and I kind of got it sorted out.

When I merge the data on the Hierarchy element itself, the calculation works.

Unfortunately I want to merge the data on an attribute field which provides me the number / key. Then the formula in the above link doesn't work. I seem to have to find a way to get the key as hierarchy...

Regards,

Jason

0

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

0