Q60. Which three methods can you use to combine queries using the Web Intelligence Rich Client?
There are 3 correct answers to this question.
Response:

Q61. You are working with a set of store revenues. All stores have positive revenue values. Which formula should you use to display the variance value of the Revenue measure in your document when data tracking is active?
Please choose the correct answer.
Response:

Q62. Which two statements describe reasons for using the FormatDate() function?
There are 2 correct answers to this question.
Response:

Q63. Which of the following is not a rule to apply on the report elements?
Please choose the correct answer.
Response:

Q64. What is the maximum number of sub-alerts that an alerter can contain?
Please choose the correct answer.
Response:

Q65. Which type of relationship links sub-queries by default?
Please choose the correct answer.
Response:

Q66. Which two statements are true about the AND operator?
There are 2 correct answers to this question.
Response:

Q67. A variable in your report contains the statement:
=If[State] = “California” Then [Sales revenue] * 1.05 Else If[State] = “Colorado” Then [Sales revenue] *
1.1 Else If[State] InList (“DC”;”Texas “) Then [Sales revenue] * 1.15 Else If[State] = “Massachusetts” Then
[Sales revenue] * 1.18 Else [Sales revenue]
Sales revenue for Florida is $1,879,159. Which rate is applied to the Florida revenue by the formula?
Please choose the correct answer.
Response:

Q68. Which Pos() function syntax should you use to find the location of the space in the Category string “Evening wear”?
Please choose the correct answer.
Response:

Q69. For which tasks do you use an If() function?
There are 2 correct answers to this question.
Response:

Q70. Which two statements are true of grouping sets when using smart measures?
Please choose the correct answer.
Response:

Q71. What are the benefits of using SAP Business Objects Web Intelligence? (2 correct answers)

Q72. Which three options are Web Intelligence drill mode options?
There are 3 correct answers to this question.
Response:

Q73. Mention the five types of column charts for presenting DATA?
There are 3 correct answers to this question
Response:

Q74. Which two statements are true of the Web Intelligence default behavior when performing a UNION combined query method?
There are 2 correct answers to this question.
Response:

Q75. In the query panel, you modify the script and no errors occur. You remove an object and add a different object to the Result Object pane. What happens to the script?

Q76. Which three options are default page number cells?
There are 3 correct answers to this question.
Response:

Q77. Which two operators can you use with output context in the Web Intelligence Rich Client?
There are 2 correct answers to this question.
Response:

Q78. You use the Last Refresh Date cell from the Templates in the Report Manager on your report page. You then reformat the cell as Tuesday, January 22, 2014. What is the result when you edit the formula, using the Formula toolbar, to concatenate the string “Last Refresh Date: ” and the LastExecutiondate() function?
Please choose the correct answer.
Response:

Q79. In the Web Intelligence Desktop, when you save a document as an Excel file, you can specify which reports saving; Following are the options available to save and export data?
There are 2 correct answers to this question
Response:

Q80. Which four Report Elements can you select from the Templates tab of Web Intelligence?
There are 4 correct answers to this question.
Response:

Q81. Which three methods can you use to apply a section in the Web Intelligence Rich Client?
There are 3 correct answers to this question.
Response:

Q82. Where can you set the default universe when using Web Intelligence within InfoView?
Please choose the correct answer.
Response: