NULL values in every dashboard prompt in OBIEE 12c

Question

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

user12173428 · Answer

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

[Deleted User] · Answer

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.

Gianni Ceresa · Answer

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?