SAP BO Multiple Choice Questions and Answers pdf for freshers and experienced
1. Which sort option should you use to add Temporary Values?
2. 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, 2008. What is the result when you edit the formula, using the Formula toolbar, to concatenate the string "Last Refresh Date: " and the LastExecutiondate() function?
3. Which two functions could you use to concatenate the First Name and Last Name objects?
4. Which panel should you use to create sub-queries?
5. Which panel should you use to view a Document Summary of a BusinessObjects Web Intelligence XI 3.0 document (WID)?
6. Which two statements are correct about saving documents?
7. Which three can you use to start the Web Intelligence Rich Client from?
8. Which Pos() function syntax should you use to find the location of the space in the Category string "Evening wear"?
9. Which three statements are true of contexts?
10. Which method should you use to group query filters together to form one AND statement?
11. In the creation of a document, you have to import a personal data file. The data file contains date information, but when the file is imported, the dates are imported as character strings. Which function should you use to change the format from string to date?
12. Which three options are valid Page Layout Options in the Properties tab of a document?
13. Which options can you select when you save a Web Intelligence document (WID)?
14. You are working in the Web Intelligence Rich Client. Which two file formats can you save a document in?
15. Which Web Intelligence viewer panel should you use to create links to documents by browsing to the file without typing any syntax?
16. You open a Web Intelligence document (WID) with tracked data changes. You wish to change the color of the tracked data. You however cannot change the format of the tracked data. What should you do to enable formatting of the tracked data?
17. Which two statements are true about the AND operator?
18. How many blocks can you create in a Web Intelligence document (WID)?
19. Which tool do you use to edit merged objects in Business Objects Web Intelligence XI 3.0?
20. Which is a benefit of using query drill?
21. Which two operators are used as calculation context operators?
22. Where can you set the default universe when using Web Intelligence within InfoView?
23. Which tab should you use to change the page orientation of a report?
24. Which three layout options can you use when creating sections in a report?
25. Which two are calculation context types?
26. 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?
27. Which three are drill options?
28. Which function would you use to extract the word "casual" from the product name "casual pants" of the Product Name field?
29. Which two locations can you use to set the drill options?
30. Which type of relationship links sub-queries by default?
31. You are creating a report to summarize the number of cars sold by region. Which object should you use to aggregate the number of cars sold?
32. Which statement is a benefit of using a Web Intelligence formula?
33. Which three data sources can you synchronize in a Web Intelligence XI 3.0 document (WID)?
34. What is the default behavior when creating a report from two queries from the same universe?
35. Where can you set the priority options for saving a Web Intelligence document (WID) to Microsoft Excel?
36. Where are formulas stored when created in Web Intelligence?
37. Which message appears when you select "Use query drill" while Scope of Analysis is set in a BusinessObjects Web Intelligence XI 3.0 report?
38. Your document displays all data in black. Which dialog box should you use to configure the colors of your document data?
39. Which statement describes the performance impact that data tracking has on report refresh times, assuming that the data changes but the number of rows retrieved and the data volume stays the same?
40. Which two statements describe reasons for using the FormatDate() function?
41. Which two statements are true of an ambiguous query?
42. Which method should you use to activate "Interactive Viewing"?
43. You are working with a previously saved document and you have deleted a logical operator.
Which two methods can you use to recover the logical operator?
44. Which four authentication methods are available for Web intelligence Rich Client?
45. Which Report Manager tab should you use to change report formatting?
46. Which three options are Web Intelligence drill mode options?
47. Which statement describes a benefit of using the NoFilter() function?
48. 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?
49. Which function would you use to extract the word "pants" from the product name "casual pants" of the Product Name field?
50. Which operator should you use to control the output context of a calculation that is relevant to the different environment levels within your document?
51. Which BusinessObjects Enterprise tool supports Offline Mode logins?
52. Which two methods can you use to aggregate measures at the section level in BusinessObjects Web Intelligence XI 3.0?
53. Which option can you use to convert a table block into a chart in Web Intelligence Rich Client?
54. Where in Web Intelligence Rich Client interface can you see the data source for a document built on a local data source?
55. What automatically happens when you create a chart using the Templates tab in Web Intelligence?
56. Which two are benefits of using breaks?
57. Which two statements are true of contexts?
58. What is the maximum number for alerts in a document?
59. Which method should you use to store a Web Intelligence Rich Client document in an enterprise secured location?
60. What happens when you drop a dimension into a blank part of a report that contains two blocks, without the ALT key selected?
61. Which two are running aggregate functions in Web Intelligence?
62. For what purposes can you use the Page Layout of a report?
63. Where should you configure the regional settings of a Web Intelligence document (WID) within InfoView?
64. Which three are prerequisites for combining data from multiple data providers?
65. Which two break properties can you use when setting Break Priority?
66. Which method should you use to activate data tracking?
67. Which two search criteria are valid when using Delegated List of Values?
68. For which tasks do you use an If() function?
69. You need to create a report that compares data to a reference data set. You create the report and activate the track data option. The report correctly indicates the changes in the data; however when you make another change to the report, the display no longer indicates any data tracking. What actions could have caused this behavior?
70. To which destinations can you send a Web Intelligence document (WID) through InfoView of BusinessObjects Web Intelligence XI 3.0?
71. Which three calculations can you use in a measure object in Web Intelligence?
72. Which three object types can you use in a Web Intelligence universe query?
73. 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, 2008. What is the result when you edit the formula, using the Formula toolbar, to concatenate the string "Last Refresh Date: " and the LastExecutiondate() function?
74. You need to create a report displaying a year-to-date aggregation on sales revenue across all months. The report should be sectioned on Region. Additionally, you would like to reset the running aggregation to restart for each Region. Which syntax should you use to accomplish this task?
75. Which method should you use to see report filters?
76. Which three methods can you use to apply a section in the Web Intelligence Rich Client?
77. Which scenarios should you use breaks for?
78. Which two character functions can modify character string and return the word "Department" from the string "Department Fast Foods"?
79. Which two options can you change when using Quick Display Mode?
80. Which three features can you use in Interactive View mode of BusinessObjects Web Intelligence XI 3.0?
1. Which sort option should you use to add Temporary Values?
2. 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, 2008. What is the result when you edit the formula, using the Formula toolbar, to concatenate the string "Last Refresh Date: " and the LastExecutiondate() function?
3. Which two functions could you use to concatenate the First Name and Last Name objects?
4. Which panel should you use to create sub-queries?
5. Which panel should you use to view a Document Summary of a BusinessObjects Web Intelligence XI 3.0 document (WID)?
6. Which two statements are correct about saving documents?
7. Which three can you use to start the Web Intelligence Rich Client from?
8. Which Pos() function syntax should you use to find the location of the space in the Category string "Evening wear"?
9. Which three statements are true of contexts?
10. Which method should you use to group query filters together to form one AND statement?
11. In the creation of a document, you have to import a personal data file. The data file contains date information, but when the file is imported, the dates are imported as character strings. Which function should you use to change the format from string to date?
12. Which three options are valid Page Layout Options in the Properties tab of a document?
13. Which options can you select when you save a Web Intelligence document (WID)?
14. You are working in the Web Intelligence Rich Client. Which two file formats can you save a document in?
15. Which Web Intelligence viewer panel should you use to create links to documents by browsing to the file without typing any syntax?
16. You open a Web Intelligence document (WID) with tracked data changes. You wish to change the color of the tracked data. You however cannot change the format of the tracked data. What should you do to enable formatting of the tracked data?
17. Which two statements are true about the AND operator?
18. How many blocks can you create in a Web Intelligence document (WID)?
19. Which tool do you use to edit merged objects in Business Objects Web Intelligence XI 3.0?
20. Which is a benefit of using query drill?
21. Which two operators are used as calculation context operators?
22. Where can you set the default universe when using Web Intelligence within InfoView?
23. Which tab should you use to change the page orientation of a report?
24. Which three layout options can you use when creating sections in a report?
25. Which two are calculation context types?
26. 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?
27. Which three are drill options?
28. Which function would you use to extract the word "casual" from the product name "casual pants" of the Product Name field?
29. Which two locations can you use to set the drill options?
30. Which type of relationship links sub-queries by default?
31. You are creating a report to summarize the number of cars sold by region. Which object should you use to aggregate the number of cars sold?
32. Which statement is a benefit of using a Web Intelligence formula?
33. Which three data sources can you synchronize in a Web Intelligence XI 3.0 document (WID)?
34. What is the default behavior when creating a report from two queries from the same universe?
35. Where can you set the priority options for saving a Web Intelligence document (WID) to Microsoft Excel?
36. Where are formulas stored when created in Web Intelligence?
37. Which message appears when you select "Use query drill" while Scope of Analysis is set in a BusinessObjects Web Intelligence XI 3.0 report?
38. Your document displays all data in black. Which dialog box should you use to configure the colors of your document data?
39. Which statement describes the performance impact that data tracking has on report refresh times, assuming that the data changes but the number of rows retrieved and the data volume stays the same?
40. Which two statements describe reasons for using the FormatDate() function?
41. Which two statements are true of an ambiguous query?
42. Which method should you use to activate "Interactive Viewing"?
43. You are working with a previously saved document and you have deleted a logical operator.
Which two methods can you use to recover the logical operator?
44. Which four authentication methods are available for Web intelligence Rich Client?
45. Which Report Manager tab should you use to change report formatting?
46. Which three options are Web Intelligence drill mode options?
47. Which statement describes a benefit of using the NoFilter() function?
48. 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?
49. Which function would you use to extract the word "pants" from the product name "casual pants" of the Product Name field?
50. Which operator should you use to control the output context of a calculation that is relevant to the different environment levels within your document?
51. Which BusinessObjects Enterprise tool supports Offline Mode logins?
52. Which two methods can you use to aggregate measures at the section level in BusinessObjects Web Intelligence XI 3.0?
53. Which option can you use to convert a table block into a chart in Web Intelligence Rich Client?
54. Where in Web Intelligence Rich Client interface can you see the data source for a document built on a local data source?
55. What automatically happens when you create a chart using the Templates tab in Web Intelligence?
56. Which two are benefits of using breaks?
57. Which two statements are true of contexts?
58. What is the maximum number for alerts in a document?
59. Which method should you use to store a Web Intelligence Rich Client document in an enterprise secured location?
60. What happens when you drop a dimension into a blank part of a report that contains two blocks, without the ALT key selected?
61. Which two are running aggregate functions in Web Intelligence?
62. For what purposes can you use the Page Layout of a report?
63. Where should you configure the regional settings of a Web Intelligence document (WID) within InfoView?
64. Which three are prerequisites for combining data from multiple data providers?
65. Which two break properties can you use when setting Break Priority?
66. Which method should you use to activate data tracking?
67. Which two search criteria are valid when using Delegated List of Values?
68. For which tasks do you use an If() function?
69. You need to create a report that compares data to a reference data set. You create the report and activate the track data option. The report correctly indicates the changes in the data; however when you make another change to the report, the display no longer indicates any data tracking. What actions could have caused this behavior?
70. To which destinations can you send a Web Intelligence document (WID) through InfoView of BusinessObjects Web Intelligence XI 3.0?
71. Which three calculations can you use in a measure object in Web Intelligence?
72. Which three object types can you use in a Web Intelligence universe query?
73. 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, 2008. What is the result when you edit the formula, using the Formula toolbar, to concatenate the string "Last Refresh Date: " and the LastExecutiondate() function?
74. You need to create a report displaying a year-to-date aggregation on sales revenue across all months. The report should be sectioned on Region. Additionally, you would like to reset the running aggregation to restart for each Region. Which syntax should you use to accomplish this task?
75. Which method should you use to see report filters?
76. Which three methods can you use to apply a section in the Web Intelligence Rich Client?
77. Which scenarios should you use breaks for?
78. Which two character functions can modify character string and return the word "Department" from the string "Department Fast Foods"?
79. Which two options can you change when using Quick Display Mode?
80. Which three features can you use in Interactive View mode of BusinessObjects Web Intelligence XI 3.0?
