Connect to Essbase Data Sources

You can create, edit, and delete Essbase connections and use the connections to create data sets from Essbase cubes.

Topics:

• Create a Connection to Oracle Essbase
• Create a Dataset from an Essbase Connection

Create a Connection to Oracle Essbase

You can create a connection to Oracle Essbase 11g and use the connection to access source data.

1. On the Home page, click Create, and then click Connection.
2. Click Oracle Essbase.
3. Enter the connection details.
4. For DSN (data source name), enter the agent URL for your data source.

   If you want to connect to an Oracle Essbase 11g database, enter the hostname and agent port number on which Oracle Essbase is running. Use the format: hostname:port

   For example: essbase.example.com:1423

   The default port is 1423.

   Your Essbase administrator must open agent port 1423 and server ports in the range 30000-34000 to allow the connection.

5. For Username and Password, enter user credentials with access to the Essbase data source.
6. Under Authentication, specify how you'd like to authenticate the connection:
   • Always use these credentials - Oracle Analytics always uses the login name and password you provide for the connection. Users aren’t prompted to log in.
   • Require users to enter their own credentials - Oracle Analytics prompts users to enter their own user name and password for the data source. Users can only access the data for which they have the permissions, privileges, and role assignments.
   • (Displayed if Oracle Analytics supports impersonation for this database type) Use the active user’s credentials - Oracle Analytics doesn't prompt users to sign in to access the data. The same credentials they used to sign in to Oracle Analytics are also used to access this data source.
7. Save the details.
   You can now create datasets from the connection.

Create a Dataset from an Essbase Connection

You can use an Essbase connection to create a dataset.

Note:

Essbase connections aren't available to create or include in a dataset with multiple tables.

Datasets that use Oracle Essbase connections aren't available for blending.

Before you create the dataset, confirm that the data source connection you need exists. See View Available Connections.

1. On the Home page, click Create and then click Dataset.
2. In the Create Dataset dialog, select the Essbase connection.
3. In the Transform editor's Add Dataset step, double-click the Essbase cube that you want to use in the dataset.
4. Optional: Select an Alias value.

   If you select an alias value other than the default, then values from the selected alias table are displayed in visualizations that use this Essbase dataset.

5. Click Add to save the dataset and go to the Transform editor to transform and enrich the dataset's data.