You must complete these configuration steps on Oracle Price Analytics to populate Source and Conformed Domain Code Members.
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.Configure the Source Domain Member Name values for those Codes seeded through the Price flat files.
The table captures the lineage from Presentation Column to Flat file column and relevant Source domain codes.
Presentation Table | Presentation Column | File Name | File Column | Source Domain Code |
---|---|---|---|---|
Price Waterfall Element |
Source Element Code |
|
ELEMENT_CODE |
PRC_ELEMENT_CODE |
Price Waterfall Element |
Source Element Type Code |
|
ELEMENT_TYPE_CODE |
PRC_ELEMENT_TYPE_CODE |
Price Waterfall Element |
Price Group Code |
|
GROUP_CODE |
PRC_GROUP_CODE |
Price Profile |
Profile Attribute 1 Code |
|
PROF_ATTR_1_CODE |
PRC_PROFILE_1 |
Price Profile |
Profile Attribute 2 Code |
|
PROF_ATTR_2_CODE |
PRC_PROFILE_2 |
Price Profile |
Profile Attribute 3 Code |
|
PROF_ATTR_3_CODE |
PRC_PROFILE_3 |
Price Profile |
Profile Attribute 4 Code |
|
PROF_ATTR_4_CODE |
PRC_PROFILE_4 |
Price Profile |
Profile Attribute 5 Code |
|
PROF_ATTR_5_CODE |
PRC_PROFILE_5 |
For example, the different Element Types used in the sample data in file – file_pwf_element_ds.csv
are:
Segment
The revenues that are part of a waterfall, such as ceiling revenue, list revenue, and so on.
Revenue Adjustment
The adjustments made to the segment elements, for example, ceiling adjustment, invoice adjustment, and so on.
Cost Adjustment
All other adjustments that are not part of any segment.
The corresponding Name values for above Element Types or any of the source domain members has to be supplied via file – file_domain_member_gs.csv in order for them to show up when querying Names in Analytics.
File_domain_member_gs.csv
The file is generic and therefore does not support any source Pricing system specific features.
Task SDE_DomainGeneral_PriceElementType will load the file data to Warehouse staging table W_DOMAIN_MEMBER_GS.
The granularity of this file is each domain member per language for any of the domains listed above.
Column Name | Data Type | Sample Data | Description |
---|---|---|---|
DOMAIN_CODE |
Not available. |
Not available. |
This should be populated with the Domain Code corresponding to the Source Domain to be configured. |
DOMAIN_TYPE_CODE |
Not available. |
Not available. |
Defaulted to 'S' - indicates this is a Source Domain Code. |
DOMAIN_MEMBER_CODE |
Not available. |
Not available. |
This should be populated with the CODE value supplied in any of the above files. |
DOMAIN_MEMBER_NAME |
Not available. |
Not available. |
This should be populated with the NAME value that corresponds to the Member Code supplied. |
DOMAIN_MEMBER_DESCR |
Not available. |
Not available. |
Not available. |
DOMAIN_MEMBER_REF_CODE |
Not available. |
Not available. |
Hardcode to '__NOT_APPLICABLE__'. |
DOMAIN_MEMBER_DEFN_TYPE_CODE |
Not available. |
Not available. |
Not available. |
LANGUAGE_CODE |
Not available. |
Not available. |
Warehouse Language Code. |
SRC_LANGUAGE_CODE |
Not available. |
Not available. |
Source Language Code. |
INTEGRATION_ID |
Not available. |
Not available. |
This is the unique ID for the record. The INTEGRATION_ID for this file can also be populated as DOMAIN_CODE~DOMAIN_MEMBER_CODE. |
DATASOURCE_NUM_ID |
Not available. |
Not available. |
The unique Data Source ID of the Siebel Instance you are configuring. |
The source file file_pwf_element_ds.csv
should already have the conformed domain mapped and should have values for the columns for the corresponding Source Domain Code Member.
As these conformed domains are extensible by the user, the Name values for these domain members of Conformed domains specified in the Table should be entered in Configuration Manager.
There are two conformed domains used in Oracle Price Analytics:
Presentation Table | Presentation Column | File Name | File Column | Source Domain Code |
---|---|---|---|---|
Price Waterfall Element |
Element Code |
|
W_ELEMENT_CODE |
Conformed Price Waterfall Element |
Price Waterfall Element |
Element Type |
|
W_ELEMENT_TYPE_CODE |
Conformed Price Waterfall Element Type |
Configure the Source Domain Member Name values for those Codes seeded through the Price flat files. The table below captures the lineage from Presentation Column to Flat file column and relevant Source domain codes.
Source Price Waterfall Element Member Code | Source Price Waterfall Element Name | Conformed Price Waterfall Element Member Code | Conformed Price Waterfall Element Name |
---|---|---|---|
Ceiling Revenue |
Ceiling Revenue |
Ceiling Revenue |
Ceiling Revenue |
Cost |
Cost |
Cost |
Cost |
Invoice Revenue |
Invoice Revenue |
Invoice Revenue |
Invoice Revenue |
Pocket Margin |
Pocket Margin |
Pocket Margin |
Pocket Margin |
Pocket Revenue |
Pocket Revenue |
Pocket Revenue |
Pocket Revenue |
Segment Revenue |
Segment Revenue |
Segment Revenue |
Segment Revenue |
This table captures the lineage from Presentation Column to Flat file column and relevant Source domain codes.
Source Price Waterfall Element Member Code | Source Price Waterfall Element Name | Conformed Price Waterfall Element Member Code | Conformed Price Waterfall Element Name |
---|---|---|---|
Cost Adjustment |
Cost Adjustment |
Cost Adjustment |
Cost Adjustment |
Revenue Adjustment |
Revenue Adjustment |
Revenue Adjustment |
Revenue Adjustment |
Segment |
Segment |
Segment |
Segment |
These can be included in the file – file_pwf_element_ds.csv
or new source/conformed domain members can be entered as mentioned in the previous sections.