Make filter option for SP query subject

[stacybost]

Is there a way to make parameters passed to a stored procedure optional?

I have a sp query subject.  Inputs to the SP are period_id and week_id.  If a user selects a period but no week, the SP returns data for the period. 

If I have two prompt in CRN, one for period and one for week (not required), how can I make the SP Query Subject not require week_id?

Hope that questions makes sense...

Thanks,
Stacy

[stacybost]

FYI...

I've discovered that the answer is NO, filters passed to stored procedures are not optional.

An enhancement has been requested for this feature.