Monitoring Dimension and History Level Impacts on the Database

Previous TopicNext TopicContents

P6 Reporting Database includes slowly changing dimensions and daily level history for activity and resource assignment. If you choose to use slowly changing dimensions and these levels of history, they could cause the Star database to grow quickly. For example, if you update 10 activities in a project and run the ETL process, 10 rows will be added in the activity slowly changing dimension table and in the assignment history and activity history fact tables.

You should plan the database and server configuration to ensure you can monitor database growth and allow for expansion based on the number of changes. If growth is exceeding what you expected in your environment, you can disable slowly changing dimensions if they are not required. See the installation and configuration guides for more information.



Legal Notices
Copyright © 1999, 2014, Oracle and/or its affiliates. All rights reserved.

Last Published Friday, January 31, 2014