Workflow M3A initial setup

Note: The variables marked with an asterisk (*) in the tables are populated before the initial load is run. These variables may be modified in Admin or in the M3A Initial Setup workflow in orchestration.
Variable Description Used in space
M3A_CompanyFilter* This enables the extraction to load only specific companies from the Data Lake. Specify a single company number. Source
M3A_ExtractFromOverlapMin The number of minutes to be subtracted from the start time, moving the extraction start date earlier. The default value is 30. Source
M3A_ExtractInitialLoadDate*

The date and time of the start of initial extraction. On initial load, this is the start date used to retrieve data from the Data Lake. This is set to the date and time when an initial load of the tables is triggered in M3.

The solution uses the date and time in this format: M/D/YYYY hh:mm:ss.

 Source
M3A_ExtractToOverlapMin The number of minutes added to the end time, pushing the extraction end date into the future. The default value is 60. Source
M3A_ExtractWindowMin The length of the extraction window in minutes. If zero, then the difference between the extract start date or time and the current start date or time is used. The default value is 0. Source
M3A_UTCOffsetHours The number of hours between the Birst server time and UTC. Used to convert times to UTC so they match the Data Lake. The default value is 0. Source
M3A_BudgetVersionDataSet This variable is used to filter the dataset to be retrieved for the Budget Version. Source
M3A_SalesBudget_Customer

This variable is used to manipulate which among these dimension sub-elements are created:

  • CUNO - Sub-element for Customer
  • CUST - Sub-element for Statistics Customer
  • CUCL - Sub-element for Customer Group
 Source
M3A_SalesBudget_Facility

This variable is used to manipulate which among these dimension sub-elements are created:

  • FACI - Sub-element for Facility
  • DIVI - Sub-element for Division
 Source
M3A_SalesBudget_Item

This variable is used to manipulate which among these dimension sub-elements are created:

  • ITNO - Sub-element for Item
  • ITCL - Sub-element for Product Group
  • ITGR - Sub-element for Item Group
  • STYN - Sub-element for Style
 Source
M3A_SalesBudget_Logistics

This variable is used to manipulate which among these dimension sub-elements are created:

  • WHLO - Sub-element for Warehouse
  • SDES - Sub-element for Place of Loading
  • CSCD - Sub-element for Country
 Source
M3A_SalesBudget_SalesOrganization

This variable is used to manipulate which among these dimension sub-elements are created:

  • SMCD - Sub-element for Salesperson
  • SDEP - Sub-element for Sales Department
 Source
M3A_WhiteSpaceSource

The table name of the XtendM3 custom source for White Space data set.

 Source
M3A_WhiteSpace_StartDate

This determines the start date of the date range of the data loaded in the White Space fact.

The solution uses the date in this format: M/D/YYYY.

 Source
M3A_CLM_Language The language code to be filtered for CLM CODE table records that support multi-language. The default value is GB. Source
M3A_CustomTimeCompany* The M3 company number where the fiscal period information is based. Ensure that this variable is set to a valid company number in M3 before the initial load. The default value is 0. Dimension
M3A_Drillback_LogicalID

This contains the drill back logical ID.

 Consumer
M3A_Drillforward_LogicalID

This contains the drill forward logical ID.

The lid is required to be set up in this variable depending on the industry:

  • FSH = lid://infor.m3afsh-birst.m3afshbirst
  • MAN = lid://infor.m3aman-birst.m3amanbirst
  • FAB = lid:// infor.m3afab-birst.m3afabbirst
  • DIS = lid://infor.m3adis-birst.m3adisbirst
  • EQP = lid://infor.m3aeqp-birst.m3aeqpbirst
  • CHE = lid://infor.m3ache-birst.m3achebirst
 Consumer