Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

SAP Bex Issue with Counter & Specific Cube data required.

HI Experts,

I need help on below 2 issue in Bex Designer .

1. I have "Sales Plan" KF and "Style" and Charecterstic, My requirement is when i drill down "Style" in "Counter" object i need to count number of Positive figures on "Sales plan".

Eg.

Style   Sales Plan   Counter     Total Positve Counter (Sum of Counter)

100       20               1                    2

200       -10               0

300         0               0

400         60               1

2. I have "Forecast Month Year" variable in selection , If User inputs "#" than it will get data from ZES_C4 Cube & any other selection it will get from ZES_c6 , ZES_c8, ZES_c10 . Query built on Multi provider which is included all cubes above.

NOTE - I have to handle above 2  requirement in Query level with out using any Customer Exit . For 1st requirement i have used Count & Delta functionality of Data finctions in Bex but it is not solving my issue .

Please tell me step by step Solution for above 2 issue. Highest Point for sure.. Its urgent.

Thanks,

GB

Former Member
Former Member replied

Thanks Sakthi.. I tried to develop code for my requirement . Please go through it and plz let me know if it works ..

I highly appreciate if you can modify code if you found any inconsistancy ..and paste it back i will use as it is in Customer exit..

Appreciate your time and efforts..

DATA:   vnam(10) type C,
        i_t_var_eange TYPE rrrangesid.

If I_step2 .

* forecast var. name in selection screen

If 'TYFMYR'

Loop at i_t_var_range into e_var_range

*checking if Variable found for Till Year and Last Year

where vnam eq 'TYFMYR'and 'LYFMYR'.

*checking for # value user input and assiging cube

if e_var_range-low = '#'.

e_s_range-low = 'zES_c4'.
e_s_range-sign = 'I'.
e_s_range-opt ='EQ'.

append e_s_range to e_t_range.

else

e_s_range-low = 'zes_c5''zes_c8''zes_c09'.
e_s_range-sign = 'I'.
e_s_range-opt ='EQ'.

endif.
Endif.

endloop.

0 View this answer in context

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question