Query formula variable: retrieve ID of strcuture

[gregor_kolck]

Hi experts,

I have the following requirement for a BEx query:

There is a formula element in STRUCTURE1. In this formula I need to dynamically retrieve the id of each element from STRUCTURE2.

If it was an infoobject I would do it with replacement path for infoobejct, but how to do this with a structure?

Best regards

Gregor

[former_member185132]

That is a rather unusual requirement, and I've never seen anything in BEx which could do that. Could you explain exactly what you are trying to do and why?

[gregor_kolck]

The reason for this requirement is:

STRUCTURE1 contains several keyfigures implemented as restricted keyfigures and formulas.

These are to be shown for all months of a year.

Some of the formulas are calculated on isolated month values.

Some of them have to be caculated based on cumulated month values.

I know of 3 possibilities to use cumulated values in query design

1) The local calculation "cumulated": This does not work for formulas based on cumulated values.

2) Cumulative display of Infoobject: This does not work as there are some keyfigures cumulated and some are not.

3) Variables of type current member: Works only with version 7.4 which is not present.

4) Would be a STRUCTURE2 to show months as formulas. These formulas then have to calculate cumulated in some cases and sometimes non-cumulated.

The idea was to do this with a formula variable that holds information about lines STRUCTURE1, e.g.

IF element = 1

month1 + month2 + ... monthx

ELSEIF element = 2

monthx

[former_member185132]

If I understand this correctly, you can achieve this by adding another formula KF for Structure 1. Put any dummy formula for this KF.

The key here is to have cell definitions for all cells of this column. The cell def for Jan will have a formula consisting of just "1", the cell def for Feb will have a formula containing just "2" and so on. Then you can use this column instead of "element" in your IF-Else logic.