Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

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

NULL values in every dashboard prompt in OBIEE 12c

Received Response
32
Views
3
Comments
user12173428
user12173428 Rank 1 - Community Starter
edited Aug 13, 2024 7:24PM in Oracle Analytics Cloud and Server

Hi

I have designed many dashboard prompts in OBIEE 12c, every prompt has a NULL value, please guide how I can remove this such as

NULL

2019.00

2018.00

2017.00

also how I can remove .00 or add format in year data

regards

Rai Qaiser Hussain

Answers

  • Gianni Ceresa
    Gianni Ceresa Mod

    Your column is badly defined in the RPD. If the year (I assume it's a year column) doesn't have NULLs, don't define the relative physical column as nullable. The '.00' is maybe because it is defined as a different type than integer?

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

    1.) Year should be an INTEGER. Not a DOUBLE.

    2.) Does your column contain NULLs physically? I.e. in the database / data source?

    OBI is an analytical tool. It's not there to hide bad data. Fix the data. Fix the model.

  • user12173428
    user12173428 Rank 1 - Community Starter

    Thanks both of you,

    Mr. Christian there is no option to mark your answer correct as I marked for Mr.Gianni but I am really thankful to both of you, You solved my problem

    regards

    Rai Qaiser Hussain