cancel
Showing results for 
Search instead for 
Did you mean: 

exit variable with "E_TH_CHAS"

dongun_kang
Explorer
0 Kudos
316

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?

View Entire Topic
gregor_dieckmann
Product and Topic Expert
Product and Topic Expert
0 Kudos

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
Explorer
0 Kudos
right, In RSRT, the process is working, but in analysis office, it doesn't work.... some kind of setting issue?
dongun_kang
Explorer
0 Kudos
The error : Missing attribute value in new row/column (Currency Field)
gregor_dieckmann
Product and Topic Expert
Product and Topic Expert
0 Kudos

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