Managing the OLAP cube

To use the Portfolio Analyzer feature in the Project Server database, you need to build an Online Analysis Processing (OLAP) cube using Analysis Services repository information. Building the OLAP cube consists of the following three-part process:

1. Migrate the Analysis Services repository to an SQL database.

2. Build the cube.

3. Give users permissions to use the cube.

Building the cube is a processor-intensive procedure. You should avoid running other processes or using Project Web Access while building the cube.

Project Management Made Easy

Project Management Made Easy

What you need to know about… Project Management Made Easy! Project management consists of more than just a large building project and can encompass small projects as well. No matter what the size of your project, you need to have some sort of project management. How you manage your project has everything to do with its outcome.

Get My Free Ebook


Post a comment