When evaluating the physical hardware requirements, you need to consider:
- The performance of the ETL process
- The performance and concurrency of the online reporting solution
While the ETL process is fixed regarding concurrency, the reporting needs will vary greatly. The demands on Primavera Data Warehouse and Primavera Analytics may change from day-to-day. For performance sizing of OBI, please refer to the technical documents for the specific component (BI Publisher, BI Server, and Answers/Dashboards). This document will focus on the performance of the ETL process and queries generated against the warehouse database (Star).