planning on 10 keyfigures
I have unique requirement as it always turns out to be -:)
This is more of a functional question rather than a techie Q.
My user wants to do a planning on per customer basis periodwise for Discounts to be given to each user.
Now there are about 10 different types of Discounts that the customer can avail & the user wants plan separately each of them. This will enable him to see the agggregate figures for each Discount type.
now my concern seems to be whether the performance of the system or the complexity would increase if we consider planning on 10 keyfigures simultaneously. (I am not so sure on this performance aspect.)
Can i go about having this 10 KF for planning ?
or could there be any alternative possible ? i am not able to think any till now, as the user is keen on planning in all the 10 discounts types.
or how would be the approach if put this Discounts types into char ? (cant imagine)
any help is appreciable
ragav beemarao replied
I have had similar requirement before on sales application and we chose characteristic approach because in a period a customer would have maximum of 3 to 4 discount types based on eligibility criteria.
But if you think a customer may be eligible for all discount types then i would suggest going with key figure approach.By doing this way you can limit the number of records.
Downside to this is tracking all these key figures when you write any required function.
Hope this helps.