Workflow to set extraction user variables

This workflow sets the extraction-related variables. The workflow contains the default values as specified by Infor. To change the variable values, you must clone the Infor-delivered workflow and make the changes in your cloned workflow. Changing Birst variables through the cloned workflow affects the extraction behavior.

Review the Infor-delivered variable values. To change the values, clone the Infor Workflow, change the values of the variables, and run the cloned workflow. If you change variable values again, rerun the workflow:

  1. Login as a user with the Birst-SystemAdministrator role.
  2. In Infor Ming.le, navigate to Birst in the App Menu.
  3. In Birst, click the Account Settings button.
  4. Select Orchestration to open the list of workflows.
  5. Select the LN Set Extraction User Variables workflow.
  6. Click Actions > Clone Workflow.
  7. Select the cloned workflow and click Edit Workflow.
  8. Click Edit for a task, specify Variable Value, and click Done
  9. Save the cloned workflow
  10. Click Run Workflow for the cloned workflow.

Note: The workflow sets only the relevant extraction variables that are prefixed with LN_usr. Administrators have rights to change these user variables in the spaces themselves, but we recommend that the workflow is used. Administrators must not change any variable that is not prefixed by LN_usr. To go back to the Infor default values, you can run the Infor supplied workflow again.

All the spaces of the LN Analytics have the Processing Time Zone of (UTC 00:00) Monrovia Reykjavik which matches with the UTC timezone. Because all the datetime values in the LN Analytics are in UTC, the Processing Time Zone of the spaces should not be changed. The time zones must be kept at (UTC 00:00) Monrovia Reijkjavik. Changing the Processing Time Zone breaks the incremental loading logic.

This table lists the LN user variables, their spaces, and their default values. Typically, the default values can be used.

# LN User variable Space Value
1 LN_usr_ExtractFullLoad LN-Extraction False
1 LN_usr_ExtractIncrementalLoadStartUTCDateTime LN-Extraction 01/01/2021 00:00 AM
2 LN_usr_ExtractUseManualUTCDateTimes LN-Extraction False
2 LN_usr_ExtractManualFromUTCDateTime LN-Extraction 01/01/2021 00:00 AM
2 LN_usr_ExtractManualToUTCDateTime LN-Extraction 01/01/2023 00:00 AM

1 - LN_usr_ExtractFullLoad + LN_usr_IncrementalLoadStartUTCDateTime

If LN_usr_ExtractFullLoad is set to True, the extraction uses the start date defined in LN_usr_IncrementalLoadStartUTCDateTime.

The LN_usr_IncrementalLoadStartUTCDateTime is also used the first time the extraction is run using the incremental loading logic.

2 - LN_usr_ExtractUseManualUTCDateTimes + LN_usr_ExtractManualFromUTCDateTime + LN_usr_ExtractManualToUTCDateTime

If LN_usr_ExtractUseManualUTCDateTimes is set to True, the incremental loading logic is ignored, and extraction uses the start date LN_usr_ExtractManualFromUTCDateTime and end date LN_usr_ExtractManualToUTCDateTime.

If LN_usr_ExtractUseManualUTCDateTimes is set to False again, the incremental loading is enabled again and starts from the latest Extract To UTC Datetime of the domain.