exit variable with "E_TH_CHAS"

[dongun_kang]

Hi experts,

i want to implement exit variable with "E_TH_CHAS".

The requirement is as follows :

- field B should be field with field A. (A: Company Code, B: Book Currency)

- field B should be "Do not diplay" ( B belong to Keyfigure, so cannot be removed from aggregation level)

- New line input must be possible. (also, New line Help)

For the above reasons, the deviation function is not applied.

Therefore, my idea is to implement exit variable with field B using <E_TH_CHAS> Table.

When user fill the Field A in Bex query new line, then using the value corresponding to Field A, which passed to <E_TH_CHAS> Table, Export the value with Field B with relation logic.

So, field B is filtered with the exit variable 

Is it possible?

[gregor_dieckmann · Accepted solution]

Hi,

I am not sure whether fully understand you question.

It seems that you have characteristics A (Company Code) and B (Book Currency) and you have a key figure K that uses B as the currency characteristic. This is why an aggregationlevel containing K also has to contain B.

It is possible to derive the currency value (it is a required field) from A, e.g. modeling B as an attribute of A. Set up a characteristic relationship of type 'derivation' use A a source and B as target. In the query you can drill-down by A, B and hide B in the query. In a new line, using Analysis Office, then the system derives the currency from the Company Code A, i.e. the required field for currency is automatically filled.

In other words, this problem can be solved using standard modeling. You don't need a variable. This would anyway not work since variables are replaced before the query is started, i.e. in new line scenarios this is too late.

Regards,

Gregor

[dongun_kang · Accepted solution]

right, In RSRT, the process is working, but in analysis office, it doesn't work.... some kind of setting issue?

[dongun_kang · Accepted solution]

The error : Missing attribute value in new row/column (Currency Field)

[gregor_dieckmann · Accepted solution]

I used NewLineCheckMode: None, cf. Technical Settings and/or Crosstab settings in the Design Panel; you should also check note 2844345.