I got a new task and I need your support.
Scenario as follows
Users want to plan specific costs within IP ones per month, like:
time (eg. calmonth) / Attribute 1 from (eg. thickness) / Attribute 1 to (eg. thickness) / specific costs (eg. Euro / To)
02.2011 / 500 mm / 599 mm / 50 Euro / To
Orderd Quantity to multiply specific costs are stored in another Infocube
time (eg. calmonth) / Attribute 1 (eg. thickness) / Orderd quantity
02.2011 / 580 mm / 300 To
How can I multiply Orderd Quantity from 2 with specific costs from 1 AND build up a query? Where do I need the formula? Do I need a new (restricted) key-figure? Do I need a new InfoCube or a multi-provider? What is the best solution?
Every input will be assigned with points.