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--
PRD2--
PRD3--
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--
PRD1--
PRD1--
PRD2--
PRD2--
PRD2--
PRD3--
PRD3--
PRD3--
Continued in my next post for formatting.............