Configuring analytics console parameters

Parameters must be set up by the user in the Analytics Console Configurations before they can run IPA workflows.

  1. Open Infor OS Portal’s navigation menu.
  2. In the Applications, select Financials & Supply Management.
  3. Go to Integration Architect > Analytics Console > Analytics Configurations.
  4. Click the ellipsis and select Set Analytics Console Parameter .
  5. Specify the parameters using this information:
    Property name Value Description
    Notifications Email Address For example, user1@infor.com, user2@infor.com Specify email addresses separated by a comma.

    Listed email addresses receive IPA workflow status notifications.

    ION Api Url For example, https://mingle-cqa-ionapi.cqa.inforcloudsuite.com/TENANTID/CustomerApi/Birst/api Specify the public facing proxy endpoint.
    1. Go to Infor ION API > Available APIs
    2. Select Birst.
    3. Select CustomerApi/Birst/api proxy endpoint.
    4. Click Details.
    5. Use the URL from the Public Facing Proxy Endpoint.
    ION Api SMD Url For example, https://mingle-cqa-ionapi.cqa.inforcloudsuite.com/TENANTID/CustomerApi/Birst/api_SMD Specify the public facing proxy endpoint:
    1. Go to Infor ION API > Available APIs
    2. Select Birst.
    3. Select CustomerApi/Birst/api_SMD proxy endpoint.
    4. Click Details.
    5. Use the URL from the Public Facing Proxy Endpoint.
    Tenant ID For example, TENANT01_AX1 Specify the Tenant ID.
    Connection Point For example, fsm_ims Specify the name of the connection point for FSM:
    1. Go to ION > Connect > Active Connection Points
    2. Use the name for Logical ID = infor.fsm.fsm:ims
    3. Specify the name for the Connection Point variable.
    Data Lake Flow Name For example, CSF_TO_DATALAKE If this data lake flow is not available, specify the data lake flow name that must be updated or created.
    1. To find the data lake flow name, select ION > Connect > Data Flows.
    2. Search for the data lake flow that uses the fsm connection point.
    3. Specify the Data Lake flow name for the Data Lake Flow Name variable.
    Run Delete All Processed Data Workflow False Select the check box to set to true.

    When set to true, the Delete All Processed Data workflow is run in Birst.

    Data Flow Skip Replication False Select the check box to set to true.

    When set to true, the IPA flow does not trigger the replication process. Birst workflows are automatically run.

    Enable Notifications True Select the check box to set to true.

    When set to true, the IPA flow sends email notification for each step of the IPA flow. Otherwise, notifications are only sent on start, on error, user actions, and completion of the IPA flow.

    Extract Start Date 2024-10-01 This parameter specifies the date when the replication sets are reset or when the Data Flow to Analytics Full Load is executed. This date is utilized in the Reset Variables workflow in Birst.

    Specify the date of your last reset of replication sets in the YYYY-MM-DD format.

    Note: If the last reset date is known, resetting the replications sets is not required. Only updated business classes must be reset:
    1. Go to the Administration Console.
    2. Select Database > Replication.
    3. Right-click the replication name, then select Options > View Audit Log.

    Note the most recent date for a Reset action and use that date for the value of the Extract Start Date.

    Proceed to reset only the updated business classes.

    See the Financials and Supply Management Analytics Content Update Guide Instructions.

    In this scenario, run the Data Flow to Analytics Full Load with the Data Flow Skip replication parameter set to true.

    Max Rep Set Time Out Minutes Full Load 300

    This parameter indicates how long the IPA flow should wait for the replication process to finish before considering it timed out. We recommend checking the duration of your last full replication process. Use that value as reference when determining the appropriate timeout duration.

    When the replication takes longer than the set limit, the user receives a notification which indicates that the replication process did not finish within this time threshold.

    Max Rep Set Time Out Minutes Incremental Load 150

    This parameter indicates how long the IPA flow should wait for the replication process to finish before considering it timed out. We recommend checking the duration of your last incremental replication process. Use that value as reference when determining the appropriate timeout duration

    When the replication takes longer than the set limit, the user receives a notification which indicates that the replication process did not finish within this time threshold.

    Replication Sets List FSM_AD_ST,FSM_AM_ST,FSM_AP_ST,FSM_AR_ST,FSM_BL_ST,FSM_CB_ST,FSM_CM_ST,FSM_CURRENCY_ST,FSM_FR_ST,FSM_FRAMEWORK,FSM_GL_ST,FSM_HCMFN_ST,FSM_II_ST,FSM_IC_ST,FSM_LM_ST,FSM_MA_ST,FSM_OE_ST,FSM_PO_ST,FSM_RQ_ST,FSM_SEC_ST,FSM_TX_ST,FSM_WH_ST,FSM_WO_ST Specify the list of replication sets that are processed in the IPA flow.

    The list must be separated by commas with no spaces in between.

    Data Flow Wait Time Minutes 10

    Specify the duration in minutes that the IPA flow will use to wait before starting to run the Birst workflows after replication has completed. Minimum default value is 5 minutes.

    With Register All Schemas True Select the check box to set to true.

    When set to true, the IPA flow runs the Register All Schemas.

    Workflow Name Delete All Processed Data CSF - Delete All Processed Data Specify the CSF Delete All Processed Data Birst workflow name.
    Workflow Name Extract and Process CSF - Extract and Process Specify the CSF Extract and Process Birst workflow name.
    Workflow Name Reset Variables CSF - Reset Extract Variables Specify the CSF Reset Extract Variables Birst workflow name.
    Workflow Name Security CSF - Security Specify the CSF Security workflow name.
    Workflow Name MSCM CSF - MSCM Extract and Process Specify the CSF MSCM Extract and Process Birst workflow name.
    Enable MSCM True Select the check box to set to true.

    When set to true, the Data Flow to Analytics Workflow will run the CSF-MSCM Extract and Process Birst workflow. Set this parameter to true only when you have MSCM data to process.

    Stand Up Staging True Select the check box to set to true.

    When set to true, the Data Flow to Analytics Workflow will run the STC Birst workflows. Otherwise, the ATC Birst workflows are run. This should be set to true only when performing data load to STC spaces or to the staging environment.

    Birst Api User Name For example, TENANT01_d4fd82ba-959c-4dc7-9151-133ac22e18ba Specify your Birst user GUID.
    1. Select Birst > User Management.
    2. Search for your name.
    3. Select your user to display the details.
    4. Copy the GUID for your user.
    Birst Api User Password Specify password for your Birst user GUID Specify the password of your Birst user GUID.
    1. Open the Birst URL based on your region. See Creating OAuth credentials for an SMD User for the list of Birst URL.
    2. Specify your Birst User GUID and reset your password.
    Birst Api URL For example, https://app2103.bws.birst.com/commandwebservice.asmx Specify the Birst Api URL based on your region:
    • APAC1 - https://app2103.apac1.birst.com/commandwebservice.asmx
    • APAC2 - https://app2103.apac2.birst.com/commandwebservice.asmx
    • CN - https://login.cn1.birst.com/commandwebservice.asmx
    • EU - https://app2103.eu1.birst.com/commandwebservice.asmx
    • KOCH - https://koch.bws.birst.com/commandwebservice.asmx
    • US - https://app2103.bws.birst.com/commandwebservice.asmx
    • US Pre-prod -https://app2102.bws.birst.com/commandwebservice.asmx
    • US-E1 - https://default.birstapp.prd3.inforcloudsuite.com/commandwebservice.asmx
    • US-E1 Pre-prod -https://beta.birstapp.prd3.inforcloudsuite.com/commandwebservice.asmx
    Target Space Type STC or ATC If running the Analytics Upgrade Tenant To Tenant workflow, specify the space type in the target tenant to where the updates are copied.
    Source Space Type STC or ATC If running the Analytics Upgrade Tenant to Tenant workflow, specify the space type in the source tenant from where the updates are copied.
    Target Tenant ID For example, TENANT02_AX1 If running the Analytics Upgrade Tenant To Tenant workflow, specify the tenant ID of the target tenant.
    Target Tenant Birst User ID For example, TENANT02_AX1_d4fd82ba-959c-4dc7-9151-133ac22e18ba If running the Analytics Upgrade Tenant To Tenant workflow, specify the Birst user ID that was used to generate the oauthkey in Birst in the target tenant.
    ION Api Url Target For example, https://mingle-cqa-ionapi.cqa.inforcloudsuite.com/TENANT01_AX1/CustomerApi/Birst/api_TENANT02 If running the Analytics Upgrade Tenant To Tenant workflow, specify the endpoint URL used to call Birst API in the target tenant.

    See Proxy endpoint for the target tenant.

    Update ION Schemas Service Def UpdateIONSchemas [Default] Specify the service definition for Update ION Schemas workflow.
    Data Flow To Analytics Incremental Load Service Def DataFlowToAnalyticsIncrementalLoad [Default] Specify the service definition for Data Flow to Analytics Incremental Load workflow.
    Data Flow To Analytics Full Load Service Def DataFlowToAnalyticsFullLoad [Default] Specify the service definition for Data Flow to Analytics Full Load workflow.
    Analytics Upgrade SMD To ATC Service Def AnalyticsUpgradeSMDtoATC

    [Default] Specify the service definition for Analytics Upgrade SMD To ATC workflow.

    Analytics Upgrade Swap STC And ATC Service Def AnalyticsUpgradeSwapSTCATC [Default] Specify the service definition for Analytics Upgrade Swap STC And ATC workflow.
    Analytics Upgrade SMD to STC Service Def AnalyticsUpgradeSMDtoSTC

    [Default] Specify the service definition for Analytics Upgrade SMD To STC workflow.

    Analytics Upgrade Copy Consumer Customization Service Def AnalyticsUpgradeCopyConsumerCustomization

    [Default] Specify the service definition for Analytics Upgrade Copy Consumer Customization workflow.

    Analytics Upgrade Tenant To Tenant Service Def AnalyticsUpgradeTenantToTenant

    [Default] Specify the service definition for Analytics Upgrade Tenant To Tenant workflow.

    Replication Queue Data Replication Queue [Default] Specify the Data Replication Queue name.
    1. Select Async Administrator > Home.
    2. In the All Queues tab, search for Replication Queue in the Description column.
    3. Use the value from the Name column.
    ION Out Queue Logical Id lid://infor.fsm.fsm:ims [Default] Specify the ION Out Queue Logical Id.
    1. Select Async Administrator > ION Components.
    2. In the Active Logical Ids tab, Use the value for the Logical Id where the connection is IMS and data area is <tenantId>_FSM.
  6. Click Submit.