Analysis Server Cube / Data Analyzer Query

[niraj2000]

I am using Sql server 2000 Analysis Service and MS Data Analyzer as my OLAP reporting tool.

I have 4 dimensions built in cube and displayed in my data analyzer view.
For eg, consider the dimensions as A, B, C, D.

I have 3 measures. For eg, X, Y, Z.

Consider a scenario where I have all 4 dimensions in grid view. For dimension A, B, C, I want to display measure X & Y.

For dimension D, I want to display only measure Z and hide all other measures. Can I do that in Data analyzer or I have to make changes/settings in Sql server cube.

Please help !!

 

[MDXer]

I'm not familiar with DataAnalyzer but it is probably doing a siple crossjoin. If this is what is is doing then it will crossjoin everything on rows with everything on columns. If DataAnalyzer allows you to directly input MDX then you could probably do what you need.

-Paul

Paul