An item can be both product and material, although not in the same product structure. As a product, the item is made up of other items (material). As a material, the item is included in other items (products).

The Item dimension contains all items defined in MITMAS, MITMAH and SITCOM. Names and descriptions of codes are retrieved from CSYTAB.

This dimension supports the use of Extensibility Dimension in the M3 Analytics model extension space. See the information about model extension in Infor M3 Analytics for M3 CloudSuites Administration Guide.

The attributes listed in the table are part of the custom subject area. M3 Analytics contains more attributes in the default subject area. For a complete list, see the mapping document in KB 2015457.

Hierarchy Custom subject area Attributes

M3A Equipment

M3A Finance

M3A Procurement

M3A Production

M3A Sales

M3A Warehouse

Attribute X, Attribute Y, Attribute Z

Basic Unit of Measure

Business Area, Business Area ID, Business Area Name, Business Area Description

Environment Group, Environment Group ID, Environment Group Name, Environment Group Description

Group Technology Class, Group Technology Class ID, Group Technology Class Name, Group Technology Class Description

Item, Item Number, Item Name, Item Description

Item Category, Item Category ID

Item Group, Item Group ID, Item Group Name, Item Group Description

Item Hierarchy 1, Item Hierarchy 1 ID, Item Hierarchy 2, Item Hierarchy 2 ID, Item Hierarchy 3, Item Hierarchy 3 ID, Item Hierarchy 4, Item Hierarchy 4 ID, Item Hierarchy 5, Item Hierarchy 5 ID

Item Type, Item Type ID, Item Type Name, Item Type Description


Mapped to M3

Product Group, Product Group ID, Product Group Name, Product Group Description

Procurement Group, Procurement Group ID, Procurement Group Name, Procurement Group Description

Quality Group

Responsible, Responsible ID, Responsible Name

Drill map

This table shows the drill map for Item:

Name Drill From Column Drill To Column
M3A Item – Attribute X Attribute X Item
Business Area, Business Area Description, Business Area ID, Business AreaM3A Item – Attribute Y Attribute Y Item
M3A Item – Attribute Z Attribute Z Item
M3A Item – Item Hierarchy Item Hierarchy 1 Item Hierarchy 2
Item Hierarchy 2 Item Hierarchy 3
Item Hierarchy 3 Item Hierarchy 4
Item Hierarchy 4 Item Hierarchy 5
Item Hierarchy 5 Item
M3A Item – Standard Item Type Business Area
Business Area Product Group
Product Group Item Group
Item Group Item