Guidelines to View and Edit Measure Data in Tables for Supply Plans That Use Telescoping Buckets

When you use telescoping buckets in your supply plan, there are some things to understand before you view plan output or edit measure data in tables.

If you use a table to view the plan output in a supply plan that includes the time dimension, the time hierarchy selected in this table must be the Supply Planning Calendar. Use this time hierarchy to ensure consistency between the level at which planning is performed and the level at which you view the plan output.

When you use telescoping buckets in a supply plan, you can't edit measure data in a table at a level lower than the supply planning bucket. For example, you can't edit data at the day level if your data in the table is at a weekly bucket. However, you can view and edit the measure data at or above the planning time bucket level.

Note: If you view data in a demand and supply plan, you can drill down to the daily level, even if you use telescoping time buckets. This is because demand planning allocates demand measures down to the day level.

Let's walk through how viewing and editing measure data in tables works in a bit more detail.

If you're viewing the portion of the plan horizon that's planned in:

Measure data that you can view or edit in tables

Daily Buckets

You can view or edit the measure values in either daily, weekly, period, or monthly levels in the table.

Weekly Buckets

  • You can view or edit the measure values in either weekly or period levels in the table.

  • You can't view the data at the daily granularity, even though the planning process allocates some measure data down to the day level.

  • You can't drill down from the week to the day level.

  • Any edit that you make at the period level is allocated to the last day of each of the underlying weeks within that period.

Period Buckets

  • You can only view or edit the measure at the period granularity.

  • You can't drill down from the period to the week or day level.

  • Any edit that you make at the period level is allocated to the last day of the period.

Monthly Buckets

  • You can only view or edit the measure at the monthly granularity.

  • You can't drill down from the month to the day level.

  • Any edit that you make at the monthly level is allocated to the last day of the month.

These four measures work differently when you edit them.

  • Gross Forecast

  • Net Forecast

  • Manual Demand

  • Planned Orders

You can view the portion of the plan horizon that's planned in weekly buckets. Any edit that you make at the week level is allocated to the last day of the week for these four measures. After you save your plan, the supply planning process updates or creates demands and supplies. These demands and supplies have a suggested due date that's the last working day of the supply planning bucket.