| Configuration and setup Import MasterConfiguration 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: - Open the Import Master tool, as an administrator.
- Select the PCL_10_4_1_ImportMaster.imd file from C:\Program
Files (x86)\Infor\BI\Program Cost Ledger 10.4.1\ImportMaster.
- 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.
- Specify the following
- The SQL Server name
- The user name and password
- Select the SQL Server database name created during the
installation of the BDS.
- Click Ok.
- 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.
- Specify the Authentication System in the Connect dialog box.
Specify the username and password for the Infor PM OLAP. Click Next.
- Select the PM OLAP server name. The server name is displayed as
<servername>/PCL_10_4_1_OlapDB. Apply the changes.
- 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.
- Set the runtime schedule for the Job on the Runtime
tab.
- Select the Error Handling tab and select the Ignore any Error
option from the Stop if list box.
- Specify the path where the log file must be saved in the LOG
file option.
- Select Append Timestamp to the filename in the list.
- Start the Import Master Service Manager. To schedule the job,
Go to Start > All Programs > Infor Business Intelligence >
ImportMaster\ImportMaster Service Manager.
- Click Open and select the PCL_10_4_1_mportMaster.imd file to
schedule the job.
- Select the PCL10.4 Jobs and select Enable. This job is used to
process the dimensions and cubes.
- Click Start.
| |