Web intelligence and sap bw hierarchy

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