Data Warehouse Properties, Analysis Server Tab
Use the Data Warehouse Properties dialog box, Analysis Server tab, to configure the Data Warehouse global resource connection to the Analysis Server (OLAP) database.
Primary Analysis Server Section
Use this section to configure the ConnStr_OLAP connection string. Commerce Server 2009 provides this server-side connection string for high availability business analytics configurations. You set this connection string when you unpack the Data Warehouse resource; it has Administrative rights.
Use this |
To do this |
|---|---|
Server |
Type the name of the Analysis server that contains the OLAP database used for dynamic reports. |
Database |
Type the name of the OLAP database used for dynamic reports. |
By default, any member of the Windows domain of the server where the OLAP database resides will have query (read) access to the Commerce Server 2009 OLAP cubes.
Secondary Analysis Server Section
Use this section to configure the ConnStr_OLAP_HA connection string. Commerce Server 2009 provides this connection string to access the OLAP database in high availability installations and staging environments.
Use this |
To do this |
|---|---|
Server |
Type the name of the secondary analysis server that contains the OLAP database that you use for dynamic reports. |
Database |
Type the name of the secondary OLAP database that you use for dynamic reports. |