Inventory Optimization Segmentation Workbook

Use the Inventory Optimization Segmentation Workbook to review stored segmentation results in one table. The workbook shows assigned segments, selected calculation values, and details about each run.

Workbook Configuration

The workbook uses the Inventory Optimization Segmentation Dataset. To customize the standard workbook, use Save As to create a copy.

For information about finding and opening shared templates, see Accessing and Sharing Workbooks and Datasets.

Consider the following information before you use or customize the workbook:

  • Enable Inventory Optimization before using the workbook. For instructions, see Enabling Inventory Optimization.

  • Your role needs the SuiteAnalytics Workbook permission at the Edit level and the Inventory Optimization permission at the View level or higher.

  • The standard dataset and workbook must be shared with your role.

  • Item, location, subsidiary, class, and department restrictions determine which rows you can view.

  • If expected rows aren't visible, verify sharing, permissions, and restrictions. Then confirm that Calculate Inventory Segmentation processed the expected items.

  • The standard workbook initially filters Latest / Current Run to True.

  • For item-level segmentation, Location and Item Location are blank.

  • For item-location segmentation, those fields identify the applicable location context.

  • The standard workbook has no default conditional formatting.

  • SuiteAnalytics doesn't recalculate the stored values.

The following table lists the standard workbook configuration.

Root Record Type

Joined Record Type

Custom Formula Fields

Data Grid

Criteria Filters

Inventory Optimization Segmentation Results

None

None

The default workbook table includes these columns:

  • Segmentation Run

  • Item

  • Location

  • Item Location

  • Inventory Optimization ABC Segment

  • Inventory Optimization 123 Segment

  • Inventory Optimization Segment

  • Annual Consumption Value

  • Percent Total ACV

  • Cumulative ACV Percentage

  • Cumulative SKU Percentage

  • Mean Monthly Demand

  • Stddev Monthly Demand

  • Coefficient of Variation

  • Last Segmentation Date

  • Latest / Current Run

Latest / Current Run is True, showing the latest completed segmentation run. Pending, Processing, and Failed runs are excluded.

Internal ID, Annual Usage, and Unit Cost are available in the source dataset but not the default table.

Related Topics

General Notices