Store

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
Store

M3A Finance

M3A Procurement

M3A Production

M3A Sales

M3A Warehouse

Alt Store ID

Store, Store ID, Store Information, Store Name, Store Rank, Store Surface

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

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

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