Skip to Content
0
Oct 26, 2011 at 03:00 PM

Web intelligence and sap bw hierarchy

26 Views

Hi all,

we are trying to build a report based on bex query and using bw hierarchy.

We can create the report in an easy way with dimnesion customer (using hierarchy) and measure unit sales and it look pretty good. But when we add next dimension into our report the result isnt how we imagined. Take a look please at these two pictures. The first is how the report looks like now and the second is how it should look like.

1. picture how it looks like now - http://img202.imageshack.us/img202/6708/sapbwhierarchyinwebi.jpg

2. picture how it should look like - http://img507.imageshack.us/img507/7043/sapbwhierarchyinwebithi.jpg

The dimension sales manager should be visible only on the bottom level of the customer hierarchy. Is it possible ?

Thanks for any help,

regards Martin Zluky

Edited by: Martin Zluky on Oct 26, 2011 5:00 PM

Edited by: Martin Zluky on Oct 26, 2011 5:04 PM