Hi Guys,
I've been trying to hide nulls in dropdowns in OBIEE 12c but I am having issues, I read about this in documentation:
<ServerInstance>
<Prompts>
<ShowNullValueInPromptsWhenDatabaseColumnIsNullable>never</ShowNullValueInPromptsWhenDatabaseColumnIsNullable>
</Prompts>
</ServerInstance>
However when I add the <Prompts> Section to my instanceconfig.xml file BI Presentation Services fails to start, has anyone else had this issue? Is there another way to do this across all of OBIEE?