Combine Cubes with different entities

The goal is to produce to the following structure:

Employee / Activity / Hours / ( activity / capacity )

So i have a cube with the employees, activities and hours for each day and i have a cube with the capacity per day per employee. And also the time period will change, so the capacity is a variable. The report can be for a year, month, week, or day. And also can't combine it in 1 cube because i can have several activities on one day, but the capacity is only 1 line a day.

The problem is that i don't have a activity for the capacity hours, and when i combine the two cubes it will display all the articles for the capacity cube. And when i add a activity for the capacity it will display that activity ( even if i say hide it )

Capacity is not attached in some way to activity and it will not display it or i can't calculate with it. I want the use the capacity ( 160 in this case ) for each line ( for example 13.25 hours / 160 hours ), but there's no connection.

Is it possible?

Thank you

Find more posts tagged with

Accepted answers

All comments

Daniele Di Lorenzo

use the account based approach and use the same entity for cap and activity (e.g. called "report line" or "data type")

use a parent entity to quickly select capacity or activity

CHILD ENTITY PARENT

Capacity Capacity

Activity#1 Activity

Activity#2 Activity

...

Activity#N Activity

it requires some more time for 1st setup but will allow a great flexability in reporting and further improvements

Alexander Kappes

Dear Bas Koomen,

thanks for your request.

I think easiest way for solving your request is using BOARD Algorithm in Combination with Nexel.

In my little sample I use 2 Entites plus time and 2 Cubes.

Cube Cpactiy depends to Month and Employee. In this I save the amount of monthly hours.

Cube Workload is based to Month, Employee and Activity. I insert the hours to work for a month.

In the right dataview I calculate the percentual workload with standard BOARD Algorithm.

The restcapacity is calculated by nexel.

I hope it helps.

If you are interested I can send the case to you by eMail

regards

Alexander Kappes

Bas Koomen

Thank you both for the solutions, i will try to implement it and i will let you know if it works!

Bas Koomen

Today i had time to try the mentioned solution, so i created a parent entity ( with fields capacity and activity ) and a child entity with the different activities and capacity. Then i created a cube with these entities. The result will be the following table:

But i'm kind of lost how to go on then, how do i tell Board what the connection between capacity and the different activities is? Do I create different blocks and calculate the different values?

Bas Koomen

When i read your solution i think i already made that, but the thing that went wrong is that when i add a block with a cube that has no activity entity connected it will display all the activities. And in this case i have thousands of items ( activities ). And i got me confused. So now i will try to make the correct activity groups to display the correct lines.

Thank you