April 12, 2009 at 8:52 am
Hi All,
I am a new bee to this world and need ur help in learning SSRS 2005.
I have two datasources: 1. Cube, 2. SQL database = datamart
Two datasets: 1.CustName_Dataset : this dataset queries customer table in sql database and gets the customer name.
2.Revenue_Dataset: this dataset will return the revenue of the customer(result of the first dataset), where as customer name needs to be inputted through the parameter.
FYR query: select {[Measures].[Revenue]} on columns from [Orders] where (StrToMember(@ParaCustName))
Currently when i execute this , error is: StrToMember expects member you are passing string or numeric.
I am not even sure if I am using the parameter properly.
Thanks in advance for your help
April 13, 2009 at 5:30 am
Would need more information as to how your parameter is configured and what it is returning. If it is returning the customer key (unique identifier) then this is not going to work. You would need to pass in a string, plus you would need to also pass this in with the proper format like [Customer].[Customers].&[12345].
Is there a reason that you are not just using the filter in the SSAS dataset and set this up as a parameter within the single dataset? Just wondering why you need the SQL data source.
If you are not sure how to setup the filter and parameter in the SSAS dataset take a look at my posting here and you will see a screenshot of this - Using Reporting Services (SSRS) with SSAS data.
----------------------------------------------------------------------------------------
Dan English - http://denglishbi.wordpress.com
April 13, 2009 at 8:28 am
Thanks for the response.
I was able to fix it. You are right problem is with the format of value that was in the parameter I have changed the format to include [Customer].[......].[.....].&[]..
I haven't used filters yet, I will go through the article you have sent me and see if I can get rid of the SQL datasource.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply