P6 Analytics reporting is dynamic. The Oracle Star Database schema and OBI integration was designed to allow a very rich environment. This means that the daily load on the data warehouse server and OBI will vary greatly. You should consider:
Who will access P6 Analytics? A diverse set of users from the CEO to resource/project managers may require access to P6 Analytics. Each may have different requirements and use cases to consider.
What are the default ways of filtering? By default, user requests for analytic information will include all the data accessible by that user. That may be more time consuming, and may include more information than necessary. Consider ways of filtering data, such as by Project Codes and Portfolios.
What codes are used for reporting? While the Oracle ODS Database includes data from the P6 EPPM database, the Oracle Star Database schema includes only a subset of codes among activity, resource, project codes, and UDFs. You must determine which codes are critical for analysis.