Analyze Calculated Supply and Demand Measures Using Configured Attributes

You can analyze the calculated supply and demand measures using the user-configured planning attributes.

Using attributes such as Project, Task, Country of Origin, or any configured planning attribute, you can gain insight into forecasted inventory for enterprises. You can enable specific planning measures to compute the values at the planning attribute level. The planning measures display the value of the measures in any time bucket either in the planning attribute measure context or by running a project-driven supply chain plan at a project and task level in the pivot table or material plan.

You can use the following supply and demand measures to calculate using the planning attributes.

Projected Available Balance
Projected Available Balance Value
Projected On Hand
Safety Stock
Safety Stock Value
Average Daily Demand
Project Available Balance Days of Cover
Safety Stock Days of Cover

Note: You can't archive Projected Available Balance, Projected Available Balance Value, Projected On Hand, Safety Stock, and Safety Stock Value measures dimensioned by planning attribute dimensions, or include them in plan comparison.

You can create user-defined measures with planning attributes using these measures to analyze the attribute-based plan output.

The feature is applicable to unconstrained supply plans and demand and supply plans.

Here's some additional information about this feature:

You can compute the supply and demand measures by the project group, project, and task attributes in the project measure context.
You can also compute the measures by project group, project, and task or any user-defined planning attributes. This is based on the planning attributes dimensions deployed to the measure in the planning attributes measure context.
For an existing attribute-based plan with planning attributes measure context, refresh and rerun the plan after deploying planning attribute dimensions to measures to analyze the plan by user-defined planning attributes.
For an existing attribute-based plan with project measure context, refresh and rerun the plan to analyze the measures by project and task.
Supply Planning calculates and displays the supply and demand measures at the product, organization, time, and planning attribute levels.
You can drill from Supplies and Demands, Exceptions, or any supply planning user interface with planning attributes to a pivot table with the measure values by planning attributes.
You can drill to the Supplies and Demands view from measures such as Projected Available Balance with planning attributes. The Supplies and Demands view displays supply and demand details with planning attributes.
You can review and analyze details of measures at aggregate levels with planning attributes in a pivot table, graph, or tile. You can configure filters to review details for measures with planning attributes in a pivot table, graph, or tile.
A material plan or a pivot table, graph, or tile configured at a higher aggregation level, such as project group or project for a project dimension aggregate, displays the measure values at the higher aggregation level. The manner of aggregation follows the “Aggregate Then Calculate” or “Calculate Then Aggregate” setting for the measure.
The material plan, pivot table, graph, or tile configured for a subset of planning attribute dimensions of the plan scope aggregates and displays the measure values for the selected planning attributes only. The material plan, pivot table, graph, or tile displays values for measures both for common and planning attribute values.
For attribute-based plans where the netting rule configuration allows the allocation of supplies across planning attribute values, the attribute transfer supply and attribute transfer demand measure values are included in the Projected Available Balance and Projected On Hand measure values. The Attribute Transfer Demand and Attribute Transfer Supply measure values are displayed at planning attribute levels in a pivot table, graph, or tile.
For the existing plans enabled with planning attribute measure context, after the plan rerun, existing pivot tables such as Material Plan display measure values at the item organization for Projected Available Balance, Projected On Hand, Safety Stock, or Average Daily Demand by aggregating measure values at the planning attribute levels.
You can also load measures from other demand and supply plans with planning attributes or project measure context.

Use the following steps to analyze calculated supply and demand measures using configured attributes:

Create an unconstrained supply plan in Supply Planning or Demand and Supply Planning work area.
Assign the dimension catalog to a plan with planning attribute dimensions.
Assign the measure catalog with supply and demand measures.
Select the project or planning attribute measure context.
Select an attribute-based netting rule.
Run the plan and analyze the calculated supply and demand measures using configured attributes.

Note: Deploy planning attribute dimensions to measures using Change Granularity in the planning attributes measure context only for the set of measures to be analyzed by planning attribute dimensions. This step is not required for project measure context.

Examples

Example 1: This example explains how the Projected Available Balance measure value is computed and displayed at the aggregated level in a pivot table.

You configure the pivot table with the item, organization, project, and task level in a supply plan. The Projected Available Balance measure values are displayed at the project P1, task T1, project P1, task T2, and common level when you configure the pivot table at the project group, project, and task levels.
If you configure the pivot table with only item, organization, project group, and project levels, the Projected Available Balance measure values are aggregated at the project level.
If you configure the pivot table with only item and organization, the Projected Available Balance measure values are aggregated at the item and organization level.

Example 2: This example explains how the Projected Available Balance measure values are computed and displayed with the Attribute Transfer Supply and Attribute Transfer Demand values at the aggregated level in a pivot table.

An attribute-based netting rule is created with the first netting sequence step to net project supplies with project demands with the same project and task, and the second netting sequence step to net excess project supplies across tasks within the same project demands.
You configure the pivot table with the item, organization, project, and task levels. The Projected Available Balance is displayed in a pivot table considering the Attribute Transfer Demand from project P1 and task T2 and attribute transfer supply in project P1 and task T1. The excess On Hand supply of 10 units with project P1 and task T2 is allocated to project demand with project P1 and task T1.
If you configure the pivot table with only item, organization, and project, the Projected Available Balance measure values are aggregated at the project level.

Example 3: This example explains how the Projected Available Balance and Projected On Hand Measure values are displayed by project group, project, and task in a pivot table in an attribute-based plan.

The Projected On Hand, Projected Available Balance, and Projected Available Balance Value measure values are displayed by Project Group as VC_ENG, Project as VC Jet Engine, and Task as Cylinder Assembly in weekly and daily time buckets.

Example 4: This example explains how the Projected Available Balance and Projected On Hand Measure values are displayed by Region and Country of Origin in a pivot table in an attribute-based plan.

The Projected On Hand, Projected Available Balance, and Projected Available Balance Value measure values are displayed by Region as Africa and Country of Origin as South Africa in weekly and daily time buckets.

Example 5: This example explains how to drill from a pivot table with the Projected Available Balance measure by planning attributes to the Supplies and Demands view.

Select a measure value of 50 units for the measure Projected Available Balance in a pivot table for Region Oceania and Country of Origin Australia. Drill to Supplies and Demands View.
Drill to respects the context, and the Supplies and Demands View displays on hand for 50 units for the item with Region Oceania and Country of Origin as Australia.