Customer Geography

The Customer Geography dimension is a merger of the main address of the customer defined in OCUSMA and all delivery addresses (ADRT = 1) that are in OCUSAD. The country name is retrieved from CSYTAB while area/state name is from CSYSTS.

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
Customer Geography M3A Sales

Address, Address Number, Address Name

Area/State, Area/State Code, Area/State Name, Area/State Description


Country, Country Code, Country Name, Country Description

Customer, Customer Number, Customer Name

Customer Address 1, Customer Address 2, Customer Address 3, Customer Address 4

Postal Code

Drill map

This table shows the drill map for Customer Geography:

Name Drill From Column Drill To Column
M3A Customer Geography Country Area/State
Area/State City
City Postal Code
Postal Code Customer
Customer Address