hi ,
i am trying generate a report using following query. but the parameter is nt properly passing. (OLEDB). i need to correct it. pls help me.
="WITH "+
"MEMBER [Measures].[Amount] AS 'IIF(ISEMPTY([Measures].[Amount Usd]),0,[Measures].[Amount Usd])'"+
"SET [FilteredBUList] AS 'descendants((STRTOSET ( '{" & Join(Parameters!BU.Value,",") & "}', CONSTRAINED),[Account—BillingCodeDsc].[Billing Code Description],leaves) ' "+
"SET [CustomTimeSet] AS Descendants([Date—Fiscal].[2006].[Quarter 1]:"+
"[Date—Fiscal].[2007].[Quarter 4],[Date—Fiscal].[month],Leaves)"+
"SELECT "+
"{[Measures].[Amount]} ON COLUMNS,"+
"{ [FilteredBUList] "+
"}on rows"+
" FROM Profitability"
That BU parameter is multi value parameter. query should accept multi values .