Is this a trap? How can I solve this?

building semantic layer
1

Hi,

I have created a universe lately and it allows users to enter their time worked for every project. But every project can contain sub-projects and users can also enter their time worked.

So for one project, I can have its time worked and also the time worked for each sub-prject.

My problem is this: As I have many sub-projects my time worked will be repeted as many time as my sub-projects number. Example:


Project    Timeworked(project)    Sub-pejct     Timeworked(sub-project)
   p1                 5h                 s1                  3h
   p1                 5h                 s2                  4h
   p1                 5h                 s3                  2h

Here is the structure of my universe:

timeWorked —1 project 1— porjectlink 1----1 subProject- 1----* Aliastimeworked
Please, can any one help?
Regards

zizou :tunisia: (BOB member since 2008-07-31)

2

Is the sample data provided by you is correct?

because Sum(Timeworked(sub-project)) not equal to Timeworked(project) for project P1.

Rakesh_K :india: (BOB member since 2007-12-11)

3

acutaly the time worked for the project will be the sum of the time in the second and 4th column. Si there is no relation between the time in the two columns

Regards,

zizou :tunisia: (BOB member since 2008-07-31)

4

then change the aggregation of Timeworked(project) from SUM to AVG in universe. and then try.

Rakesh_K :india: (BOB member since 2007-12-11)