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 multidimensional structures that contain data aggregated from other data sources.