We're doing a BI-IP planning project, and we need to implement price planning.
Prices have to be planned like any other key figure.
But I've faced a problem - it seems that since price isn't a cumulative value, it can't be stored in planning cubes, and aggregation levels, and therefore can't be planned... It kinda makes sense but it seems weird that this common task cannot be done using BI-IP.
Could anyone please advise me what can be done for price planning, and what's usually done?
The only option that occurs to me is adding price as an attribute of a characteristic, but then it won't be possible to enter the planning values in web or Excel... And it's required to enter price planning values on different levels (store, region etc.) - and this probably won't be possible with master data as well.
If anyone had already faced similar problem, please share your experience.