The Store dimension is taken from the Warehouse hierarchy. Store details are retrieved from Shop.Open (OPS500) stored in the M3 BE table OSTORE for warehouses.

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 Finance

M3A Procurement

M3A Production

M3A Sales

M3A Warehouse

Alt Store ID

Store, Store ID, Store Name, Store Information

Store Category, Store Category ID, Store Category Name, Store Category Description

Store Class, Store Class ID, Store Class Name, Store Class Description

Store Rank

Store Surface

Store Volume Class, Store Volume Class ID, Store Volume Class Name, Store Volume Class Description