Writing Multi-Dimensional Queries

Writing Multi-Dimensional MDX Queries queries in SSAS.

Sometimes while executing your MDX query, you will get the below error.

"results cannot be displayed for cellsets with more than two axes "

I want to display ProductID in the Y Axis and Date in the X Axis, sum of count values in the column values or Data values.

Oops, all the mdx books will tell you about rows and columns... am really amazed to see that no one or no sites are explaining the practical issues of writing mdx queries. 

Anyway, some how I found the logic to obtain the MDX query. After my discovery, I found similar topic in the below article.

http://www.activeinterface.com/b2005_11_25.html

It may be useful to some one,

 Here is my MDX query,


     SELECT NON EMPTY [OrderDate]     DIMENSION PROPERTIES MEMBER_NAME, PARENT_UNIQUE_NAME ON COLUMNS, 

NON EMPTY [ProductID] DIMENSION PROPERTIES MEMBER_NAME, PARENT_UNIQUE_NAME ON ROWS,

{[Measures].[Sum-Safetystocklevel], [Measures].[Safetystocklevel Count], [Measures].[Maximum Safetystocklevel], [Measures].[Minimum Safetystocklevel]} ON PAGES FROM [VenkatCube] 

Cheers,

Venkatesan Prabu .J 

Head, KaaShiv InfoTech.

http://www.kaashivinfotech.com/