Adding Forecast data

After creating the Forecast query, you must set it up so it returns the appropriate forecast data when the report is run.

  1. Double-click the Forecast query to edit it.
  2. Under Insertable objects, select the Sources tab, and then drag these query items into the Data Items section:
    Namespace > Query Subject > Query Item
    Scheduling > Store > Store Name
    Scheduling > Forecast Driver > Volume Type
    Scheduling > Forecasts > Calls
  3. Click Show properties.
  4. Select the Calls data item and select Total in the Detail Aggregation property.
  5. Click Toolbox and then drag a Data Item object into the Data Items section.
    The Data Item Expression dialog box is displayed.
  6. Specify Volume in the Name field.
  7. Specify 0 (zero) in the Expression Definition field and click OK.
  8. Select the Volume data item and select Total in the Detail aggregation property.
  9. Click Toolbox and then drag a Filter object into the Detail Filters section:
    The Detail Filter Expression dialog box is displayed.
  10. In the Expression Definition field, modify the expression to:
     [Scheduling].[Forecasts].[Forecast Date] between 
     #$TIMESTAMP{$account.parameters.DB_TYPE }# 
     #prompt ( 'Start Date', 'date' )# 
     #$TIMESTAMP{$account.parameters.DB_TYPE + '.end' }# 
     and 
     #$TIMESTAMP{$account.parameters.DB_TYPE }#
     #prompt ( 'End Date', 'date' )# #$TIMESTAMP{$account.parameters.DB_TYPE + '.end' }#

    This expression creates Start Date and End Date parameters for the report.

  11. Click OK.
  12. Drag a Filter object into the Detail Filters section.
  13. In the Expression Definition field, specify this expression and then click OK.
    [Scheduling].[Store].[SKDGRP_ID] in (?Store?)

    This expression creates a Store parameter for the report.

  14. Click OK.
  15. Click the [Scheduling].[Store].[SKDGRP_ID] in (?Store?) filter.
  16. Click Show Properties and verify that the Usage property is set to Optional.
  17. Drag a Filter object into the Detail Filters section.
  18. In the Expression Definition field, specify this expression and then click OK.
    [Scheduling].[Store].[SKDGRP_ID] <> NULL

    This expression removes rows that do not contain a Store from the report results.

  19. Select the [Scheduling].[Store].[SKDGRP_ID] <> NULL detail filter, and select After Auto Aggregation for the Application property.