TimeDim - same day results

Question

Hello, when adding TimeDim ( time dimension) , it will only return results from previous days, for instance I am trying to populate results for today, 5/9/22   but it will only populate results from 5/8/22 and later, Thanks in advance if this is an easy fix.

Gianni Ceresa · Answer

Do you have any data for "today" ?

There is no magic, OBIEE/OAS does generate a query and execute it.

Look in the logs, find the generated query and there you will also find the reasons of no data for "today".

Maybe there is an inner join that remove "today" because of no data available in a table. The physical query generated will tell you exactly why you see what you see only.

It's impossible to tell you more about a fix, because you are the only one seeing what is happening and having the model you have etc.