Stored procedures with YellowFin

Hi Support,

We are using Yellowfin 6.1 and I have recently inhereted a Yellowfin
environment.
I have a stored proc with 4 parameters and am using this as the source of a Yellowfin report.Can I build drop down multi select filters from the parameters of this stored proc or should I will I have to convert this proc to view to achieve this result.

Thanks
Helen

Hi Helen,

drop down multi select filters are only available when you use the In List filter operator. However stored procedure parameters can only have the Equal To operator because the parameter value has to be an exact value so that it can be substituted back into the SP.

I think an example is needed to explain that better, if a stored procedure has a line of code like:

[code]WHERE athlete_age > minimum_age[/code]

then we need an Equal To operator when the report is run, so that for example if the user enters 18 then after substitution the code would read:

[code]WHERE athlete_age > 18[/code]

regards,
Dave