Newbie -- Multiple Cube integrate One view

[wdporkchop]

Hello,

I am new to TM1 and I just completed a one week IBM Developer training course…so I am green behind the ears. Here is my situation. I have two cubes – Payroll with historical data (dim months, employee, gross amount, reg pay, other pay, dept, company and headcount). Rule used to calculate Headcount which is if gross pay <> 0, then 1. The other cube is Headcount Cube (Dim Pay Rate, Annual Salary).

We just upgraded to 9.5 and we will be using the workflow to allow departments to develop their budgets. I want to create a view that incorporates historical monthly payroll and shows the pay rate for each individual. I also want to add new budget time period. Actuals would be Jan ‘10 – Dec ’10 and budget (next year) would be Jan ‘11 – Dec ’11.

Employee Pay rate start date Actuals Actuals Budget Next Yr
Jan ’10… Dec ‘10 Jan ’11 – Dec ‘11
John smith 5000 5000 5000 5100
New position 4000 March ‘11


I can create this view in Excl with a slice and using formulas to link to the correct cubes/dimensions. I would like to create one view and push it out as a view to Workflow in 9.5. The departments will update the pay rates and employees. I will use calculations to determine monthly wages.

I have attempted to use Drill Through process but I have not been successful so far. What would be best practice steps? Any hints or advice is greatly appreciated.

Thanks.

[rkaif]

First of all I would like to point out that the cube structure which you have provided have got a couple of issues.
In Payroll cube:
Reg Pay and Other pay should be a single dimension.
Gross Amount should be a measure in your measure dimension.
Scenario/Version dimension is missing.

Headcount cube is missing the Employee, Time etc dimensions.

As I do not have your full requirements you may need to include some other dimensions as well.

If you you are on TM1 9.5 then you can use TM1 Contributor instead of using Workflow (but its your choice).