# Performing allocations

This site uses cookies. By continuing to browse this site, you are agreeing to our Cookie Policy.

• # Performing allocations

Hi

Need some advice on the best course of action to take to perform this allocation.

In one cube, I have costs by cost centre, product and month. I want to allocate these costs by customer based on sales units which is held in another cube. What would be the best course of action?

Many thanks,

Kavee

CUBE: Production_Costs (3 dims. Cost Centre, Product, Month)

Dim: COST CENTRE {A...x}
 Dim: Month Dim: Product J F M A M J J A S O N D Prod1 2000 ... Prod2 ... Prod3 ... Prod4 ... 3500

CUBE: Sales_Units (3 dims. Product, Customer, Month)

Dim: Product {Prod1...4}
 Dim: Month Dim: Customer J F M A M J J A S O N D Cust12 3 4 5 ... Cust2 2 3 ... Cust3 7 ... Cust4 8 ...

CUBE: Allocated_Costs (4 dims. Cost Centre. Product. Customer. Month)

Dim: COST CENTRE {A...X}
Dim: Product {Prod1...4}

 Dim: Month Dim: Customer J F M A M J J A S O N D Cust1 Cust2 Cust3 Cust4
Files

The post was edited 1 time, last by Kaveenga: included attachment ().

• The best way forward here would be by building a rule in the cube's rule editor.

By looking up the cost of each product, number of products sold to each customer, you can allocate the costs against each customer.
• Thanks Kiran.gs.
Yes, via rules its rather easy.
However, I am after a solution using Jedox ETL.
• In fact, you could create a Rule Extract in the ETL, with the same parameters. Once you do that, you assign the rule to a cube and load the rule, just the way you load a cube or a dimension. The assignment can be done in a Rule Load.

You can copy/ paste the rule from the cube>rule to the Rule Extract.

Kiran
• how is that different from writing a rule on the 'Allocated_Costs' cube?

What I am after is a process which will calculate the allocated values and hardcode the values in the target cube.
• Thanks Michael for the suggestions! Got it to work.

Hi Kavee,
I would suggest for you to look into the following: -
1. Cube Extract - You need a Cube Extract for each Cost and Sales Units Cubes.

2. Table Join Transform - After defining the Tables(Extract) for Cost and Sales Units, you can use Table Join tranform to merge the two tables.
3. Field Transform with Groovy/Java Script function. Once you have a single table, then calculate for the allocation.
4. Then Load it into Allocated_Costs Cube
Regards,
Michael Maquinto