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:
- Login as a user with the Birst-SystemAdministrator role.
- In Infor Ming.le, navigate to Birst in the .
- In Birst, click the button.
- Select to open the list of workflows.
- Select the LN Set Extraction User Variables workflow.
- Click .
- Select the cloned workflow and click .
- Click Variable Value, and click for a task, specify
- Save the cloned workflow
- Click for the cloned workflow.
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.