I am Designing a Report in Reporting Services Design Mode, i need to pass a
parameter to the MDX query with DRILLTHROUGH OPTION

But when I Past this query in the Data tab the (Run) button is disabled......

="DRILLTHROUGH
SELECT {[Measures].[Online Course Count]} ON COLUMNS,
{[" & Parameters!pX_sUser.Value & "]} ON ROWS
FROM
[SessionCube]
RETURN
[$Dim User].[sUser] as [User],
[$Dim User].[s City] as [User City],
[$Dim User].[s Country] as [User Country],
[$Dim User].[s Job Title] as [User JobTitle]"

But When I Past the below code
( " - before =)
"=DRILLTHROUGH
SELECT {[Measures].[Rpt FACT Online Course Count]} ON COLUMNS,
{[" & Parameters!pX_sUser.Value & "]} ON ROWS
FROM
[ILNETLSessionCube]
RETURN
[$Measures].[Rpt FACT Online Course Count] as [Count],
[$ETL Dim User].[sUser] as [User],
[$ETL Dim User].[s City] as [User City],
[$ETL Dim User].[s Country] as [User Country],
[$ETL Dim User].[s Job Title] as [User JobTitle]"

The Run button is getting enabled, It gives me a syntax error
The syntax for '&' is incorrect, what could be the problem...

Thanks
Balaji

--
Message posted via http://www.sqlmonster.com