Oracle Analytics Forum

Home› Oracle Analytics and AI› Oracle Analytics and AI Forums› Oracle Analytics Forums› Oracle Analytics Forum

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

TimeDim - same day results

Received Response
1
Views
1
Comments
User_IA53R
User_IA53R Rank 2 - Community Beginner
edited Aug 13, 2024 5:09PM in Oracle Analytics Forum

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.

Answers

  • Gianni Ceresa
    Gianni Ceresa Mod

    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.