Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2005 Forums  Analysis Server and Reporting Services (2005)  select Dimension and Measures

Author  Topic  Gili Starting Member 42 Posts Posted - 2008-05-21 : 09:38:12 Hi, I need to create query that will return some Dimension and Measures for example : i have dim1,dim2,dim3 and dim4 and Measures : m1,m2,m3,m4,m5. what is the best way to write an mdx that will return what i want. is this ok : select non empty crossjoin({[dim1].Members} ,{[dim2].Members} , {[dim3].Members} ,{[dim4].Members} ) on columns, {[Measures].[m1],[Measures].[m2],[Measures].[m3],[Measures].[m4],[Measures].[m5] } on rows from [cube] is there maybe a way to get all Dims and Measures in aquery like select * from table in t-sql??? Thanks.