Cube Building and Modifying Examples

Defining A Connection Profile

Each time you log onto 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.

[New 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 or 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 on authentication and single sign-on, see "Understanding Authentication" in the SAS Intelligence Platform: Security Administration Guide.

Top of Page