To define a connection to a Performance Management Architect data source:
Right-click Data Sources in the physical tree and select New, then Data Source.
In Data Source Type, select Dimension Server.
Performance Management Architect is an example of a dimension server.
Under Parameters, in Server Name, enter the name of computer where Performance Management Architect Dimension Server resides.
Optional: To use a port number other than the default, clear the Default check box next to Port and enter the correct port number in the text box.
If you are using the default port number, skip this step.
Enter the User Name and Password for this Performance Management Architect Dimension Server instance.
Select a Data Encryption method:
No Encryption—This is the default mode for communication between Essbase Studio Server and a Performance Management Architect Dimension Server.
SSL—If the Performance Management Architect Dimension Server instance to which you are connecting is configured for Secure Socket Layer protocol over TCP/IP (SSL), select this method.
SSL allows for secure communication between Essbase Studio Server and Performance Management Architect Dimension Server.
Note: | If you select SSL, and Performance Management Architect Dimension Server is not configured to support SSL, then connection cannot be established and an error message is displayed. |
If the information you entered in the wizard is correct, a message is displayed confirming a successful connection.
If you entered incorrect information in the wizard, a message is displayed explaining that invalid credentials were provided. Correct the errors and retest until the connection is successful.
Clicking Next takes you to the Create Metadata Elements page of the wizard, as described in Creating Metadata Elements for Performance Management Architect Sources.
If you clicked Finish, you should be able to expand the data source name in the Source Navigator to view the dimensions and levels of this data source.