Part 3: Total Required Versions

Calculate the total number of required versions to calculate the row count. Suppose that concurrently there are 4 budgets and 4 forecasts in the system and they all undergo the solicitation process simultaneously.

To calculate the total number of versions:

  1. Calculate the number of base Master/Sysforecast versions:

    = number of budget Master versions

    + number of forecast Master versions

    + number of Sysforecast versions

    = 4 + 4 + 4

    = 12

  2. Calculate the number of solicitation versions, based on Part 1: Copies for Budget Solicitation and Part 2: Copies for Forecast Solicitation:

    = (number of budgets currently in the solicitation process x number of solicitation copies of the budget) + (number of forecasts currently in the solicitation process x number of solicitation copies of the forecasts)

    = (2 x 11) + (2 x 5)

    = 32

  3. Calculate the total number of versions, based on the previous steps:

    = base Master/Sysforecast versions + solicitation versions

    = 12 + 32

    = 44

  4. Calculate the total number of rows per version:

    = total number of locations x total number of time periods

    = 1438 x 70

    = 100660

  5. Calculate the total number of rows in the system:

    = total number of rows per version x total number of versions

    = 100660 x 44

    = 4429040 rows