Trying to hide NULL in dropdowns in OBIEE 12c — Oracle Analytics

Oracle Analytics Cloud and Server

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

Trying to hide NULL in dropdowns in OBIEE 12c

Question
1
Views
0
Comments
ideal2545
ideal2545 Rank 3 - Community Apprentice

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?