How To Configure a Mapping Rule To Subtract Items In Percent (%) Distribution Rule And Use Matched Dimensions
Last updated on NOVEMBER 12, 2008
Applies to:
Oracle Profitability Manager - Version: 11.5.10Oracle Enterprise Performance Foundation - Version: 11.5.10 to 12.0.4
Information in this document applies to any platform.
Goal
How to setup a percent distribution mapping rule to have a single column be both the matched and percent distribution dimension with subtraction.For example, you have the following source and driver records:
Source Records
Financial Element | Line Item | Company Org | Department | Balance |
---|---|---|---|---|
457 | 966020 | JAPAN | A1 | 100 |
457 | 966021 | JAPAN | A2 | 200 |
457 | 966022 | JAPAN | A3 | 300 |
457 | 966020 | THAILAND | A1 | 400 |
457 | 966021 | THAILAND | A2 | 500 |
457 | 966022 | INDIA | A1 | 600 |
Driver Records
Financial Element | Line Item | Company Org | Department | Balance |
---|---|---|---|---|
30000 | 457573 | JAPAN | B1 | 450 |
30000 | 457573 | THAILAND | B2 | 845 |
30000 | 457573 | INDIA | B3 | 596 |
You would like the following output records where the source balance records are summed by Company Org and then subtracted by the summed Company Org Driver records:
Output Records
Financial Elem | Line Item | Company Org | Department | Balance |
---|---|---|---|---|
30000 | 457573 | JAPAN | SEAQ | 150 |
30000 | 457573 | THAILAND | SEAQ | 55 |
30000 | 457573 | INDIA | SEAQ | 4 |
Solution
Sign In with your My Oracle Support account |
|
Don't have a My Oracle Support account? Click to get started |
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms