You work as the Project Administrator for company.com Inc. You need to create and schedule a new cube for your organization. While building the cube, what will happen if you enter the name of the database to be used by Analysis Services that does not exist already?
A.
You will not be able to approve the cube creation until a database connection is made.
B.
The cube creation will fail in the queue until the database is created.
C.
The database will be created automatically.
D.
The cube will not be created until the database is created.
Explanation:
When you enter the name of a database in the build cube section of Server Settings of a database that does not exist, the database will be created automatically. 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
Answer options A, B, and D are incorrect. These statements are not valid for the OLAP Cube and the related database settings.
What is the Cube Building Service? The Cube Building Service is a reporting and analysis feature in Microsoft Project Server that allows a user to perform complex analysis of project data. It uses SQL Server Analysis Services to create an online analytical processing (OLAP) database containing several cubes that are used for data analysis reporting. It is administered through the Project Web Access Site Settings page. It allows for data cubes to be built from selections within the Reporting database.