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

0FIGL - GL and Cost Center Overlay

We are using 0FIGL cube and looking for a way to handle custom row structures to group GL Account by specific Cost Center for display in financial statement.

For example, one grouping would be by "Revenue" accounts, next row "Other Assets", then finally Liabilities, the problem is under a specific grouping (i.e. Revenue), we need to create a row for revenue by specific cost center, then another line for all other cost center Revenue. The are over 30 different combinations of these grouping the clien needs. Ideally, we do not want to handle this through VBA in workbooks. This cannot be something new and I am looking for any solution that could handle this need. Please share your ideas.

Example:

>Revenue

-Revenue (GL = 400 & Cost Center = 1000) $100

-Revenue (GL = 400 & Cost Center <> 1000) $1200

>Other Assets

-Other Assets (GL = 500 & Cost Center = *) $5000

>Liabilities

-Liabilities (GL = 200 & Cost Center = 5000) $200

-Liabilities (GL = 200 & Cost Center <> 5000) $25000

Message was edited by:

MIghty Mike

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Apr 07, 2007 at 03:35 PM

    Create strutures, per your thinking.

    In those structures, why cant you use variables for cost center and GL accounts and also versions since you say you have sommany versions of financial statements.

    While the query is executed, variables can either be filled for cost centres and GL account or by means of an exit, one can be derived from another.

    Ravi Thothadri

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      With this approach, we would beed to create 30 custom row structures for each Financial Statement Version we need to accommodate. In addition, system does not allow changing from one strcture to another at query runtime (only allows selection of rows within a strcture), thus we end up with 30 plus queries that look identical with the exception of the customer row structures.

      We thought about creating a HUGE structure with parent/child nodes, however when you go to make selection of specific rows in such a large custom row structure, its extremely messsy for user to select from so many rows.

      Any other ideas?

  • author's profile photo Former Member
    Former Member
    Posted on Apr 06, 2007 at 11:43 PM

    One option we have come up with involves creating a custom row structure where we can restrict by GL Account and Cost center. This is a little messy and also there are many different financial statement versions which need to be maintained.

    Financial Statement Ver 001 <b>[Structure]</b>

    >Revenue <b>[Selection]</b>

    -Revenue (GL = 400 & Cost Center = 1000) <b>[Selection]</b>

    -Revenue (GL = 400 & Cost Center <> 1000) <b>[Selection]</b>

    >Other Assets <b>[Selection]</b>

    -Other Assets (GL = 500 & Cost Center = *) <b>[Selection]</b>

    >Liabilities <b>[Selection]</b>-Liabilities (GL = 200 & Cost Center = 5000) <b>[Selection]</b>

    -Liabilities (GL = 200 & Cost Center <> 5000) <b>[Selection]</b>

    Financial Statement Ver 002 <b>[Structure]</b>

    ........

    Financial Statement Ver 003 <b>[Structure]</b>

    ........

    Etc

    If we can create all the possible structures, is there a way to create a customer exit variable to allow variable selection of which structure is to be displayed at query runtime?

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Apr 07, 2007 at 03:40 PM

    Hi,

    According to your example going with Selections in the report is one of the best option as explained earlier.If you have more GL then better option you have is creating custom hierarchy on GL account characterstic.There you can group the GL according to your required way.

    With rgds,

    Anil Kumar Sharma .P

    Message was edited by:

    Anil Kumar Sharma

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi,

      We can not Use Cost center characterstic in the hierarchy on GL account.

      So the best option you have now is create Hierarchy as required on GL .Then use that hierarchy in the selections , and you also need Cost center characterstic in the selections.

      Or Create z-GL characterstic add the Cost center characterstic as Componding to it. And then add this new characterstic to the cube. then you can create the hierarchy on new Z-GL characterstic with Cost center as part of hierarchy. But here you need to reupload the complete data to cube after adding z-GL characterstic.

      With rgds,

      Anil Kumar Sharma .P

      Kindly assign the points to the helpful answers.

      Message was edited by:

      Anil Kumar Sharma

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.