Connecting to Data Sources
For most data sources, you can connect to only one data source per worksheet.
Oracle Analytics Cloud - Essbase—You can connect to multiple Essbase databases on a single worksheet, as described in Changing Connections in Multiple-Grid Worksheets
To connect to a data source:
Notes:
The following applies to Oracle Analytics Cloud - Essbase only:
-
If external authentication is disabled, for security reasons, you must provide your user name and password each time you connect to a different application on the same server.
-
Once connected to an Essbase database, users can view database notes associated with the database. To display database notes, from the Smart View Panel, right-click the name of the Essbase database, and then select Database Note. You cannot edit these database notes from Smart View. Database notes can be implemented in VBA by using the VBA function, HypGetDatabaseNote (see the Oracle Smart View for Office Developer's Guide).