Default Date parameter

Hi Experts,

I have few questions regarding the default date parameter in BIP 11.1.1.3.

1) If we put the default date as {$SYSDATE()}, it doesnt refresh everyday. Instead it returns data for the date on which the data model was created. Now, this is a known bug which would be fixed in Ver 11.1.1.5. My queston : is there an alternative to overcome this issue in 11.1.1.3?

2) Is there a way to give NULL as a default value for the DATE parameter?

3) If user doesnt select a date (i.e parameter is not passed) what does the DATE parameter return back as value to the query? To handle this 'no value', we are using IFNULL in the query. However, it errors out when we dont pass any value.