Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


SSRS / SSAS Params Passing thru DOTNET


SSRS / SSAS Params Passing thru DOTNET

Author
Message
pavan_crm
pavan_crm
Grasshopper
Grasshopper (10 reputation)Grasshopper (10 reputation)Grasshopper (10 reputation)Grasshopper (10 reputation)Grasshopper (10 reputation)Grasshopper (10 reputation)Grasshopper (10 reputation)Grasshopper (10 reputation)

Group: General Forum Members
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
george.qiao-644713
george.qiao-644713
Forum Newbie
Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)

Group: General Forum Members
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
pavan_crm
pavan_crm
Grasshopper
Grasshopper (10 reputation)Grasshopper (10 reputation)Grasshopper (10 reputation)Grasshopper (10 reputation)Grasshopper (10 reputation)Grasshopper (10 reputation)Grasshopper (10 reputation)Grasshopper (10 reputation)

Group: General Forum Members
Points: 10 Visits: 11
The MDX query is in the correct format
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search