SAP Bex Issue with Counter & Specific Cube data required.

[Former Member]

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

[KodandaPani_KV · Accepted solution]

Hi,

about 1 question

create the new formula - use the count KF >0 after use the exception aggregation-> reference char as style.

[Former Member · Accepted solution]

Thanks .. First issue resolved ...

But Still Waiting for second .. to be resolved..Can anyone please update ... Thanks

[Former Member · Accepted solution]

Hi,

as i already told, in filter section add 0infoprovider and create custoemr exit type variable.

in the exit,read the forecast month values. if #, then pass the cube name as required to this variable

hope you understand this logic.

** its not possible wihtout customer exit..

Regards,

Sakthi

[Former Member · Accepted solution]

Hi Sakthi ,

Thanks for your reply ..

It seems very Simple code but as i am new to ABAP is that possible for you to paste correct code for my requirement ..

Thanks in advance....

[Former Member · Accepted solution]

Hi,

there would be many document available i guess. but here is the one i created for simple logic based on date user input. again it doesn't have the complete code..you need to make few declarations.

just write the code in I_step2 and pass the infoprovider.

Regards,
Sakthi

[Former Member · Accepted solution]

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.

[Former Member · Accepted solution]

Hi,

not sure, what 2 variables are: but i assume, if both variables (TYFMYR'and 'LYFMYR') entered by user is blank, then C4 cube, else the remaining cubes... if not, plz modify accordingly. there would be syntax error, which you can correct yourself.

If i_step eq 2.

data: e_s_range type rsr_s_rangesid,

   e_var_range type rrrangeexit,

   e_var_range1 LIKE rrrangeexit,

   w_TYFMYR type C,

   w_LYFMYR type C.

clear: e_var_range,

   e_var_range1,

   w_TYFMYR,

   w_LYFMYR.

Read table i_t_var_range

into e_var_range

with key vnam = 'TYFMYR'.

if sy-subrc eq 0 and e_var_range-low eq '#'.

w_TYFMYR = 'Y'.

endif.

Read table i_t_var_range

into e_var_range1

with key vnam = 'LYFMYR'.

if sy-subrc eq 0 and e_var_range1-low eq '#'.

w_LYFMYR = 'Y'.

endif.

IF w_TYFMYR eq 'Y'

and w_LYFMYR eq 'Y'.

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'.

e_s_range-sign = 'I'.

e_s_range-opt ='EQ'.

append e_s_range to e_t_range.

clear e_s_range.

e_s_range-low = 'ZES_C8'.

e_s_range-sign = 'I'.

e_s_range-opt ='EQ'.

append e_s_range to e_t_range.

clear e_s_range.

e_s_range-low = 'ZES_C09'.

e_s_range-sign = 'I'.

e_s_range-opt ='EQ'.

append e_s_range to e_t_range.

endif.

endif.

[Former Member]

Hi,

1. you can add your sales KF in a formula and make if KF>0, then 1 and use the counter on this KF

2. you can build logic on 0infoprovider characteristic. create a customer exit varialbe on this char, build logic based on user input. there are many blogs already available for this logic.

Regards,
Sakthi