Data Warehouse Properties, Analysis Server Tab
For the latest version of Commerce Server 2007 Help, see the Microsoft Web site.
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 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 OLAP cubes.
Secondary Analysis Server Section
Use this section to configure the ConnStr_OLAP_HA connection string. Commerce Server 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. |