Building the OLAP cube

Building the OLAP cube can be a time-consuming process, so plan to do it during a period when people don't need to be using the Project Server database. To build the cube, follow these steps:

1. Log on to Project Web Access as the administrator, and click the Admin tab.

2. In the Actions pane, click the Manage enterprise features link.

3. In the Actions pane, click the Update resource tables and OLAP cube link.

4. Scroll down to the Build the OLAP cube section (see Figure 19-52), and select the Yes, I want to update resource availability information and build an OLAP cube option button.

a Microsoft Office Project Web Access 2DÛ3 - projectserver - Microsoft Internet Explorer

File Edit View Favorites Ta a is Help O Hack ' ' [j [j] ! Se«th Favorites »f Media f- - ^

Address Uf

Q Go Links

Customize Project Web Access

Clean up Project Server database

About Microsoft Office Project Server 2003


Build the OLAP cube

Do you wish to build an OLAP cube of project data?

f* Yes, i want to update resource availability information and build an olap cube c no, i only want to update resource availability information

OLAP cube name and description

Analysis Server: [ProjectServer

Cube description: jOLAP Cube for Sample database |

Analysis Server i extranet address: '-'

Date range i*1 Use the earliest project start date and the latest project finish date C Use the following date range at the time the cube ts built

C Use the fixed date range specified below

O Trusted sites

Figure 19-52: Use this page to provide the information that is needed to build the OLAP cube.

5. In the OLAP cube name and description section, enter the name of the server on which Analysis Services is installed, the name that you want to assign to the OLAP cube, and, optionally, a description.

6. In the Date range section, choose the date range that you want to use when building the cube.

7. In the Date range for resource availability section (see Figure 19-53), choose the date range that you want to use for resource updates.

8. In the Update frequency section, select the Update only when specified option button and then click Update Now. You see a message telling you that the cube creation process has started.

Figure 19-53: Choose a date range for resource availability and an update frequency.

As I mentioned at the beginning of this section, building the cube can take a while. And, you don't see anything happening on-screen while the cube is being built. You can, however, monitor the activity if you refresh the page and check the Current Cube Status section.

Remember the name of the OLAP cube that you are generating because you will need to refer to it later.

If you see an error message stating that the connection to the repository cannot be established, you may need to set additional permissions for the OLAP repository. Follow these steps to do so:

1. Open Windows Explorer.

2. Browse the folders until you are viewing the contents of the \ Program Files\Microsoft Analysis Services folder (see Figure 19-54).

3. Right-click the Bin folder, and click Properties from the shortcut menu that appears to open the Bin Properties dialog box (see Figure 19-55).

f C:\Protjram FilesMMlicrosoft Analysis Services

File £dit ïiew Favorites loofs Help

Address ||_J C:\Prooram FilesVMicrosolt Analysis Services


E >j My Compute! S ii 3X Floppy (A:) B ^ Local Disk (C )

SI Documents and Settings SI I net pub □ Progiam Files S Q Common Files

¿3 ComPIus Applications E Q Internet Explore« (Q Miciosolt ActiveSync b ¡ij gMMECHMMBIi

S ui Bin 83 CD Data ffi Help EB HelpSO 3 Q Samples E Q Miciosolt Office E Microsoft Office Project Setvei E L_) Miciosolt SQL Seivei E Ù Miciosolt Visual StudSo E D Miciosolt.NET IC3 MSXML 4,0 Û NetMeeting Outlook Express


Size j Type

UiBin lÖDala ÖHelp QHelp8Q Ir^ Samples 0 ieadme.txt ' uninst.dll uninst.isu

File Folder File Folder File Folder File Fodder File Folder

47 KB Tent Document

48 KB Application Exter 193 KB ISU File

8 objects (Disk free space: 1.75 GB)

Figure 19-54: Use Windows Explorer to find the Bin folder.

Bin Properties

Genaatj Sharing Security | Web Sharing! Customize |

Administrators (PROJECTSER VE R Wlminisbator s)

G roup or user names.


Power UissiPFOJE QTSEMflVPi»^ Usas] SYSTEM

Eermissions iot Administrators


Eermissions iot Administrators

F^jB Comrol


Read E. Errecute

LbL Fitter CorfenLi



Fw special peirnissions or for advanced sellings, click Advanced.


Figure 19-55: Use this box to add permissions to the repository.

4. Click the Security tab, and then click the Add button to open the Select Users or Groups dialog box.

5. Click the Advanced button, and then click Find Now. Choose OLAP Administrators from the list that appears, and click OK twice (see Figure 19-56).

[Select Users or Groups


Setect this object type:

JUiets, Groups, or Bult'in securfty principals Object Types... |

from this location:


Locations., j

Common Queries 1

Columns . 1

Name, | States with jJ |

[feuoij'rn J-.' with -|

1 Find Hew 1

r Disabted accounts


I- Non egpinrg.pssstM.ord

Deyt cjnce fest lojran: \




Cancel 1

Search results:


—ß 1


In Folder



d2 Network Configuration Operal..




0 OLARAdmin



£#Perfamance Log Useis


Perfcrmance Monitor Usets



ffi Power 1 Isers


Figure 19-56: Select OLAP Administrators.

Figure 19-56: Select OLAP Administrators.

6. In the Groups or user names section of the Bin Properties dialog box, click OLAP Administrators.

7. In the Permissions for Administrators section of the Bin Properties dialog box, select the Allow check box next to Full Control.

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