Which Microsoft Project Server service manages OLAP cubes to view within Project Web Access and
to use Data Analysis Services?

A.
Analysis Services

B.
Data Management Service

C.
Cube Building Service

D.
Reporting Data Service

Explanation:
It is the Cube Building Service that provides the ability to view data through Project Web Access and
to use Data Analysis Services. 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.
Answer option D is incorrect. The Reporting Data Service generates metadata and data for the Cube
Building Service.
Answer option B is incorrect. This option is invalid. There is no such service as Data Management
Service.
Answer option A is incorrect. Analysis Services allow the Data Analysis Wizard to interact with the
cube and the data.
What is SSAS?
SSAS stands for SQL Server Analysis Services. It stores, processes, and secures data. It delivers OLAP
(Online Analytical Processing) and data mining functionalities for business intelligence applications.
It is used to design, create, and manage multi-dimensional structures that contain data aggregated
from other data sources.