0FIGL - GL and Cost Center Overlay

[Former Member]

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

[Former Member · Accepted solution]

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

[Former Member · Accepted solution]

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?

[Former Member]

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

[Former Member]

The main issue we are having is finding a way to group cost center and gl together for a specific line.

We created a hierarchy on GL, however did not see a way to group by GL and Cost Center within a hierarchy at individual row level. We did come across some documentation where you can add a <a href="http://help.sap.com/saphelp_nw2004s/helpdata/en/80/1a6736e07211d2acb80000e829fbfe/frameset.htm">Characteristic Node</a> to hierarchy but documentation is not clear on how this works and did not appear to solve our issue.

[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

[Former Member]

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?