Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SSRS / SSAS Params Passing thru DOTNET Expand / Collapse
Author
Message
Posted Wednesday, February 25, 2009 11:22 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, March 10, 2009 4:01 AM
Points: 10, Visits: 11
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
Post #664801
Posted Friday, February 27, 2009 4:00 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, April 6, 2009 5:36 PM
Points: 8, Visits: 71
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
Post #665588
Posted Monday, March 2, 2009 5:48 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, March 10, 2009 4:01 AM
Points: 10, Visits: 11
The MDX query is in the correct format
Post #666510
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse