amadeu_j (7/4/2013)
So I can not put any parameter by default?
You can put a default on a parameter. You just need to make the dataset that calculates motherday dependend on the first parameter.
This thread goes deeper into the problem of cascading parameters not refreshing:
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP