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
-
Oracle Analytics Cloud - Essbase—You can connect to multiple Essbase databases on a single worksheet, as described in Changing Connections in Multiple-Grid Worksheets.
-
Oracle Analytics Cloud—You can connect to multiple catalogs on a single sheet, as described in Connecting to Multiple Oracle Analytics Cloud Data Sources.
Watch this overview video to learn about Oracle Smart View for Office connections.
Watch this video to see a tutorial on navigating in Smart View, including connecting to a data source.
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 Developing Applications for Smart View for Office).