1.
Which set of statements best describes the role of the Main Rollup section in a calculation script?
2.
A data load rules file provides which options to load data?
3.
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:
4.
If a dimension is missing in your data source, what does Analytic Services do when you load the data?
5.
A calculation script
6.
Which member property ensures a member is always calculated on retrieval?
7.
Which outline hierarchy produces the following calculation:
Parent = (Member1 - (Member2 / Member3)) * Member4
8.
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.)
9.
Which of the following characterizes the top member in an alternate hierarchy?
10.
Which options are available to manipulate fields in Data Prep Editor?