locked
Getting error while adding parameter in report RRS feed

  • Question

  • HI,

    I have created a cube and SSRS report and added 3 parameters for this dataset(DS1).
    I added another dataset (DS2) and parameter to set default values for these 3 parameters.
    While selecting first parameter for DS1 other 3 parameters is loading with default values and it is correct.
    But the issue is ,while viewing the report it showing an error like this.
    "Query Excution failed for DS1".
    "The restriction imposed by the CONSTRAINED flag in the STRTOSET function were violated"

    I loaded the above 3 parameters from the dataset DS2. This is the reason for this error?
    But how can I solve this?.

    Any help is appreciated...

    Thanks in advance.

    Thursday, June 6, 2013 11:49 AM

Answers

  • "When the CONSTRAINED flag is used, the set specification must contain qualified or unqualified member names or a set of tuples containing qualified or unqualified member names enclosed by braces {} "

    Check the value mapped to the paramter, for example,

    =”[Date].[Calendar].[Date].[" + Format(CDate(Parameters!DateCalendar.Value), "MMMM d, yyyy") + "]“

    Alos go through this article:http://blog.datainspirations.com/2010/10/07/using-dynamic-mdx-in-reporting-services-part-1/


    http://www.bifeeds.com

    • Proposed as answer by Elvis Long Tuesday, June 11, 2013 9:18 AM
    • Marked as answer by Elvis Long Monday, June 17, 2013 7:06 AM
    Thursday, June 6, 2013 12:21 PM