Skip to Content
0
Former Member
Sep 12, 2014 at 04:29 AM

SAP Bex Issue with Counter & Specific Cube data required.

17 Views

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