how to sum categories?

[charan]

Hi,
I have an requirement, please I cannot post the cube views,
In the cube A I have dimensions;
Employee Details,
Region
Staff catregory
Sl.No.
In employee details we have Emp.Id,Emp.Name,Emp category(Director,VP,ExectiveManager etc)
There are like for each employee based on category he has start date and end date, and also has bill rate for the employee.
I cube i need get total value for each category like(Director,VP,ExecutiveManager etc)here,
for every month I should get the total for each category bill rate(total or sum),
For example, I have Executive managers for 5 different employees who is billed in Jan month
In the Cube B, I should get the total(whole sum) for each category for each month.

I have tried writing for this but notable get the sum of Categories

TM1 9.5.2
Excel 2007

Thank you.

[lotsaram]

This is or at least should be a straightforward requirement. What's the dimensionality of cube B?

[yuval]

must do it in process,
create a view -->need to accumulate the values for the desired intersaction with cell get and cell put, for example:
vtotal = cellgetn(from source cube/view)+vtotal
cellputn(vtotal, target cube),
then you will have the total for each category,

good luck,

[winsonlee]

usually for such requirement i would just create a hierarchy in the Employee dimension. Through this way you are able to maintain the data in one cube and report against each category and all the groups.

All Employees
- Director
-- Name A
- VP
-- Name B
-- Name C
- Executive Manager
-- Name D
-- Name E
-- Name F

[lotsaram]

must do it in process,
create a view -->need to accumulate the values for the desired intersaction with cell get and cell put, for example:
vtotal = cellgetn(from source cube/view)+vtotal
cellputn(vtotal, target cube),
then you will have the total for each category,

good luck,

What do you mean "must do it in process"?
Depending on the model, possibly maybe, but most of the time in cases like the OP has described (from the very little we have been given to go on anyway) this would probably be done with a rule not TI as it implies a planning model where there is usually a requirement for sumarized totals to be immediately available on data change without need for batch processing.

For a TI process solution it also wouldn't have to be a leaf view with accumulate values - it could just as validly pull consolidated amounts and write directly (I'd usually go the leaf accumulation route myself as most of the time it's quicker, not always though.)

From here on in with Performance Modeller doing such rule or process "accumulation links" looks like it is going to get a whole lot easier for novices. I think this is a good thing on the whole but it is probably going to lead to some very interesting models...

[charan]

thank you.

Hi Lotsaram,

In cube B i have three dimensions;
Months,
Employee bands(Director,executives,Mangers,Analyst etc)
Type(Sales, marketing etc).

In the second cube my calculation should be like,
For month Jan, I should get all employees(sum) who belongs to Manager band values.The remaining months also will be the same.