The Demand Planning application includes three planning levels by default in the Forecast and Demand Planning hierarchy builders:
Additional levels may be created as described below.
Create Additional Levels
The new demand planning supports additional levels that can be created to view, edit, and forecast demand. To so, you must create the levels first.
- Click "Create Level"
- Enter the level name in the pop-up
- Click Save
In this example, we have created two levels: Color and Size
Prep Hierarchy File
Once the levels are created, an upload file needs to be prepared (this may also be managed as part of the data integration process).
To prep the file, the first column will always be the base entity to which the levels will be added. You may have more than one base entity per column:
Column B will be the item, customer, or product code related to the hierarchy.
Column C and above will be the previously created hierarchy level for each base entity. You may have multiple levels (attributes) against each base entity.
In the example below we are going to build customer and item based hierarchies. Starting in column C and above, each unique hierarchy attribute will be added for each item or customer (and location if locations also have a hierarchy). In the example below we are adding the attributes of color and size by item.
Once the file is prepared, name the file "planninghierarchy" and save as a tab delimited text file.
Upload the file by following the steps in the support article Manually Uploading Data.