Welcome to the Oracle Analytics Community

Products Banner

Odarin ✭✭✭


  • 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.