Typically, when accessing the Microsoft Analysis Server to view an OLAP cube in SAS Enterprise Guide, users are prompted to enter credentials in the Multidimensional Connection window (Figure 1). This SAS KB article explains how to allow users to connect to the Analysis Server without being prompted for credentials.

Figure 1: Multidimensional Connection window prompts users to enter credentials.

 

Option 1

A system administrator can configure Microsoft Analysis Services to use Windows NT authentication (also known as Integrated Windows Authentication). With this type of authentication, users' Windows credentials are used to log in to Analysis Services. Users never have to enter any credentials, and they connect to the OLAP server automatically.

 

Option 2

In SAS Enterprise Guide, users can change the persistence setting for their credentials. By default, the credentials are persisted during the SAS Enterprise Guide session, but the setting can be set to persist the credentials for the user or with the project. This causes the credentials to be saved in the users settings on their machine or into the project file, respectively, and would affect all credentials for any servers.

To change persistence settings, select Tools ► Options ► Security.

Figure 2: Persistence settings for credentials can be changed in SAS Enterprise Guide.

For more information about creating a connection to a third-party OLAP server in SAS Enterprise Guide, see SAS Note 41722.