on 08-13-2014 4:01 PM
Dear experts,
my customer wants to achieve the following behavior within their BW query reporting:
He will select two sets of one or more hierarchy notes of financial positions (chosen from two different hierarchies of choice) when starting the Query.
The query will display the sum for both selection options, as well as the variance (so only three figures are shown)
As he is printing out the result, he wants to display in the reporting result the positions chosen, without drilling down by position.
I will appreaciate a lot any help and support in understand how to display the IDs of Financial Positions chosen.
Thank you,
Thomas
Hi Sureshkumar,
let me better explain the issue.
I have two hierarchies of Financial Positions, lets say P&L and P&L notes.
The query I set up will have two input variables to chose the hierarchy of Financial Positions, as well as two input variables to chose one ore more hierarchy nodes of the chosen hierarchies.
Both sets of chosen Financial Position hierarchy nodes should be summed and compared in the query result.
So lets say, the customer chose for the first set Financial Position hierarchy node A100 of P&L, and for the second set nodes N100-1, N100-2 and N200 of P&L notes.
The result will - as an example - look like this:
First selection 2nd selection Variance
1000 900 100
Now my issue is, that for the printout of this query result, I did not yet find a way to list the Financial Positions selected. In case I use a text variable reading Financial Position key, the result would be the following:
A100 N100-1 Variance
1000 900 100
As it turned out, it will only show the first value of Financial Position in the 2nd selection and the customer will have no hint, what was really selected.
Do you know a way to list all the selected Financial Positions?
Thanks a lot for your help,
Thomas
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
you can achieve this through the variable customer exit enhancement.
CMOD code-
when 'ZGL_LIST_TXT'.
IF i_step = 2.
data txt(100) TYPE c.
data temp_txt(8) TYPE c.
clear txt.
LOOP AT i_t_var_range INTO intern_range WHERE vnam = 'ZGL_VALUES'.
temp_txt = intern_range-low.
if txt = ''.
CONCATENATE txt temp_txt INTO txt.
else.
CONCATENATE txt ',' temp_txt INTO txt.
endif.
ENDLOOP.
l_s_var_range-low = txt.
l_s_var_range-sign = 'I'.
l_s_var_range-opt = 'EQ'.
APPEND l_s_var_range TO e_t_range.
endif.
ZGL_LIST_TXT - Your customer exit variable name, include that variable name in your keyfigure description area. .
ZGL_VALUES - Your P&L note input variable name.
try this concept.
Regards
Sureshkumar C
Hi Thomas,
can you please explain your scenario with some test data.
Regards
Sureshkumar C
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Thomas,
What I understood with your requirement is you want to create BEx query which have two input parameters. In output you required sum and variance .
I think you can create two selection based on your to variables and then create formula( A-B) for variance.
It will give you your desired output.
Thanks,
KDJ
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.