MS SQL Server OLAP - MDX - With Set questions

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

MDX - With Set questions

john.r.carter@bankofamerica.com

2005-12-28, 8:24 pm

Does anyone know what I am doing wrong in the below MDX script. I am
trying to order the months as January, February, March .... accross the
rows.

When I try to order the months in the cube design, it orders the months
by name. Even when I choose to order by Key it orders the months by
1,11,12,2,3,4 and so on.

Thanks in advance

WITH SET [Response Date].[All Months] as '[Response
Date].[Month].[JANUARY],[Response Date].[Month].[FEBRUARY]'
SELECT
{[Measures].[Responses]} ON COLUMNS,
{[Response Date].[All Months]} ON ROWS
FROM
& #91;Programmatic_Bal
ance_Build]

Milind

2005-12-29, 3:24 am

Hi John

Make sure the Key is a numeric data type in the cube design. Then if
you order by key, it should show you the right order. Let me know if
you have questions.

thanks

Milind

Sponsored Links