Issue with Balance Sheet on New GL ETL - 0FIGL_V10????

[Former Member]

Hi BW Experts,

I have activated std content for Bal Sheet on New GL ETL...

Now using std Bal. Sheet & P&L report based on 0FIGL_V10...

I did activated 0GLACCEXT also and its text & hierarchy flow.

Loaded data for 0GL_Account and 0GLACCEXT.

Now when I execute report balances are matching for individual GL Accounts but some GL Accounts are not coming under correct node of hierarchy as loaded in BI, instead they are displayed in BEx ouput in end in node- "Not Assigned"....????

Please help to resolve this issue....

I have validated DSO, Cube & Virtual Provider data, and also hierarchy for 0GLACCEXT & GL Account.....

One more question: there are GL's in hierarchy whose amount can be reflected in two different nodes of hierarchy based on their polarity i.e. debit or credit.... Will BEx output will take care of this automatically or something is required to be done.

Thanks.

[arun_purohit · Accepted solution]

I have observed that-

all those GL Accounts which are related to two nodes based on their polarity (debit or credit) are going to Not Assigned nodes....

Any suggestions....

[arun_purohit · Accepted solution]

Hierarchy Issue resolved:

PLUMI --> 0BAL_DEPEND this mapping was missing in 0GLACCEXT hierarchy datasource....

This field takes care of GL accounts displayed under different nodes based on debit/credit.....

Thanks.

[former_member493004 · Accepted solution]

Hi Arun,

i am having the same problem, one of the GL account is appearing under "Not assigned" node due to which my balance sheet is not balancing, could you please let me know how you solve it.

i also mapped 0BAL_DEPEND with XBILK but still same issue.

please let me know as this is very urgent.

Thanks,

Ambika

[arun_purohit · Accepted solution]

Hi Ambika,

Please refer my previous post in this thread-

Hierarchy Issue resolved:

PLUMI  --> 0BAL_DEPEND this mapping was missing in 0GLACCEXT hierarchy datasource....

This field takes care of GL accounts displayed under different nodes based on debit/credit.....

Google & Download configuration guide for 0FIGL_V10, and look into it for all steps...

[former_member493004 · Accepted solution]

Thanks Arun,

I have already got it but your answer helped me

Regards,

Ambika