Null values in prompts After OBIEE to OAS upgrade

Karthi_obiee

After upgrading from OBIEE 12c to OAS. I am seeing null values in prompt dropdowns that did not appear in OBIEE. The prompt values match both systems, but these extra nulls are unexpected.

Any help is appreciated, thanks!

Ram-Oracle

@Karthi_obiee kindly please check the solution from following document and see if it helps

'NULL' Is Appearing As The Default Value In OAS Dashboard Prompts (Doc ID 2885418.1)
'NULL' Is Appearing As The Default Value In OAS Dashboard Prompts (Doc ID 2885418.1)

Gianni Ceresa

Quite sure Ram is right, and the linked document tells you why it's happening: the product does what it is instructed to do. If your model says a column can be null, it does make sense that NULL is an option in a prompt, but NULL is not really a normal value, therefore it has to be handled in a special way, and that's what the prompt does when based on a column that, by design, can be null.

Karthi_obiee

@Ram-Oracle

@Gianni Ceresa

Thank you for your swift response.

Bhaskar Konar

Very helpful information.

Thanks for sharing @Ram-Oracle.