Calculation of absolute-figures with input specific-values

57 Views

Hello Experts,

I got a new task and I need your support.

Scenario as follows

1)

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

...

2)

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.

Regards,

Thomas