February 25, 2009 at 11:22 pm
Hi All
I've got a SSRS report that has been created over an MDX query. The MDX query looks some thing like this
SELECT NON EMPTY { [Measures].[Leaves Denied], [Measures].[Leaves Appr], [Measures].[Leaves] } ON COLUMNS,
NON EMPTY { ([Department].[Department].[Department].ALLMEMBERS * [Reject Reason].[Reject Reason].[Reject Reason].ALLMEMBERS * [Employee].[Employee].[Location].ALLMEMBERS * [Employee].[Employee Region].[Parent Region Code].ALLMEMBERS * [Employee Type].[EmployeeType].[Employee Type].ALLMEMBERS ) }
DIMENSION PROPERTIES MEMBER_CAPTION, MEMBER_UNIQUE_NAME ON ROWS
FROM ( SELECT ( STRTOSET(@EmployeeEmployee, CONSTRAINED) ) ON COLUMNS FROM [EMP])
CELL PROPERTIES VALUE, BACK_COLOR, FORE_COLOR, FORMATTED_VALUE, FORMAT_STRING, FONT_NAME, FONT_SIZE, FONT_FLAGS
Now I've call the report from my .NET application. However, when passsing parameters for the @EmployeeEmployee it says parameter not passed. However, when debugging I've seen that the param name is retrieved at the execution and the param value has been set and assing to the RS serveive variable
But still i get the error that the param @EmployeeEmployee is not assigned.
What is that I'm doing wrong?
Pls. Help
February 27, 2009 at 4:00 am
as it is the parameter passed into the MDX query you need to make sure the syntax is correct in MDX. Typically it is in the format of [Your Employee Dimension table].[Whatever Hierarchy].[Member of your Employee Dimension Table]. If you simply pass the employeeid/name, the MDX wont run
March 2, 2009 at 5:48 am
The MDX query is in the correct format
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply