You work as the Project Server Administrator for Company Inc. You need to build a cube as per the
project manager’s needs. When you define the date range for the database, you have three options.
Which of the following options allows you to create a cube for all projects within your Project
Server?
A.
Use the “Fixed Date Range Specified Below” option.
B.
Use the “Follow Last and Next Time Units to Calculate the Date Range at the Time the Cube is
Built” option.
C.
You cannot create a cube for all projects in Microsoft Project Server. Each project must have its
own cube created.
D.
Use the “Earliest Project Start Date and Latest Project Finish Date” option.
Explanation:
You can create a cube for all projects by selecting the option “Use the Earliest Project Start Date and
Latest Project Finish Date” on the Cube Build Settings page. Use caution, however, as this setting can
cause processing time to be heavy as more projects are created or if your server has several projects
already created.
Answer option C is incorrect. You can create a cube for all projects in Microsoft Project Server.
Answer option B is incorrect. The option “Use the Follow Last and Next Time Units to Calculate the
Date Range at the Time the Cube is Built” is ideal for creating a sliding window of data to be built.
Answer option A is incorrect. The option “Use the Fixed Date Range Specified Below” creates a
specific date range for the data to be analyzed.
What are OLAP cubes in Project Server 2010?
OLAP cubes are controlled on the OLAP Database Management page in the ‘Server Settings’ on a
Microsoft Project Web App (PWA) site. The dimensions and measures of the OLAP cube can be
configured by a user for Project Server 2010, or the user can configure the build settings of a cube.
The parameters that can be configured on an existing OLAP cube are of two types as follows:
1.Dimensions and measures
2.Cube build settings