Greater than Equal to Parameter SSRS report and SSAS Cube

• Nilesh-788004

  Ten Centuries

  Points: 1190

  More actions

  November 3, 2014 at 5:46 pm

  #300714

  I have an SSRS 2012 report and SSAS Cube in 2008. My report criterion requires filtering on measures. So Created measures as dimensions . The report requires >= functionality on the measures. But in the Query designer of the report there is =, IN, Within Range ,Excluding range , MDX as the operators.

  To achieve my goal. I have “From” and “To” as parameters on the numeric dimension. The “To” parameter I have set as internal and setting the default value of “TO” .By writing another Dataset query that returns the “MAX” value and the MAX value returned is a member of the measure converted to dim I confirmed.. So this whole works as >=.The user enters only the “FROM” parameter and the “TO” is set internally. The user can enter any value in the “From” parameter. Any value that is not even a member.It is a textbox. I cannot use a list of values from the “From” parameter.

  But whenever I run the report after entering all the selection criteria I keep getting

  Error “the restrictions imposed by the constrained flag in the strtomember functions were violated”

  I know this means that Max value in the “TO” section is not a member .

  I did try : StrToMember("[Fact RCS CV BLAST].[APPRLIMIT ACH].

  &[" & @ToFactRCSCVBLASTAPPRLIMITACH & "]", CONSTRAINED) )

  But I get “syntax for the “&” is incorrect”

  If I use Drop down for the “From” and “To” parameters then it works fine. But that’s not what Business Users need.

  Please let me know what the options to make this work. I did use parameters that filter the Dataset returned it works fine but there is a performance impact.