Asset Category Dimension Configuration Example
Assume the Asset Category dimension in the analytics warehouse stores the following values:
| Warehouse Column | Business Meaning |
|---|---|
|
W_ASSET_CATEGORY_D.MAJOR_CATEGORY |
Major Category (for example, COMPUTER) |
|
W_ASSET_CATEGORY_D.MINOR_CATEGORY |
Minor Category (for example, LAPTOP or DESKTOP) |
|
W_ASSET_CATEGORY_D.SEGMENT1 |
Major Category |
|
W_ASSET_CATEGORY_D.SEGMENT2 |
Minor Category |
In your Oracle E-Business Suite implementation, the Asset Category KFF is configured as follows:
| EBS KFF Segment | Business Meaning |
|---|---|
|
FA_CATEGORIES_B.SEGMENT1 |
Not used |
|
FA_CATEGORIES_B.SEGMENT2 |
Major Category |
|
FA_CATEGORIES_B.SEGMENT3 |
Minor Category |
Configure the FILE_FA_CATEGORY_SEGMENT_CONFIG_ORA inline dataset as shown below:
| MAJOR_CATEGORY | MINOR_CATEGORY | SEG1 | SEG2 | SEG3 | SEG4 | SEG5 | Etc |
|---|---|---|---|---|---|---|---|
|
SEGMENT2 |
SEGMENT3 |
SEGMENT2 |
SEGMENT3 |
NA | NA | NA | NA |