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