Monday, February 20, 2012

MDX in reporting services

having hard time solving this simple Query.
I am using the following Query in reporting services with sp1 installed .
="SELECT {[Measures].[Calls Handled],[Measures].[Transfer In
Calls],[Measures].[Transfer Out Calls]} on Columns,
NONEMPTYCrossjoin([DestinationDim].[Destination Site
Desc].members,[DestinationTetraGraph].[Destination Tetra Graph Desc].members)
on rows
from
ICMDestinationService where "+Parameters!period.value+""
When i give the parameter it is executing correctly.
When I pass the parameter the resulting
The error i am getting is
An error has occurred during report processing. (rsProcessingAborted) Get
Online Help
Query execution failed for data set 'Site_Dim'. (rsErrorExecutingCommand)
Get Online Help
Syntax error, expecting FROM, near: 'ICMDestinationService where
[TimeDim].[All TimeDim]
when i pass the same string without parameters i am getting the results.
Any Idea's or help will be Appreciated.
Thanks,
yalamanFinally I fot the solution. hope no one will wonder 2 days for getting sytax
error.
The answer -- there should be even spaces within the Query(I dont know
why?It is with interpreter )
Copy the query in notepad and adjust all the spaces between the Query and
Past it works.
Its is silly
SQL reporting team should address this type of errors.

No comments:

Post a Comment