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 |