NULL values in every dashboard prompt in OBIEE 12c

user12173428

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

Gianni Ceresa

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]

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

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