Defining a Connection Profile

Each time you log on to SAS OLAP Cube Studio, a connection is made to a metadata server. Before you can build a cube in SAS OLAP Cube Studio, you must specify a connection profile that contains the information for the metadata server that you want to build your cube with. In SAS OLAP Cube Studio, select File

Connection Profile. On the Open a Connection Profile dialog box, you can choose to either create a new connection profile or edit an existing one. If you choose to create a new connection profile, the Connection Profile wizard will open. The following display shows the information that is entered for a connection profile.

Enter the machine information for the metadata server that you will connect to and retrieve a data source from.

In the New Connection Profile dialog box, enter the machine ID, port, your user ID, and password.
Note: These fields are the equivalent of the following METASVR statement options:
- HOST=
- PORT=
- USERID=
- PW=
- Here is an example of the PROC OLAP code:
  metasvr host=localhost port=9999 protocol=bridge userid=userid pw=pw repository=Foundation olap_schema="OLAP Schema"
After you have entered the basic connection information, you can select to do one of the following:
- enter the authentication domain for the SAS Metadata Server
- save the user ID and password with the connection profile use Integrated Windows authentication (single sign-on). The Integrated Windows authentication option specifies that access is based on the user's previous authentication to the Windows desktop.
Note: For more information about authentication and single sign-on, see “Understanding Authentication” in the SAS Intelligence Platform: Security Administration Guide.