About Configuring Customer Costs Lines and Product Costs Lines Tables
This configuration is required only if you are implementing Financial Profitability Analytics and you want to allocate your expenses by product or by customer dimensions. The default adapter does not capture the miscellaneous cost and expenses associated with generating revenue from a customer or from a product (for example, marketing campaign expenses). You must provide this miscellaneous data through the csv file.
The data files file_customer_cost_line_fs.csv
and file_product_cost_line_fs.csv
are used to enter data in the Customer Cost Lines table and the Product Cost Lines table before an ETL full load. Depending on the INTEGRATION_ID mentioned these files the ETL will do an Insert or update in the Customer Cost Line and Product Cost Line tables. If the INTEGRATION_ID mentioned in the files already exists in the fact table then the ETL will do an update for this transaction row in the fact table. You must populate these data files before an ETL load.
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>
.
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.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.
-
The
file_customer_cost_line_fs.csv
file loads the Customer Costs Lines data in the W_CUSTOMER_COST_LINE_F table. Columns are categorized into four types, as follows:-
Integration_ID — This is a unique identifier to the individual rows in the file.
-
FK_ID — This should be the integration IDs of the corresponding Dimension. For example, CUSTOMER_ID, which should be populated by the Integration ID of the customer dimension.
-
Amount Columns — for example, CUST_COST_AMT, Amount for the particular transaction line.
-
Attribute Columns — for example COST_LINE_DOC_ITEM, COST_LINE_DOC_SUB_ITEM, EXPENSED_ON_DT and so on. While inserting data for the _DT columns, we need to make sure that the data is entered in
YYYYMMDDHH24MISS
format.
-
-
The file_product_cost_line_fs.csv file loads the Product Costs Lines data in the W_PRODUCT_COST_LINE_F table. Columns are categorized into four types, as follows:
-
Integration_I — this is a unique identifier to the individual rows in the file.
-
FK_ID — this should be the integration ID of the corresponding Dimension. For example, PRODUCT_ID, which should be populated by the Integration ID of the Product dimension.
-
Amount Columns — for example, CUST_COST_AMT, Amount for the particular transaction line.
-
Attribute Columns — for example, COST_LINE_DOC_ITEM, COST_LINE_DOC_SUB_ITEM, EXPENSED_ON_DT and so on. While inserting data for the _DT columns, we need to make sure that the data is entered in
YYYYMMDDHH24MISS
format.
-