I am looking solution for my

ScoolProject to solve calculations topic (production quantity and cost-roll up) witch i have create in MS Excel (i like to port this logic into palo cube). I allready create sales cube (in way

Best Biker template), Like i said I have create excel model to solve MRP planing and

roll up cost, but I do not know yet how to transform this model into

Palo. Perhaps somebody do this allready in his model. Can enyboty pleas help me?

I tray to solve my Chalange whitch is How

to prepare modet to calculate production quantity (MRP planing) and

production prices (cost roll up).

1. Imput data:

-sales plan (Qth);

-BOM and routing (in my attached case there I have only BOM data, allso whitout Capacity);

-Purchase price (activity prices for Routings)

2.

Calculation Model (I use it in excel with index,match and IF formula)- I

attached it in Excel).

- Whitch dimension to create?

-company,

-year and month,

-parent matirial code

-production version

-child

material code

-child QTH_normativ

-capacity,

-child QTH_normativ

-chart of account (to make later GuW cube)

-version (Simulation)

- Join Table:

-stock Qth (parent and child item),

-sales Qth for parent material code

-activity prices (routing),

-row material prices,

- Transform Table Roules:

-production quantity for parent material code

-production Qth for child material code (butom up, button down)

-production cost Roll UP (standard cost)

-needed purchase quantity (MRP-stock Qth)

I

would be very very greatful someboy can shere his Ideas. I like to hear Your view of my idea. How would you solve this

Project your way?

Best Regards

Boris