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)  convert sql 2000 mdx query to 2005 mdx format

Author  Topic  lk_wick Starting Member 2 Posts Posted - 2007-06-29 : 01:47:04 I need to convert following mdx query to 2005 mdx format. following query is in a string format (sql 2000). i need immediate reply to this problem. it is better if some one can explain the how to pass the parameter to this qury. ="WITH "+ "SET [FilteredBUSet] AS ' "+Parameters!BU.Value+ " ' "+ "SET [FilteredAccountSet] AS '"+Parameters!Account.Value+"'"+ "SET [CustomTimeSet] AS 'Descendants([Date—Fiscal].["+Parameters!FYear.Value+"].["+Parameters!FQuarter.Value+"]:"+ "[Date—Fiscal].["+Parameters!TYear.Value+"].["+Parameters!TQuarter.Value+"],[Date—Fiscal].[month],Leaves)'"+ "SELECT "+ "{NONEMPTYCROSSJOIN([CustomTimeSet],INTERSECT([FilteredBUSet],[FilteredAccountSet]))} ON ROWS,"+ "{[Measures].[Total Revenue],[Measures].[Margin %],[Measures].[Total Expenses]} ON COLUMNS "+ "FROM Profitability"