dbTalk Databases Forums  

reporting services, accessing hierarchies in OLAP

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap


Discuss reporting services, accessing hierarchies in OLAP in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Rhapsody
 
Posts: n/a

Default 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

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.