You are the Microsoft Project Server administrator for your organization. Based on the requests of
several project managers and management, you need to create some Data Analysis views. What is
the primary requirement to create Data Analysis views for your organization?
A.
Defined baselines
B.
Categories and permissions
C.
OLAP cube
D.
SQL Reporting Services
Explanation:
In order to create a Data Analysis view, you will need an OLAP cube.
Answer option A is incorrect. You would not need defined baselines to create a Data Analysis view.
Answer option D is incorrect. You do not need SQL Reporting Services; this is not installed by default.
Answer option B is incorrect. Categories and permissions are ideal for controlling what people can
view and access, but they are not requirements for views.
What is a data source view?
A data source view is a document that is used to describe the schema of an underlying data source.
It provides destinations and lookup tables for SQL Server Integration Services tasks, transformations,
data sources, and destinations.
A data source view is built on a data source. A data source view, in Integration Services, is a designtime object that makes it simple to implement the same data source in multiple packages. It is also
possible to extend a data source view. Data source views can be created in Business Intelligence
Development Studio, Analysis Services, and in Integration Services projects.
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