Scorecard Target Files
Prepare the scorecard target files before running ETL.
Optional or Mandatory
This task is only required if you choose to implement procurement scorecard feature.
Task description in detail
Use the file file_purch_target_fs.csv
to specify the target for the KPI. The supported dimensions are time dimension and procurement Business Unit dimension.
The configuration file or files for this task are provided on installation of Oracle BI Applications at one of the following locations:
-
Source-independent files:
<Oracle Home for BI>\biapps\etl\data_files\src_files\
. -
Source-specific files:
<Oracle Home for BI>\biapps\etl\data_files\src_files\<source adaptor>
.
Your system administrator will have copied these files to another location and configured ODI connections to read from this location. Work with your system administrator to obtain the files. When configuration is complete, your system administrator will need to copy the configured files to the location from which ODI reads these files.
Note:
If you are deploying OTBI-Enterprise, then you must download the CSV files from Configuration Manager, as follows: 1. From the Tasks bar, click Define Business Intelligence Applications. 2. Click Actions, then Manage Source Configuration Data Files. 3. Click the Export Source Configuration Data Files option on the tool bar. 4. Move the required files to the right hand list, then click Export.You must specify the following values in the source file in the required data format:
-
Quarter start date
-
Procurement business Unit ID
-
KPI name
-
KPI target value
The following KPIs are supported for KPI target value:
# of Negotiation Lines Awarded Per Category # of POs Per Buyer # of Suppliers Per Category % of Fulfilled Requisition Lines Past Expected Date % of Late Receipts % of Processed Requisition Lines Past Expected Date % of Realized Savings % of Supplier Diversity Spend % of Unfulfilled Requisition Lines Past Expected Date Average Negotiation Cycle Time Average Requisition to Receipt Cycle Time Electronic Invoice % Manual Requisition Lines Rate Non-Agreement Purchase Rate Overall Accepted % Perfect Invoices % Purchase Order Schedule Line Return Rate Received On Time %