Before you create a report, you must first create an Essbase data source connection.
To create an Essbase data source connection:
Select Connection on the main SQR Production Reporting Studio screen.
The Create Data Connection wizard is displayed.
On the first page, enter a name to identify the data connection.
For example, you could enter Essbase to identify a connection to an Essbase data source.
On the second page, select DDO to identify the data source provider.
On the third page, select an Essbase data source.
The wizard displays the available registries and data sources. (
(Optional) On the fourth page, enter login parameters.
If you do not enter a username and password here, you are prompted to enter a username and password each time you connect to the database and create a report. If you do enter a username and password here, however, you are not prompted to enter them again.
If you choose to override the default server name or the default database name, enter the desired server name or database name here.
Click Finish to exit the wizard.
The data source you defined appears in the Data Connection dialog box.
Highlight the data source and click OK.