Slab Wise Value display

[Former Member]

I would like to display values from a slab in bex report. The values of that slab is stored in a DSO. The scenario is something like this : If a salesman has achieved its targets then he is eligible for some incentives . Their is a slab which says, if he has achieved more than 0-10% of his target then he should get 150 Rs. ...in case if he has achieved  11-40% then he should get 500 Rs...

In my cube i have targets and actual sales. through which i can get to know that how much he has achieved for a given period of time. Now i want to analyze that how much incentives he will get. This information i have to display in a bex report.

One way of doing this is doing it at modeling level. But i want to do this at reporting level because in my scenario, slab values are getting changed very frequently . Is their any way of doing this in Bex via some customer exit etc...

Actually i am looking for some exit which can give me final results of my bex query (after CKF & RKF calculations) and based on those values i'll look up in DSO.

My report output has to be something like this

SalesMan	Target	Achieved	Achieved %  - This will be a CKF	Incentive
S1	100	110	10%	150 - This value will be derived using slab and based on Achieved %. For this i want to do a lookup in DSO

Please suggest ...Waiting for your inputs.

Thanks.

Aashish

[former_member189638]

Why don't you create a multiprovider with the Cube and DSO and create a query on top of multiprovier?

Then you can do the calculation in the query.

[Former Member]

Thanks for the reply rakesh.

But unfortunately that will not help. Reason being, the slab contains a range. and my cube is already having an actual and target key fig. How much % a salesman has achieved against a given target is something which is getting calculated at run time in bex. If i'll use Multiprovider i'll not be able to check that, this newly calculated key fig lies in which category.

If i'll be creating a multiprovider on cube and slab dso then my data in multiprovider would be something like this.

Infoprovider	0Calmonth	Salesman Code	From Value	To Value	Target Sales	Actual Sales	Incentive Payout
Sales Cube	01.2012	s1			100	110
Slab DSO	01.2012		0	10			150
SLab DSO	01.2012		11	70			350
Slab DSO	01.2012		71	100			500

Now lets say i'll create an CKF in bex to get the Achieved%. In this case Achieved % for Salesman S1 would be 10%.  Now i don't see any way to compare it with slab's value in  multiprovider.

My client is not allowing me to change existing cube structure bcz  of historical data of around 5 years. If i had an opportunity to change the transformations and cube structure then this could have been easily done.

But the challenge is that, this have to be done at reporting level.

Please suggest some more options Rakesh. May be we can together crack this challenge.

Thanks once again for taking time.

[former_member189638]

Don't drag the objects from the DSO to your query. Just include them in the Multiprovider.

Then you can create a CKF with if else condition and use the CKF in your report. 

[Former Member]

Can u please elaborate your option.