OBIEE 11g Administrator Opens The Online Repository In Read Only Mode

Using the OBI Administrator to connecting to the BI Server running on Linux always opens the repository in Read-Only mode and does not allow real-time changes. Even if you have confirmed that the configuration setting in EM for 'Disallow Online RPD Updates' - has been de-selected / un-checked. We face this issue only in following scenarios,

• OBIEE is installed on other than Windows platform and DSN is created on Windows to connect to repository through Admin Tool.
• Oracle BI Administrator 11g installed on Windows 32-bit (Administrator could be on Windows 7 64-bit)
• ODBC System DSN created to connect with the BI Server running on the remote server.

In short we can summerise all this in as,

ODBC DSN on the machine where the BI Administrator tool is installed was not configured properly for a clustered DSN.

Confirm that the the configuration setting 'Disallow Online RPD Updates' - has been de-selected / un-checked in EM.

If using a clustered ODBC DSN., then configure the Oracle BI Server ODBC DSN used by the Administration Tool to point to the Cluster Controllers rather than to a particular Oracle BI Server. Ensure the hostnames and ports are correct.

If your OBIEE system is not clustered one, then just un-check the "Clustered DSN" and if not using a clustered ODBC DSN, then make sure you are connecting directly to the BI Server and the hostname is correct as shown in below fig.

Click Next and put your admin credentials.

Select "Connect" checkbox.

Make sure you succeed to get login to the targeted server then you can see all the available Subject Areas in repository on the server. Confirm and Finish the setup. 

If any error, make sure you are pointing to the correct server with correct port and login credentials.

You should login to repository in online mode with read-write access this time.

Happy blogging..