Skip to Content
author's profile photo Former Member
Former Member

Balance calculation in BW transformation

hi Experts,

I have a requirement to get the Accumulated Balance in the flow of 0FI_GL_4 extractor.

Because of many missing dimensions , I cannot use the extractor 0FI_GL_1 / 0FI_GL_6 which provides the Accumulated Balances.

I have the DSO 0FIGL_O02 & a transformation to aggregate the data to a cube.

In the transformation I calculate 0Balance. The code is working fine for GL Accounts (P&L) however the balance does not get calculated correctly for Balance Sheet Accounts since they need to have the Balance carried forward each year.

Can you please share the code if you have calculated Balance carried forward in a transformation routine ?

Please suggest if there is any other way to achieve this requirement as well.

Thanks,

Neha

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Posted on Jul 22, 2016 at 10:47 PM

    Hi,

    Have you tried using a multicube on both the infocubes mentions below so as to get the missing dimensions at the level of multicube.

    Infocube 0FIAP_C03 --> ODS 0FIGL_O02 which runs the extractor 0FI_GL_4

    Infocube 0FIGL_C01 --> which runs the extractor 0FI_GL_1

    Regards,

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.