OBI 11g Column Permission Setting: PROJECT_INACCESSIBLE_COLUMN_AS_NULL

In Oracle BI 10g, If a column is hidden from a user and when the User logs in there would be an error.

To fix this error, we have to change the parameter  PROJECT_INACCESSIBLE_COLUMN_AS_NULL in NQSConfig.ini

In Oracle BI 11g,  the parameter value is set to ‘YES’ :

[SECURITY]

DEFAULT_PRIVILEGES = READ;  

PROJECT_INACCESSIBLE_COLUMN_AS_NULL = YES;  # default is no

# Note that the paths below should be relative to the instance

# config directories if specified.  e.g.,

# $(ORACLE_INSTANCE)/config/OracleBIServerComponent/<instance_name>

#IGNORE_LDAP_PWD_EXPIRY_WARNING = NO;     // default is no.