This website does not support Internet Explorer. Please, switch to Edge, Chrome, or Firefox browser to view this page.

Learn about IE support
o9 video

Watch next

July 17, 2023

How to Structure a Demand Plan

In this video, we discuss how to structure a demand plan. We look at the different dimensions, hierarchies, levels, attributes, and measures that can be used to structure a demand plan. We also discuss the importance of having a logical hierarchy and attributes that provide extra business insight.

The structure of a demand plan is important for a number of reasons. First, it allows planners to analyze and answer business questions more easily. Second, it helps to ensure that the data is accurate and consistent. Third, it makes it easier to collaborate with other stakeholders.

There are a number of different dimensions that can be used to structure a demand plan. Some common dimensions include item, sales domain, time, organization, channel, demand type, distribution network, and suppliers.

Hierarchies are used to define how dimension data is stored and displayed. Multiple hierarchies can exist in each dimension. This allows planners to view the data at different levels of granularity.

Levels are the groupings that make up the structure of each hierarchy. For example, the product category hierarchy might have the following levels: item, group, product category, and all products.

Attributes can be attached to level members to provide extra business insight. For example, a product might have the attributes of weight, color, and life cycle status.

Measures are the data streams that are stored in a demand plan. Typical demand planning measures include sales history, consensus forecast, and forecast accuracy.

The structure of a demand plan is an important part of the demand planning process. By carefully considering the different dimensions, hierarchies, levels, attributes, and measures, planners can create a demand plan that is accurate, consistent, and easy to use.

How do you structure a Demand Plan? Whether you are forecasting in a spreadsheet or a sophisticated system, you need to define the structure that is the rows and the columns of what you forecast. Planning is structured into dimensions such as Item, Sales Domain and Time. And dimensions are structured into hierarchies, levels and attributes. Data for these structures are held in data streams or measures. Let's look at dimensions first. Dimensions are structures that group and categorize data in order to enable planners to analyze, answer business questions and create forecasts.

Typical Demand Planning dimensions are: Item, Sales Domain and Time. But they can also include Organization, Channel, Demand Type, Distribution Network, Suppliers and so on. Now let us look at Demand Planning hierarchies. Hierarchies define how dimension data is stored and displayed.

Multiple hierarchies can exist in each dimension.

Some typical hierarchy examples are: Gregorian calendar, inside the Time Dimension Product Category, inside the Item Dimension and Customer Group, inside the sales domain dimension. Levels of the groupings that make up the structure of each hierarchy. Typical levels for the product category hierarchy

in the product dimension are: Item to Group to Product Category to All Products Typical levels for the customer category

hierarchy in the sales domain dimension are: shipped to Address to Zip Code then City, Country, Customer and finally up to all customers. And typical levels for the Gregorian calendar

hierarchy and the time dimension are: Day to Month to Quarter to Year. Whereas Manufacturing Calendar hierarchy will only contain Day to Week, to Year. Data in a Demand Plan should be visible and editable at the various levels of each hierarchy. Traditional Demand Planning solutions have very rigid, structured hierarchies.

They have built like this to conform to system and data constraints. However, next generation planning solutions can now build digital twins of businesses, creating more complex but realistic relationship diagrams, and these can be used to create more accurate and flexible demand plans. There is one important factor to be aware of with level data, which is that data within each level of a hierarchy must be logical. Data held at levels are called level members and each level member needs to have a unique parent, a one to one relationship, not a one to many.

In the example shown the product thing one is shown belonging to two categories within the same hierarchy, but it can only belong to one. This is because when values are changed, the adjustments need to be completed up and down the hierarchy, and this cannot be achieved if a level member exists in multiple places at the same time. Hierarchies need to be logical for aggregation and disaggregation functions to work properly. Now let us look at attributes.

Attributes can be attached to level members and are useful for providing extra business insight without hierarchical, logical restrictions. For example, a product and the item level of the product category hierarchy in the item dimension might have attributes of Weight, Color, Life Cycle Status and many other useful pieces of information. But unlike levels, attributes do not need to be unique for each member. Notice that the attribute of item color can be purple for both of these examples.

Finally, there are data streams which are often called measures. The information in your Demand Plan is structured by dimensions and hierarchies, but the data is stored and interacted with by planners in measures, and these measures can be past or future, internal or external and editable or not editable. So typical demand planning measures, sales history, consensus forecast and forecast accuracy. To summarize then, dimensions, hierarchies, levels, attributes and measures are used to structure a demand plan from the lowest to the highest levels of granularity and from the earliest to the latest points of time.

These structural elements define how demand planning solutions work.

Building a superior forecasting model with AI/ML

AI/ML-based forecasting models have become essential. Learn how to build the right planning solutions now.

I agree to the privacy policy.


View our related articles, white papers, use cases & videos


What Is “Granularity” in the Demand Planning Process?

7 min
What is “granularity” in the demand planning process? thumbnail

How To Define Your Demand Planning Horizon

4 min
How to define your demand planning horizon thumbnail

o9 Digital Brain — Driver based Machine Learning

3 min
Auto draft thumbnail

How to Build a World-Class Demand Planning Process

10 min
How to build a world class demand planning process thumbnail

Large Scale CPG Company and o9 — Summary of Machine Learning Forecasting

2 min
Auto draft thumbnail

If Forecasting Is Never 100% Accurate, What’s the Point?

3 min
If forecasting is never 100% accurate, what’s the point? thumbnail

AI/ML Forecasting - LATAM whitepaper

O9 whitepaper aiml mockup (1)

o9 Demand Planning - Exploratory Data Analysis

2 min
O9 demand planning exploratory data analysis

o9 Demand Planning - Risks and Opportunities 

2 min
Auto draft thumbnail

Retail Demand Planner Frustrations: How to Improve Forecast Accuracy and Collaboration

2 min
Auto draft thumbnail

The story of AB InBev’s end-to-end planning transformation

24 min
The story of ab inbev’s end to end planning transformation thumbnail

Webinar: AI-driven capabilities for manufacturing organizations

Capital goods industry
© – o9 Solutions, Inc.
Privacy Policy Cookie policy Support o9 Guide
tree nation
tree nation