The basic formulas for calculating the maximum number of Oracle Essbase ports you need for Financial Reporting are as follows:
If EPM Workspace and Report Server are on the same computer:
Number of Oracle Essbase ports = 2 X the number of Report Clients
If EPM Workspace and Report Server are on different computers:
Number of Oracle Essbase ports = 2 X the number of Report Clients
+ 2 X the number of Oracle Hyperion Enterprise Performance Management Workspaces
This formula is for Financial Reporting and does not consider other ways users might be connecting to Oracle Essbase; for example, the Application Manager, Oracle Hyperion Web Analysis, or the Excel Add-in. You must consider those potential port-takers separately. If they are used on the same computer as one of the Financial Reporting components, no extra ports are taken as long as the same Oracle Essbase user ID is being used. |
Data source considerations are as follows:
If you run a report with two data sources, your number of connections doubles, but the number of ports remains the same as described previously.
If you run a report with three data sources, your number of connections triples, but the number of ports remains the same as described previously.
If, after closing the report with two data sources, you run a report with a 3rd data source, your connections increases again but the number of ports does not change.
A user’s connection is open for at least five minutes and remains open for up to 10 minutes, assuming no new activity occurs during that time. If you have a limited number of Oracle Essbase ports, and many users are accessing Financial Reporting, you may want to lower both values to 30 seconds (30000).