Portfolio Analyzer views not current

[Conrad Santiago]

We are on MSP Server 2003. We just noticed our Portfolio Analyzer views were
not being updated. We manually ran the process to generate a new OLAP cube
by clicking on the "Update Now" button. (Normally, it is scheduled to run
over night.) At first, it wasn't working. We restarted some processes and
got it going again; receiving the highly coveted, "The cube was successfully
built on..." message. High fives all around, right? No!

We checked the Portfolio Analyzer views in PWA only to find no change. I
added Actual Work to one of the views and the last day to show any Actual
Work was 9 days ago. Based on the data patterns, it appears the data being
displayed is old data; presumably, 9 days old.

Despite this discovery so late, we do use the views daily; so they are
important to us.

The cube name and server names in the views descriptions and in the Admin
set-up for the OLAP cube match. So now, I am somewhat bewildered.

1. If the OLAP cube generated "successfully", is it safe to assume the data
has been updated in the OLAP cube? If so, why do the views not reflect this?

2. If not from the OLAP cube, where could the Portfolio Analyzer views be
getting the data? Is the view somehow saving a static snapshot of the data
from when it was last "updated"?

Any help would be appreciated. I'm at a lost on where to check next.

--Conrad Santiago

 

[Marc Soester [MVP]]

Conrad, check if you have any event log error when you build the cube. The
Portfolio Analyser can only retrieve data from a cube so it is important that
you make the cube work. I have not had any issues with the cube in the past,
once build it generally builds correctly.
Also can you identify which project is out of synch? If so you may want to
republish the project and re-process the cube.
Hope this helps

 

[Dale Howard [MVP]]

Congrad --

This behavior certainly is odd. Try the following and let us know what you
find:

1. Log into PWA with administrator permissions.
2. Click Admin - Manage Enterprise Features.
3. On the Update resource tables and OLAP cube page, check the option
selected in the Date Range section.

Is the option set to "Use the earliest project start date and the latest
project finish date" or something else? If something else, could that be
the source of your problem? Let us know what you find.

 

[Conrad Santiago]

Thanks for the responses.

The date ranges are correctly set for the OLAP cube.

The good news is that the next morning, after the OLAP cube was built again
over night, the views are updated and displaying correctly.

I'm not sure what we did to fix it. The only thing I can think of is that
we did something during the day that triggered a process over night to allow
the views to read the OLAP cube data. Although, that doesn't explain where
the "old" data was coming from.

Anyways, we're good for now. Thanks for the help.

--Conrad Santiago

 

[Dale Howard [MVP]]

Conrad --

Whew! I'm glad the problem fixed itself. You are more than welcome for
the help, my friend.