Issue: You cannot connect to OLAP Metadata Catalog or to the external data source.
Possible Solutions:
Ensure that you are using the correct user name and password.
If you are trying to connect to OLAP Metadata Catalog, ensure that you used the same user name and password as the user who created the tables in OLAP Metadata Catalog.
If you create OLAP Metadata Catalog when logged in as one user name, you cannot access the tables in OLAP Metadata Catalog using a different user name unless you create an alias for the user name (for Microsoft SQL Server) or synonyms for the tables (for IBM DB2 and Oracle).
Ensure that the user name has the required access privileges for OLAP Metadata Catalog and for the data source at the database level.
Ensure that all of the required components are up and running. The following components are required:
Oracle Essbase Integration Services Server
The database servers that manage OLAP Metadata Catalog and the data source databases
The data source database listener for OLAP Metadata Catalog and the data source
Ensure that OLAP Metadata Catalog and the data source are configured as ODBC data sources on the Integration Server computer.