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.
This table shows the attributes that are part of the custom subject area:
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 City 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 |