NEW: MDX Query

#1

H

I have a cube with a dimension (Time) with two levels : YEAR and MONTH

I have also a measure Amount

I need a MDX query that returns as follow

2003 JAN 100
FEB 30
..
..
..
2004 JAN 345
..

IMPORTANT: the level YEAR and MONTH must be in different column

How to write this query???

#2

You want to display the year name but not display the total for the year?

So as not to get your hopes up, we might be headed for an answer "may not be
doable, depends on the client".

public @ the domain below
www.tomchester.net

"Ale Dori" <anonymous (AT) discussions (DOT) microsoft.com> wrote

Quote:

HI

I have a cube with a dimension (Time) with two levels : YEAR and MONTH;

I have also a measure Amount.

I need a MDX query that returns as follow:

2003 JAN 1000
FEB 300
...
...
...
2004 JAN 3456
...

IMPORTANT: the level YEAR and MONTH must be in different column

How to write this query????

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

NEW: MDX Query

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

NEW: MDX Query - 03-05-2004 , 08:51 AM

Re: MDX Query - 03-05-2004 , 10:51 AM