Database Reference
In-Depth Information
Microsoft Oce
Smart View
Excel Addin
Internet Explorer
http/https
tcp 1423, 32767-33767
IIS
Weblogic
Foundation
RA Framework
Administration Services
Provider Services
Financial Reporting
Web Analysis
Print
Essbase
Integration Services
Studio Server
Metadata
Security
Configuration
Oracle DB: tcp 1521
SQL Server: tcp 1433
Optional
Fact Data for
EIS/Studio
Figure 1.2
Essbase architecture: Physical view.
Note:
If you have sufficient processor cores and you wish to optimize data
load or data export then review the options: DLSIngLEthrEADPErStAgE,
DLthrEADSPrEPArE, DLthrEADWrItE, and ExPortthrEADS.
1.4.2 Sizing
undersized systems in any environment, be it development, test, or production, have
ramifications both on project finances and project schedule. The tendency of It admin-
istrators to undersize development where the bulk of all new work occurs is a very poor
trade-off. It believes they are saving money (on servers). Finance or operations spends
money (a lot more than It saved) on consultants and employees who are waiting on the
slower, but less expensive, hardware.
I have seen Essbase installations that range from tens of users through thousands and
a handful of applications through hundreds. When you mix and match the number of
users with the number of applications and then add the third dimension of reporting
versus planning it can make sizing the system daunting.
The hardware is usually installed before the implementation consultants have even
started the design. This means the hardware sizing must account for a level of flexibility
whether through over-sizing physical servers or through use of virtual servers that can
have their resourcing changed relatively easily.
