To define the connection and Datasource at application level instead of globally, start on the Applications page instead of the Sources page. Click an application name, and then click Sources.
Click Create Connection, and for the connection type, select Essbase.
Enter a connection name; for example, Essbase2.
Either enter the Host and Port information, or check the box to Use URL. Connection information can be provided by your Service Administrator.
If you are using the URL, use the discovery URL format. A discovery URL is the URL provided by your Service Administrator, with /agent appended to the end. For example:
https://myserver.example.com:9001/essbase/agent
Click Test to validate the connection, and if successful, click Create.
Verify that the connection was created successfully and appears in the list of connections.
Next, you will create a Datasource for the Essbase connection.
Click Datasources, and click Create Datasource.
From the Connection drop-down box, select the name of the connection you just created.
Enter a name for the Datasource, and an optional description.
Select the application and database that will be used for this Datasource.
Provide a valid MDX query that selects the cube data you want to make available in this Datasource.
Click Next. If the MDX syntax was correct to query the remote cube, the queried columns are populated.
Change any numeric columns to Double, and click Next.
Change any additional source-specific parameters, if applicable, and click Next.
Review the preview panel. You should see the results of the MDX query fetching columns of data from the other cube.
If the preview looks correct, click Create to finish creating the Datasource.