Configuration and setup Import Master

Configuration and setup Import Master

Import Master is used for the ETL (extract, transform, and load) process to build the dimensions and cubes for the Program Cost Ledger. In step procedure, you must specify the connection information for the relational source connections and the OLAP server database. You must also configure the job that populates the cubes. The procedure:

  1. Open the Import Master tool, as an administrator.
  2. Select the PCL_10_4_1_ImportMaster.imd file from C:\Program Files (x86)\Infor\BI\Program Cost Ledger 10.4.1\ImportMaster.
  3. In the left pane, specify the connection properties for the three data sources (Infor10BIHelperSchema, RS_SOURCE, andRS_DESTINATION) . Right-click and select 'Properties, for each data source. On the Database connection Tab, click Connect. Note: The BV_BDS is the database name generated during the installation of the BDS.
  4. Specify the following
    • The SQL Server name
    • The user name and password
  5. Select the SQL Server database name created during the installation of the BDS.
  6. Click Ok.
  7. Specify the connection properties of the OLAP server database. In the right pane, right-click INFOR_BI_PROJECTANALYTICS: xxx and select Properties. On the Database Connection tab, click Connect.
  8. Specify the Authentication System in the Connect dialog box. Specify the username and password for the Infor PM OLAP. Click Next.
  9. Select the PM OLAP server name. The server name is displayed as <servername>/PCL_10_4_1_OlapDB. Apply the changes.
  10. Configure the full load job. Expand the Jobs folder and select PCL Full Load from the Multidimensional Databases. Right-click the job and select Properties.
  11. Set the runtime schedule for the Job on the Runtime tab.
  12. Select the Error Handling tab and select the Ignore any Error option from the Stop if list box.
  13. Specify the path where the log file must be saved in the LOG file option.
  14. Select Append Timestamp to the filename in the list.
  15. Start the Import Master Service Manager. To schedule the job, Go to Start > All Programs > Infor Business Intelligence > ImportMaster\ImportMaster Service Manager.
  16. Click Open and select the PCL_10_4_1_mportMaster.imd file to schedule the job.
  17. Select the PCL10.4 Jobs and select Enable. This job is used to process the dimensions and cubes.
  18. Click Start.
Configuring help files

You must copy the ‘ipcl’ folder which contains the help files from 'OnlineHelp' (C:\Program Files (x86)\Infor\BI\Program Cost Ledger 10.4.1\Documentation\) to the 'help' folder (‘\Infor\BI\\Application Studio\WebServices\Help\en\), where the Application Studio is installed.