Calculating Spread Sizes

Previous TopicNext TopicContents

The actual number of spread sizes depends on factors such as calendar work days, large differences in dates relative to the data date, ETL time duration, and the exclusion of zero value rows. A quick calculation uses a "best guess" on the average number of days for activities and resource assignments.

Total Activities: 1,000,000 X Average Activity Length: 5 = Total Spreads: 5,000,000

Related Topics

Queries for Spread Sizing

Estimating the Size of the Star Database

Estimating the Size of the ODS Database



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

Last Published Friday, January 31, 2014