Skip to Content
0
Former Member
Mar 30, 2010 at 11:11 PM

FOX formula help!! Is this possible?

92 Views

Dear Experts,

I am very new to IP and FOX. Could you please help me with this.

Here is my scenario. My first Planning book generated data in the cube would look like this where the product price for the year is Planned. Since the prices are planned for the whole year you can see that the Period value and the Quantity is blank.

Data from Planning Book 1

PRODUCT -Year -Version -Type -Period -Quantity CURR---- Price -Amount

PRD1--


2010 -100 -- -100 -- #
000
-- USD -- -10 ----000

PRD2--


2010 -100 -- -100 -- #
000
-- EUR -- -20 ----000

PRD3--


2010 -100 -- -100 -- #
000
-- GBP -- -30 ----000

My Second Planning book generated data in the cube would look like this where the product quantity for each period is planned. Since this is quantities you can see that the currency is blank and the period has value and the Price and Amount are blank.

Data from Planning Book 2

PRODUCT -Year -Version-- Type -Period -Quantity -CURR Price -Amount

PRD1--


2010-- -100 -- 200
01
-- 100
#

000
---000

PRD1--


2010-- -100 -- 200
02
-- 120
#

000
---000

PRD1--


2010-- -100 -- 200
03
-- 130
#

000
---000

PRD2--


2010-- -100 -- 200
01
-- 100
#

000
---000

PRD2--


2010-- -100 -- 200
02
-- 120
#

000
---000

PRD2--


2010-- -100 -- 200
03
-- 130
#

000
---000

PRD3--


2010-- -100 -- 200
01
-- 100
#

000
---000

PRD3--


2010-- -100 -- 200
02
-- 110
#

000
---000

PRD3--


2010-- -100 -- 200
03
-- 100
#

000
---000

Continued in my next post for formatting.............