Ensurepass  QUESTION 81 You want to compare the sales revenue performance of the top 20% of your customers to the average of all of your customers. You decide to apply a rank on the table that shows customers and revenue and create a variable to show the average revenue for all customers. Which function should you use in the variable?   A. NoFilter()         B. NoRank() C. AverageAll() D. IgnoreFilter()   Answer: A     QUESTION 82 Which is Read more [...]
Ensurepass  QUESTION 91 You open a Web Intelligence document (WID) with data and want to use data tracking. The         Data Tracking button is however grayed out. Which action should you take to enable formatting of the tracked data?   A. Contact the system administrator. B. Edit the document in tracking mode. C. Open the document in tracking mode. D. Enable data tracking in the Document Properties.   Answer: A     QUESTION 92 Which tool Read more [...]
Ensurepass  QUESTION 71 Which statement describes a benefit of using the NoFilter() function?   A. It overrides query filters. B. It overrides query ranking. C. It overrides report ranking. D. It overrides universe security   Answer: C     QUESTION 72 Which two settings can you configure for the Sample option in the Properties tab of the Web Intelligence Query panel?           A. You can enable the "Fixed" option. B. You can Read more [...]
Ensurepass  QUESTION 51 Where do you set the "Optional prompt" option in Web Intelligence Rich Client?   A. Query Panel B. Prompts Panel C. Slice and Dice Panel D. Document Properties   Answer: A     QUESTION 52 Which two statements are true about using the Where operator with an output context?   A. It must contain Boolean operators. B. It restricts the data used to calculate the measure expression. C. It modifies the WHERE clause of the SQL Read more [...]
Ensurepass  QUESTION 61 Which three object types can you use in a Web Intelligence universe query?   A. Class B. Detail C. Measure D. Dimension E. User Defined   Answer: BCD     QUESTION 62 Which two options should you take before you finish creating a variable in Web Intelligence?   A. Save B. Parse C. Export D. Validate   Answer: AD     QUESTION 63 Which statement is true about calculation contexts?   A. They Read more [...]
Ensurepass  QUESTION 41 Which two panels can you use to purge data from a BusinessObjects Web Intelligence 4.0 document (WID)?   A. Query B. Report C. Active X D. Slice and Dice   Answer: AB       QUESTION 42 Which two statements are true about Page Layout of a report?   A. It displays the definition of the block. B. It displays the report page by default. C. It defines what the report will look like when printed. D. It defines what the Read more [...]
Ensurepass  QUESTION 31 Which two options can you change when using Quick Display Mode?   A. Limit Query Results B. Sample Query Results C. Vertical Records Per Page D. Horizontal Records Per Page   Answer: CD     QUESTION 32 Which method should you use to activate "Interactive Viewing"?   A. Preferences in Web Intelligence B. Preferences in InfoView C. In the Document Properties         D. In the Report Properties   Read more [...]
Ensurepass  QUESTION 21 You have a regional sales report with State, City and Sales Revenue dimensions. You want to create a variable that excludes State from the output context. Which output statement should you use?   A. In([State]) B. Out([State]) C. ForAll([State]) D. ForEach([State])   Answer: C     QUESTION 22 Which three statements are true about alerters?   A. You can apply alerters to charts. B. You can apply multiple alerters to one block. Read more [...]
Ensurepass  QUESTION 11 What is the maximum number of sub-alerts that an alerter can contain?   A. 1 B. 8 C. 16 D. 32   Answer: B     QUESTION 12 You are creating a "Target Revenue Based on Required % Growth" variable that is represented by 5% revenue growth for California and 18% for Massachusetts. Which If() function statement is valid?   A. =If[State] = "California" Then [Sales revenue] * 1.05 Else[State] = "Massachusetts" Then [Sales revenue] * Read more [...]
Ensurepass    Exam A   QUESTION 1 Which method should you use to store a Web Intelligence Rich Client document in an enterprise secured location?   A. Save the document to the Enterprise directories B. Save the document to the Enterprise documents. C. Export the document to the Central Management Server (CMS). D. Export the document to the Central Configuration Manager (CCM).   Answer: C     QUESTION 2 In which two situations should you use sub-queries? Read more [...]