Multi-Tier: Dedicated BI and Distribution Servers + AppServer + DB Server
This configuration is highly recommended for Intensive Distribution usage.
Large volume and large count of users:
A dedicated server is used for the Web Client and BI Service.
One for the Distribution Service. One for all the Databases and other Services.
Application Server
ERP Application
Database Server
ERPDB + SEIDatabase + BI License Database + Cube Database + DataSync Database) [1*]
Dedicated Web Client
SEI Server (custom installation without Distribution Service)
Dedicated Distribution
SEI Server (custom installation with Web Client + Distribution Service + BI Service)
Microsoft Excel (* in case you are using Excel Add-In into the Distribution)
[1] This configuration is not optimized for Cube performance (more specifically for Load All and Refresh tasks) unless you do the following:
- Disable the Job Service on the Dedicated Web Client
- Install the BI Service and Job Service on the same server as the Cube Database
- Edit the web.config file (located in C:\inetpub\wwwroot\WebClient ) on the Dedicated Web Client by replacing the Value "http://OLAPDBSERVER:4504" of the following Key with the Server Address on which you installed the BI Service and Job Service:
<add key="jobServiceAddress" value="http://OLAPDBSERVER:4504"/>
All BI databases can be separated (on Dedicated Web Client or Dedicated BI Database Server).