Skip to content

Future Flow Report#

Overview#

The Future Flow report is an enhanced version of the Product Standard Flow report and the Material Flow report, based on data stored in the Operational Data Store (ODS). The report details how a Material or a Product is expected to progress through the production process. It enables process planning, production control and aids in troubleshooting and audits.

Warning

Enterprise Data Platform (EDP) does not yet support ODS, so this report will not work properly if you are using EDP. For more information, see EDP Tutorial ⧉.

It can be accessed through the Performance section from the Business Intelligence tab.

Future Flow report- Location

Filters#

The following filters are available:

  • Material Name
  • Product Name
  • Product Revision
  • Step name

Report Options#

You can further refine the report by selecting one or more of the following sections to include:

  • BOM
  • Checklist
  • Data Collection
  • Documents
  • Durables
  • Future Actions
  • Line Flow
  • Recipe
  • Resource
  • Reworks

Future Flow report- Filters and Options

Report Sections#

Firstly, the report header shows if the report is about a Material, or a Product, detailing which one below too.

After, a ribbon displays the filters and options selected when generating the report.

Depending on the entity the report pertains to, you are provided with the following details:

  • Product
  • Flow
  • Step
  • Primary Quantity
  • Secondary Quantity

Future Flow report- Material header

  • Product
  • Flow
  • Step

Future Flow report- Product header

Each Step (for example, Mixing, Baking or Cooling) has a distinct section which includes several subsections detailing the Step operations. If there are Rework or Line Flows, their Steps and details are also included at the end of the report.

Step Overview#

This section displays context information regarding the Step in question, including:

  • The Flow that the Step is part of
    • Type of Flow
  • Step that will be detailed
    • Step description
    • Primary Units

Data Source: BaseData table from DWH

Future Flow report- step overview section

Rework#

This section details if there was any Rework in the Step. You are provided with:

  • Go to Flow Path - what Flow path the rework started again from
  • Go to Step - what Step the rework started again from
  • Return to Flow Path - at what Flow path can the Material or Product return to after the rework
  • Return Step - at what Flow path can the Material or Product return to after the rework
  • Reason - reason for Rework

If there are Rework Flows specified for any Step, they are detailed at the end of the report with the organization detailed above.

Data Source: BulkReworkDetails table from DWH

Future Flow report- rework section

Line Flows#

This section displays the Line Flows referred to in the Step.

Firstly, a table details information included in the StepLineFlowContext. For example:

  • Product
  • Line Flow
  • Validation Mode
  • Assembly Mode

After, you can find a list of Line Flows with their description.

Data Sources: BulkPartialResolveContexts and BulkLineFlowDetails tables from DWH

Future Flow report- line flows section

The complete list of Line Flows applicable to the Material or Product can also be found at the end of the report with the organization detailed above.

Future Flow report- line flows section at the end of the report

Resource Information#

This section displays all the Resources used in this Step and their Services.

Firstly, a table details information included in the ServiceContext. For example:

  • Service - service name

For the every Service, you are provided with a list of Resources that can perform it and their descriptions.

Data Sources: BulkPartialResolveContexts and BulkServiceResourceDetails tables from DWH

Future Flow report- resource section

Recipes#

This section displays all the Recipes used in this Step and their parameters.

Firstly, a table details information included in the RecipeContext. For example:

  • Service
  • Recipe

Following, you may find details included in the [[recipeparameteroverridecontextt-st]]. For example:

  • Recipe the parameter
  • Parameter
  • Product group
  • Value

For the every Recipe and Sub-Recipe, you are provided with:

  • Parameters specified in the recipe
  • Type of parameter
  • Value of the parameter

Data Sources: BulkPartialResolveContexts and BulkRecipeDetails tables from DWH

Future Flow report- recipes section

Durables#

This section displays all the Durables used in this Step.

Firstly, a table details information included in the MaterialDurablesContext. For example:

  • Flow
  • BOM

For the every Durable, you are provided with details about their respective Products, such as:

  • Name of product and version
  • Position
  • Optional
  • Usage step
  • Material Reservation Mode

Data Sources: BulkPartialResolveContexts and BulkDurableBOMDetails tables from DWH

Future Flow report- Durables section

Data Collection#

This section displays all the Data Collection operations included in the Step and their parameters.

Firstly, a table details information included in the MaterialDataCollectionContext. For example:

  • Material
  • Operation
  • Data Collection
  • Data Collection Limit Set
  • Data Collection

For the every Data Collection operation and Data Collection Limit Set, you are provided with:

For each parameter, you can find the following information:

  • Details
    • Parameter name
    • If the parameter is optional
    • Data Type of the parameter
    • Units
    • Maximum value
    • Minimum value
  • Samples
    • Type of sample
    • Sample Id Material Property
    • Percentage Value
    • Minimum samples
    • Maximum samples
    • If the sample count is a percentage
    • Sample names
  • Calculation
    • Calculation name
    • Grouping
    • Limit checking
    • Rule
    • Expression
  • Instrument
    • Capture behavior
    • Type
  • Readings
    • Minimum sample readings
    • Maximum sample readings
    • Default value
    • Reading names
    • Readings
  • Protocols
    • Warning
    • Error
  • Documentation
    • Instruction

Data Sources: BulkPartialResolveContexts and [[dataplatform-dataset-bulkdatacollectiondetails]] tables from DWH

Future Flow report- data collection section

For each parameter, you can find the following information:

  • Override Validation Range
  • Include Sample Limits
  • Limit Type
  • Minimum Value
  • Maximum Value
  • Target
  • Lower Error Limit
  • Lower Warning Limit
  • Upper Warning Limit
  • Upper Error Limit

As well as information from sample limits:

  • Sample Id
  • Lower Error Limit
  • Lower Warning Limit
  • Target
  • Upper Warning Limit
  • Upper Error Limit

Data Sources: BulkPartialResolveContexts and [[dataplatform-dataset-bulkdatacollectiondetails]] tables from DWH

Future Flow report- data collection limit sets section

BOM Information#

This section details all the BOMs used in the Step and their parameters.

Firstly, a table details information included in the BOMContext. For example:

  • Material
  • Assembly Type
  • Track In Check Mode
  • Track Out Losses Mode
  • Weigh and Dispense Mode
  • BOM

For every BOM used and their respective Products, you are provided with:

  • Source Step
  • Quantity
  • Position
  • Material Reservation Mode
  • If it is a Fixed Quantity

Data Sources: BulkPartialResolveContexts and BulkBOMDetails Future Flow report- BOM section

Documents#

This section lists Documents included in the Step.

Firstly, a table details information included in the MaterialDocumentContext. For example:

  • Material
  • Document

Below that, a table lists the Documents including some details:

  • Document name
  • Description
  • Type of document
  • Author

Data Sources: BulkPartialResolveContexts and BulkDocumentDetails tables from DWH

Future Flow report- documents section

Checklists#

This section details all the Checklist instances included in the Step and the Items of each Checklist instance.

Firstly, a table details information included in the MaterialChecklistContext. For example:

  • Operation
  • Material
  • Checklist

For each Checklist instance, there are different sections for each Item and their respective tasks and state (example: Name of Task (Manual Task) Completed) detailing:

  • Parameter measured
  • Source
  • Type
  • Format
  • Optional
  • Default value
  • Range values

If the task requires a signature, the following data is also displayed:

  • Signature
  • Role
  • Certification that the user holds
  • Allow self

Data Sources: BulkPartialResolveContexts and BulkChecklistDetails tables from DWH

Future Flow report- checklist section

Future Actions#

This section details all Future Actions associated to this Step.

A table details context resolution information, such as:

  • Action
  • Execution
  • Flow
  • State
  • Sub-Materials Selection Mode
  • Sub-Materials
  • Send-Ahead Split Type
  • Evaluate Flow
  • Evaluate Step
  • Evaluate Flow Path
  • Merge Flow
  • Merge Step
  • Merge Flow Path
  • Results Capture Mode
  • Distribution List
  • Resource
  • Automatic Dispatch
  • Split Mode
  • Split Materials
  • Note
  • Comment

Data Source: BulkFutureActionDetails table from DWH

Future Flow report- rework section Future Flow report- rework section