In Smart View for Office - before you refresh a worksheet you activate the display option to suppress #Missing values. When you refresh your worksheet, Analytic Services returns:
During calculation script development, you follow the calculation test procedure below:
1. Clear data from the database
2. Load test input data
3. Run the calculation script
4. Audit calculation results
What are the benefits of following this procedure? (Choose all that apply.)
During a CALC ALL or CALC DIM process, Analytic Services calculates sparse and dense dimensions in a specific sequence. What makes the default calculation sequence so efficient?