cancel
Showing results for 
Search instead for 
Did you mean: 

Displaying text of chosen selection option

Former Member
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

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

former_member209606
Participant
0 Kudos

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

Former Member
0 Kudos

Hi Sureshkumar.

thanks for the great and detailled support - the solution worked out!

Kind regards,

Thomas

Answers (2)

Answers (2)

former_member209606
Participant
0 Kudos

Hi Thomas,

can you please explain your scenario with some test data.

Regards

Sureshkumar C

Former Member
0 Kudos

Hi Sureshkumar,

I replied to my initial message, explaining the scenario.

Thanks a lot for your help,

Thomas

KulDeepJain
Active Participant
0 Kudos

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