CO Addtl Info

The CO Addtl Info dimension is a derived dimension that contains details on the customer order at line level. This is retrieved from the OOLINE table in M3 and has additional derived statuses and other pertinent order line information. Several bucketed measures have also been defined and added to the hierarchy that determine whether a delivery is made early, on time, or late, based on the requested and actual delivery dates. Bucketed measures are available in days, hours, and minutes, depending on reporting requirements.

The ranges defined in these bucketed measures may be modified in the Sales fact space to cater to different business and reporting needs. See the Birst Online Help for more information on bucketed measures.

See Source and data models in Infor M3 Analytics for M3 CloudSuites Administration Guide for guidelines in modifying Infor-delivered content. Changes to bucketed measures will be overwritten and should be reapplied when the solution is updated.

By default, these ranges are defined in the solution:

Date Accuracy – Req vs Actl in Days - using the measure Days Diff – Req and Actl

Early - deliveries that are made earlier than the requested delivery date
On Time - deliveries that are made on the requested delivery date
Late - deliveries that are made after the requested delivery date

Date Accuracy – Req vs Actl in Hrs - using the measure Hrs Diff – Req and Actl

Early - deliveries that are made more than three hours earlier than the requested delivery date/time
On Time - deliveries that are made within three hours before or after the requested delivery date/time
Late - deliveries that are made three hours or more after the requested delivery date/time

Date Accuracy – Req vs Actl in Min - using the measure Min Diff – Req and Actl

Early - deliveries that are made earlier than the requested delivery date/time
On Time - deliveries that are made on the requested delivery date/time
Late - deliveries that are made after the requested delivery date/time

Date Accuracy – Orig Req vs Actl in Days - using the measure Days Diff – Orig Req and Actl

Early - deliveries that are made earlier than the original requested delivery date
On Time - deliveries that are made on the original requested delivery date
Late - deliveries that are made after the original requested delivery date

Note: The original requested delivery date is based on the requested delivery date as of printing the order confirmation document.

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
CO Addtl Info	M3A Sales	Date Accuracy – Delivery Window Date Accuracy – Req vs Actl in Days, Date Accuracy – Req vs Actl in Hrs, Date Accuracy – Req vs Actl in Min Date Accuracy – Orig Req vs Actl in Days Delivery Method – CO, Delivery Method Description – CO, Delivery Method ID – CO, Delivery Method Name – CO Delivery Terms – CO, Delivery Terms Description – CO, Delivery Terms ID – CO, Delivery Terms Name – CO Delivery Window – CO Has Valid Delivery Window Has Valid Order Cycle Time Has Valid Orig Conf Date Joint Delivery Line Type – CO, Line Type Code – CO Overdue Reference Order Category – CO, Reference Order Category ID – CO Reference Order Line – CO, Reference Order Line Suffix – CO Reference Order Number – CO Status Sort Stocked Stopped Stopped/Stocked Status Transaction Reason – CO, Transaction Reason Code – CO, Transaction Reason Description – CO, Transaction Reason Name – CO