Joel, Gianni, thanks for your answers! As I understand, the best way is to update date_table and add days columns there to make join with order date. But then I have one more question (perhaps very lame, sorry!) - now I have only one date dimension build on my date_table. I'll make 1=1 join with order date by day and if…

Thank you, that is nice idea! The slight disadvantage is that it shows only reports that was ever used but it is still very helpful.

nay, unfortunately it didn't help

Yes, I unchecked "suppress" on all columns, but it is not works. Yes, the physical query returns duplicates, so I believe that it is indeed the analysis problem.