You need to write-enable the Planning partition

You are developing a SQL Server Analysis Services (SSAS) cube named Sales Planning.
The cube consists of two measure groups named Sales and Planning. Each measure group
is based on a data warehouse fact table and consists of a single MOLAP partition that has
the same name as its measure group.
The Planning measure group consists of two measures:
Forecast, which uses the Sum aggregate function
Forecast Count, which uses the Count aggregate function
Users contribute planning values by using a legacy application. An extract, transform, load
(ETL) process is scheduled to periodically transfer the planning values from the database of
the legacy application to the data warehouse.
Financial analysts query the Sales Planning cube and report that the planning values are
sometimes out of date. A new company requirement mandates that the planning values be
entered directly into the cube by using Microsoft Excel 2010 PivotTable What-If Analysis.
You need to write-enable the Planning partition.
What should you do before write-enabling the partition?

You are developing a SQL Server Analysis Services (SSAS) cube named Sales Planning.
The cube consists of two measure groups named Sales and Planning. Each measure group
is based on a data warehouse fact table and consists of a single MOLAP partition that has
the same name as its measure group.
The Planning measure group consists of two measures:
Forecast, which uses the Sum aggregate function
Forecast Count, which uses the Count aggregate function
Users contribute planning values by using a legacy application. An extract, transform, load
(ETL) process is scheduled to periodically transfer the planning values from the database of
the legacy application to the data warehouse.
Financial analysts query the Sales Planning cube and report that the planning values are
sometimes out of date. A new company requirement mandates that the planning values be
entered directly into the cube by using Microsoft Excel 2010 PivotTable What-If Analysis.
You need to write-enable the Planning partition.
What should you do before write-enabling the partition?

A.
Set the StorageMode property of the Planning partition to Rolap

B.
Set the ProcessingMode property of the Planning partition to LazyAggregations.

C.
Set the ProcessingMode property of the Planning measure group to LazyAggregations.

D.
Remove the Forecast Count measure.

E.
Set the Type property of the Planning measure group to Budget.

F.
Convert the Planning measure group to a linked measure group.



Leave a Reply 2

Your email address will not be published. Required fields are marked *


HR_OS_B

HR_OS_B

Explanation: Writeback works only with additive (SUM) measures.