1.
Analytic Services can create data blocks during all of which set of processes?
2.
Which build method automatically adds shared members?
3.
The functions @ALLANCESTORS, @ICHILDREN, and @UDA are all examples of which type of function?
4.
Which member property should you use for members that meet the following conditions?
- No data is loaded to the member
- The member has no member formula
- No data is aggregated to the member
5.
You have the Smart View for Office client installed. In Microsoft Word and PowerPoint, how can Analytic Services data be displayed?
6.
What can be loaded using rules files?
7.
In each database, what determines the configuration of data blocks and the index system?
8.
You are limited to _____ alias table(s) per database
9.
In a database where both the Scenario and Customer dimensions are sparse, what is the effect of the following calculation script? CLEARDATA "Current Year"->"O-IBM";
10.
During the forecast cycle, you adjust Jan, Feb, and Mar data using Smart View for Office. After submitting the adjusted data, you refresh the worksheet. The adjusted data displays, however, the total for Qtr 1 has not changed. Why?