Analytics Software

Hi All,

we are using OBIEE 10g with Oracle R12 as our OLTP.

my question is that I have configured - Section 3.2.1.6.1, "How to Configure GL Account Hierarchies Using GL Accounting Flexfield Value Sets Definitions."
and I'm getting the correct hierarchy now.

few codes from my config files given below. we have used Actual Parent Account numbers in order to sort the TrialBal report in a particular format, Group Account Num in character format were not serving our purpose.
Now as you can see with this configuration obviously the standard reports (Balancesheet) are coming blank.
I would need to configure these group account codes for every BMM layer folder to include our group account numbers.
Also I need to have a specific format for balancesheet ..now seeing the below format please advice me where and how do i configure this drill down hierarchy?
because "Non Current Assets>>Fixed Assets" "Investments" are just group labels and not defined in the system anywhere. so how do I achieve this format in the report with drill down

Balance Sheet Format like below-

Sl No Particulars
A Non Current Assets
A.1 Fixed Assets
A.1.1 Fixed Assets
A.1.1.1 Asset Cost (total Balances frm natural GL Account 101010 to 101130)
A.1.1.2 Accumulated Depreciation (total Balances frm natural GL Account frm 105010 to 105160)
A.1.1.3 Asset Clearing (total Balances frm natural GL Account frm 104510 to 104630)
A.1.2 CWIP (total Balances frm natural GL Account frm 102010 to 102120)
A.1.3 Intangibles (similarly like above some account range)
A.1.3.1 Intangibles Cost (similarly like above some account range)
A.1.3.2 Accumulated Amortization (similarly like above some account range)
A.2 Investments
A.2.1 Investment in Shares
A.2.2 Investment in New Ventures
A.2.3 Investment in Properties
A.2.4 Properties under Construction
A.2.5 Advances for Investment Properties

B Current Assets
B.1 Inventories
B.1.1 Finished Goods
B.1.2 Packing Materials


etc.


file_group_acct_codes_ora.csv

CHART
OF
ACCOUNTS
ID FROM ACCT TO ACCT GROUP_ACCT_NUM
50328 101010 101999 101000
50328 102010 102999 102000
50328 103010 103999 103000
50328 104010 104210 104000
50328 104501 104999 104500
50328 105010 105160 105000
=========================================

file_group_acct_names.csv

GROUP_
ACCOUNT
NUM GROUP_ACCOUNT_NAME LANGUAGE
101000 Fixed Assets-Cost E
102000 Capital Work In Progress-Cost E
103000 Asset Cost-Intangibles E
104000 Fixed Assets-Cost Clearing E
104500 CWIP Cost Clearing E

==========================================

file_grpact_fstmt.csv

GROUP FIN_STMT
ACCT ITEM GL_ACCT_
NUM CODE CATCODE

101000 AP BS
102000 AP BS
103000 AP BS
104000 AP BS
104500 AP BS

===============================================

file_glacct_segment_config_ora.csv

CHART OF ACCOUNTS_ID SEG1 SEG1_VALUESETID SEG2 SEG2_VALUESETID SEG3 SEG3_VALUESETID SEG4 SEG4_VALUESETID SEG5 SEG5_VALUESETID SEG6 SEG6_VALUESETID SEG7 SEG7_VALUESETID
50328 SEGMENT1 1013524 SEGMENT2 1013525 SEGMENT3 1013526 SEGMENT4 1013527 SEGMENT5 1013524 SEGMENT6 1013528 SEGMENT7 1013529
AGGREGATION Y Y Y Y Y Y Y

==================================================