dbTalk Databases Forums  

Statistical Reports

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


Discuss Statistical Reports in the microsoft.public.sqlserver.olap forum.



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

Default Statistical Reports - 12-08-2005 , 10:25 AM






Hallo all!

I'm new to OPAL technologies and so really need some help.

I have created a cube in OLAP. For a statistical report I need specific
values from this cube. For example, count of mans, count of women (Sex
Dimension), occupation type (Occupation Dimension), average age (Age
Dimension) etc. in a different Regions. It would look like:

Africa Europe Asia
Employee Count 25 28 28
Man 12 13 14
Women 13 15 14
Scholarship holder 5 2 7
Coordinator 2 4 3
Average age 40 41 43
Etc.

It means I need to write a MDX queries to receive data. What are
possibilities to combine more then one MDX in a report? Are there other
possibilities? Is it possible in MS Reporting Services?

Thanks a lot

burkaans


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.