Complete the Connection to Analysis Services

After you create the database connection as described in Create a Database Connection for Analysis Services, complete the connection as follows:

1. Click New.
2. Enter a name for the database login object, a login ID, and a password. For information on allowing Windows users' login credentials to be used to execute against MDX cubes imported from Analysis Services into Strategy, see Single Sign-On to Microsoft Analysis Services.
3. Click OK.
4. Choose Default database login name > OK.
5. Choose Database connection > OK.

After you have connected a database instance to your Analysis Services 2012/2014/2016/2017/2019/Azure server, you can begin accessing your Analysis Services 2012/2014/2016/2017/2019/Azure data from a Strategy project. For information on configuring the MDX cube database instance in a project, see Configuring MDX Cube Database Instances in Projects.