Oracle® Business Intelligence Applications Installation and Configuration Guide > Configuring Oracle Financial Analytics > Process of Configuring Oracle Financial Analytics for Oracle 11i >
Configuring the General Ledger Account Hierarchies
The are two ways to set up hierarchies in Oracle Financial Analytics:
Whichever method you choose to set up General Ledger Account hierarchies, you store the hierarchy information in the W_HIERARCHY_D table. To illustrate how hierarchy information is stored in the W_HIERARCHY_D table, see the following example using US Acct. Figure 27. Example hierarchy US Acct
Table 61 shows how the hierarchy US Acct would be stored in the W_HIERARCHY_D table as follows: Table 61. Example hierarchy US Acct stored in W_HIERARCHY_D
|
|
|
|
|
|
|
|
|
1 |
US Acct |
A |
B |
D |
H |
H |
H |
H |
2 |
US Acct |
A |
B |
D |
I |
I |
I |
I |
3 |
US Acct |
A |
B |
E |
E |
E |
E |
E |
4 |
US Acct |
A |
C |
F |
J |
J |
J |
J |
5 |
US Acct |
A |
C |
F |
K |
K |
K |
K |
6 |
US Acct |
A |
C |
G |
G |
G |
G |
G |
|