Re: MDX - newbie setup

#1

"Nisus" <Nisus (AT) discussions (DOT) microsoft.com> wrote

Quote:

Hi,

I am pretty new to OLAP cubes and MDX, however, I am hoping that someone can
point me in the right direction.

I have created a cube (TestCube) with two dimensions (ComDim and Time).

The Dimensions look like this:
[ComDim]
- Commodity Name
-Supplier Name
- Department Name
-Metric
-Rpt Date

[Time]
- Year
- QTR
-Month

The cube looks like this once it is processed.
-Software Score
Target
-Sun Microsystems
-IT
-Delivery of Product
2-1-2004 73%
95%
3-1-2004 88%
95%
4-1-2004 89.1%
95%
-Customer Sat
2-1-2004 90%
95%
3-1-2004 88%
95%
4-1-2004 94%
95%

Nowhere is the question, how do I write a MDX statement that will return
that same cube with all of dimension drilldowns from the left but only
display 1 Metric. An example of what it should like:

- Software Score
Target
-Sun Microsystems
-IT
-Delivery of Product
2-1-2004 87%
95%
3-1-2004 88%
95%
4-1-2004 89.1% 95%

Thanks again for any direction,

Travis

Hi Travis,

Try this

Select {[Measures].[Score]} on columns,
{NonEmptyCrossJoin({[ComDim].AllMembers},{[Time].AllMembers})} on rows
From TestCube

Vinay Dharmik

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: MDX - newbie setup

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

Re: MDX - newbie setup - 08-13-2004 , 06:42 AM