2024 Oct 08 6:32 AM - edited 2024 Oct 08 6:41 AM
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?
Request clarification before answering.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
81 | |
30 | |
10 | |
8 | |
7 | |
7 | |
6 | |
6 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.