2 Replies Latest reply: Jun 24, 2013 9:16 AM by sitheris RSS

    How to default a multi-select parameter to ALL values?


      I have a parameter that allows the user to select multiple values.  I want it to default to use ALL values (meaning basically just ignore this parameter in the SQL generated).  However, I cannot create a calculation on this since it accepts multiple values, and the calculation only supports the first value.  Is there a way to do what I need, without selecting all the values in the list (the LOV contains hundreds and hundreds of values so this is not a viable option).  I am not very experienced with Discoverer and don't know all the tricks/workarounds, so looking for expert advice.