Calculation of absolute-figures with input specific-values

[Former Member]

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

[Former Member]

Dears,

thank you very much.

Thomas

[Former Member]

Hi Andrey,

thank you very much for your input - 0IPROV seems to be, what I'm looking for... do have any document about FOX-Formulas with examples and descriptions of the syntax?

Regards,

Thomas

[balajee_sivakumar]

Hi,

You can refer to the below links for more details on FOX Forumula,

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/20385aa3-8b91-2d10-2a80-90e222f2b...

http://help.sap.com/saphelp_nw04/helpdata/en/d3/8057f830a911d4b2be0050dadfb23f/frameset.htm

Regards,

Balajee

[Former Member]

Hi.

Create multi over plannig cube and actual cube.

Create aggregation level on this multi and use FOX formula for multiplying.

You can use 0IPROV in FOX for retrieving required data form actual cube.

Regards.