PWA 2007 RBS structture not in OLAP Cube

[yme]

Hi,

I've built the RBS structure in the lookup table, assigned resources
to it and even checked that in database each resource has got it's
Rbs weel assigned.

Now I've built the OLAP database but I can't se any reference to RBS
in any of the created cubes.

Can anyone help me?

 

[Ben Howard]

In the cube configuration, is the RBS listed in the dimensions? If so,
rebuild a cube, the RBS dimension should be available. I would check
directly via SQL Management Studio in the 1st instance.

 

[yme]

Hi Ben,

Thanks for the fast answer!

I'm a newibie so I thought that was automatic...

I've followed your advice and it worked!
Thanks!!!

Now can you answer my another question please?

I have to track CPI and SPI per project and per week.

As CPI and SPI are calculated based on ACWP, BCWP and BCWS maybe there
is a way to track these other indicators and create two calcutated
fields for CPI and SPI.

Can you help me?

Thanks in advance,

Carla




Ben Howard escreveu:

 

[Ben Howard]

Hi Carla,
CPI and SPI are already calculated for you.

 

[yme]

Hi Ben,

Sorry but I've searched in all Cubes and haven't found CPI or SPI in
any of these Cubes.

Maybe I'm doing something wrong.

Carla



Ben Howard escreveu:

 

[Ben Howard]

Hi Carla,
They are available as part of the Project Centre views.

To write an an MDX expression for the CPI and SPI....
In the cube configuration, create an MDX expression and a new measure, so
SPI = [BCWP]/[BCWS], and CPI = [BCWP] / [ACWP]

These values will then be created in the cube each time it is built. You
may well want to do some validation in the MDX expression, not sure what
would happen if you tried to DIV by 0 for instance.

 

[yme]

Hi Ben!

It worked! Thanks again!

Just a last doubt, the CPI and SPI I'm getting is for actual Satus
Date of projects.

Is it possible to get these indicators per week since the beggining of
the project?

Carla




Ben Howard escreveu:

Hi Carla,
They are available as part of the Project Centre views.

To write an an MDX expression for the CPI and SPI....
In the cube configuration, create an MDX expression and a new measure, so
SPI = [BCWP]/[BCWS], and CPI = [BCWP] / [ACWP]

These values will then be created in the cube each time it is built. You
may well want to do some validation in the MDX expression, not sure what
would happen if you tried to DIV by 0 for instance.
--
Thanks, Ben.
http://appleparkltd.spaces.live.com/

Hi Ben,

Sorry but I've searched in all Cubes and haven't found CPI or SPI in
any of these Cubes.

Maybe I'm doing something wrong.

Carla



Ben Howard escreveu:

 

[Ben Howard]

Hi Carla,
This would be possible but dedious, as it would involve changing he status
date of each project for for each week. I assume you want to take this data
and stick it in some external reporting system, eg excel and you could
achieve for each project at the project summary task level, but a better way
forward might be to run the normal EVA graphs for each project, as then you
can see the EVA analysis for the whole project, rather than just getting
weekly snapshots via OLAP.

--
Thanks, Ben.
http://appleparkltd.spaces.live.com/

Hi Ben!

It worked! Thanks again!

Just a last doubt, the CPI and SPI I'm getting is for actual Satus
Date of projects.

Is it possible to get these indicators per week since the beggining of
the project?

Carla




Ben Howard escreveu:

Hi Carla,
They are available as part of the Project Centre views.

To write an an MDX expression for the CPI and SPI....
In the cube configuration, create an MDX expression and a new measure, so
SPI = [BCWP]/[BCWS], and CPI = [BCWP] / [ACWP]

These values will then be created in the cube each time it is built. You
may well want to do some validation in the MDX expression, not sure what
would happen if you tried to DIV by 0 for instance.
--
Thanks, Ben.
http://appleparkltd.spaces.live.com/

Hi Ben,

Sorry but I've searched in all Cubes and haven't found CPI or SPI in
any of these Cubes.

Maybe I'm doing something wrong.

Carla



Ben Howard escreveu:
Hi Carla,
CPI and SPI are already calculated for you.

--
Thanks, Ben.
http://appleparkltd.spaces.live.com/



:

Hi Ben,

Thanks for the fast answer!

I'm a newibie so I thought that was automatic...

I've followed your advice and it worked!
Thanks!!!

Now can you answer my another question please?

I have to track CPI and SPI per project and per week.

As CPI and SPI are calculated based on ACWP, BCWP and BCWS maybe there
is a way to track these other indicators and create two calcutated
fields for CPI and SPI.

Can you help me?

Thanks in advance,

Carla




Ben Howard escreveu:
In the cube configuration, is the RBS listed in the dimensions? If so,
rebuild a cube, the RBS dimension should be available. I would check
directly via SQL Management Studio in the 1st instance.
--
Thanks, Ben.
http://appleparkltd.spaces.live.com/



:

Hi,

I've built the RBS structure in the lookup table, assigned resources
to it and even checked that in database each resource has got it's
Rbs weel assigned.

Now I've built the OLAP database but I can't se any reference to RBS
in any of the created cubes.

Can anyone help me?

 

[yme]

Hi Ben!

Thanks again!

I already have a VBA macro that does that, changes the Status Date
since the beginning of the project and retrieves the CPI and SPI
values until the actual Status Date.

My problem is that now we want these kind of graphics to be available
in the pwa, so I'm thinking about creating a function to store older
values and after create a trigger to run every week.



Thanks for all the help!!

Carla



Ben Howard escreveu:

Hi Carla,
This would be possible but dedious, as it would involve changing he status
date of each project for for each week. I assume you want to take this data
and stick it in some external reporting system, eg excel and you could
achieve for each project at the project summary task level, but a better way
forward might be to run the normal EVA graphs for each project, as then you
can see the EVA analysis for the whole project, rather than just getting
weekly snapshots via OLAP.

--
Thanks, Ben.
http://appleparkltd.spaces.live.com/

Hi Ben!

It worked! Thanks again!

Just a last doubt, the CPI and SPI I'm getting is for actual Satus
Date of projects.

Is it possible to get these indicators per week since the beggining of
the project?

Carla




Ben Howard escreveu:

Hi Carla,
They are available as part of the Project Centre views.

To write an an MDX expression for the CPI and SPI....
In the cube configuration, create an MDX expression and a new measure, so
SPI = [BCWP]/[BCWS], and CPI = [BCWP] / [ACWP]

These values will then be created in the cube each time it is built. You
may well want to do some validation in the MDX expression, not sure what
would happen if you tried to DIV by 0 for instance.
--
Thanks, Ben.
http://appleparkltd.spaces.live.com/



:

Hi Ben,

Sorry but I've searched in all Cubes and haven't found CPI or SPI in
any of these Cubes.

Maybe I'm doing something wrong.

Carla



Ben Howard escreveu:
Hi Carla,
CPI and SPI are already calculated for you.

--
Thanks, Ben.
http://appleparkltd.spaces.live.com/



:

Hi Ben,

Thanks for the fast answer!

I'm a newibie so I thought that was automatic...

I've followed your advice and it worked!
Thanks!!!

Now can you answer my another question please?

I have to track CPI and SPI per project and per week.

As CPI and SPI are calculated based on ACWP, BCWP and BCWS maybe there
is a way to track these other indicators and create two calcutated
fields for CPI and SPI.

Can you help me?

Thanks in advance,

Carla




Ben Howard escreveu:
In the cube configuration, is the RBS listed in the dimensions? If so,
rebuild a cube, the RBS dimension should be available. I would check
directly via SQL Management Studio in the 1st instance.
--
Thanks, Ben.
http://appleparkltd.spaces.live.com/



:

Hi,

I've built the RBS structure in the lookup table, assigned resources
to it and even checked that in database each resource has got it's
Rbs weel assigned.

Now I've built the OLAP database but I can't se any reference to RBS
in any of the created cubes.

Can anyone help me?

 

[carlaferreira2]

In the cube configuration, is the RBS listed in the dimensions? If so,
rebuild a cube, the RBS dimension should be available. I would check
directly via SQL Management Studio in the 1st instance.
--
Thanks, Ben.http://appleparkltd.spaces.live.com/








- Mostrar texto citado -

Hi again,

I'm having this problem again. The RBS dimension shows in Resource
Timephased and in Portfolio Analyser. In Resource Timephased RBS
relates to Resources but in Portfolio Analyser this doesn't happen.

Can you help me?

Thanks!

Carla