Thank you for the replies! and sorry for the late answer, I had to give it a lot of thought. I still think that this behavior is not optimal at the least, and here is why: When the join between the date dimension and the fact is already applied once in the AGO calculation, OBIEE could easily just add the WHERE clause…