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
Hi,
You can try this:
=if([OrgHier].isleaf =1) then Count([Staffid])
Thanks,
Jothi
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
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