range inclusive ssrs report builder using SSAS as source
I am using SSAS cube as source and building a report. In ssrs report builder i need to use designer mode to build the query . I need to use date range. When clicked on the appropriate dimension and then clicked the operation as range inclusive and then selected intial dates for the range it works fine. When i check mark parameters and then click ok on the query designer it throws a error saying "constrained by strtomember function" Can somebody throw light on this. Because some people with no query building knowledge will be using it so i need to use the GUI part to build the query Please help.. thanks in advance
March 23rd, 2011 7:53pm

Hi madhuajj, In order to use the Calendar control for a SSRS report that use SSAS as data source, the string value of the datetime parameter must be converted to an MDX Member Value before being passed to the data source. In order to make using a datetime parameter with a SSAS data source work, you need manually convert the parameter value, which is a string, to an MDX Member value. Following these: 1. Go to “Data” tab in Report Designer. 2. Choose the dataset that populates the report, and click the “…” button beside it. 3. Now, the “Dataset” dialog window shows, and clicking the “Parameters” tab in the dialog shows the list of parameters you may choose. 4. Assume the calendar control parameter is @Date, in the “Parameters” tab, you will have “Date” in the “Name” column, and “=Parameters!FromDateDate.Value” in the “Value” column. 5. Now, change the value column to: =”[Date].[Date].&[” + Format(CDate(Parameters!Date.Value), “s”) + “]” 6. Click “Ok” and close all windows. 7. Click “Preview” to test the result. If I misunderstand you, please feel free to let me know. Thanks, Challen FuPlease remember to mark the replies as answers if they help and unmark them if they provide no help.
Free Windows Admin Tool Kit Click here and download it now
March 28th, 2011 11:46am

I am using the designer mode and then when select range inclusive and then give default values and select parameters it throws this error. I would like to use the designer mode so the user can select the range what he wants. Thanks
March 31st, 2011 8:36am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics