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.
