Is Olap cube update when a project is open?

C

Carolina

I have this doubt, Is the Olap Cube update doesn't consider the projects when
they're open? I will tell you the whole history:
A PM does not see the resources assignment changes for the team on the
Portfolio Analyzer. She assured me she made the changes before the Olap Cube
was updated. Off course I didn't believe her and after looking into the
change using Project Proffesional, I asked her to published and I update the
OLAP Cube again.
When I check the Portfolio Analyzer, the update was not performed for her
project. Then I realize that she still have her project open. She closed it
and I update the Olap Cube again, now it works. Is there any restriction to
update the cube that does not consider the projects open?

Thanks in advance
 
D

Dale Howard [MVP]

Carolina --

In the future, please post your Project Server questions in the
microsoft.public.project.server newsgroup, as this newsgroup is devoted to
the Microsoft Project desktop application only.

To answer your question, only Published information appears in the OLAP
cube. When your PM had the plan open in Microsoft Project, she should have
published the project using Collaborate - Publish - All Information to
immediately "push" the information to PWA so that it could be updated into
the OLAP cube the next time it rebuilt. Also, know this about Project
Server: when a user closes a project in Microsoft Project, the system
performs a "background publish" of the project plan, which is why the
information showed up in the OLAP cube the next time it rebuilt, even though
she did not publish it.

By the way, why are you rebuilding your OLAP cube while people are working
with their projects? You should schedule the rebuild at a time when people
are not using the system, such as at 2:00 AM. Hope this helps.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top