It seems we can reuse an existing MDS schema when running the Repository Creation Utility (RCU). Previously I’d always created a new one for each installation but I guess I should have paid more attention to the Oracle documentation… If your organization has an MDS schema installed in a supported database, you do not need [...]
Make sure the DEV_BIPLATFORM and DEV_MDS users have the same password and that their accounts aren’t locked after running the RCU. Despite what Oracle would have you believe it seems the DBA role is not required and nor are SYSDBA nor SYSOPER privileges.
Running the OBIEE 11g Repository Creation Utility (RCU) against a SQL Server database wasn’t as straightforward as I’d hoped. There are a few preliminary tasks which aren’t obvious so I’ve decided to put this guide together. First log in to your SQL Server and create a new user. In this case I’m naming it obi_user. [...]