reporting services, accessing hierarchies in OLAP -
05-15-2006
, 06:57 AM
im new to this and hopefully you can help me... hopefully the thread is
placed in the right section ...
i use rs 05 and my datasource is a cube. there is a dimension with a
hierarchie inside the cube
the hierarchie has the following structure:
comp1 consists of dep1, dep2 and dep3 and in dep2 there work emp1 and emp2
comp2 consists of dep4 and dep5 and in dep4 there work emp3
inside the cube this looks as follows:
hierarchie:
members
... -all members hierarchically listed-
level 02
-comp1
-comp2
level 03
-comp1 [datamember]
-dep1
-dep2
-dep3
-dep4
-dep5
-comp2 [datamember]
level 04
-dep2 [datamember]
-emp1
-emp2
-emp3
-dep4 [datamember]
the report output should be as follows:
comp dep emp
---------------------------------
-comp1
-dep1
-dep2
-emp1
-emp2
-dep3
-comp2
-dep4
-emp3
-dep5
is it possible to access the levels individually ...
f.e.: i want to list the departments and employees without the company (-->
only level 3 & 4)
hopefully someone can hint me in the right direction ..
thanks a lot
Rhapsody |