OBIEE 11.1.1.9.5 'Include null Values' - Page 2 — Oracle Analytics

Oracle Analytics Cloud and Server

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

OBIEE 11.1.1.9.5 'Include null Values'

Received Response
104
Views
12
Comments
2»

Answers

  • 2981486
    2981486 Rank 3 - Community Apprentice

    I have had this same problem before. Indeed, it is not displaying in the line chart for certain months because the data simply doesnt exist.

    What I did was to create a Direct Database Request in OBIEE, and I wrote a query based on a timeline (I used my Time dimension), and for each month, make a case to check for data, else add NULL.

    I hope this gives you an idea.

    Joao

    Capture.PNG

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    Yes but I still would push it to the RPD and lower. DDRs have a habit of quickly reaching the limits of tjeir usability and generally aren't optimal.