C_BOWI_30 - SAP Certified Application Associate - SAP BusinessObjects Web Intelligence XI 3.x

Go back to SAP

Example Questions

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? You try to select a number of data objects from the Data tab to drag into a report, but some of them are grayed out and in italics. Which statement explains this behavior? Your document displays all data in black. Which dialog box should you use to configure the colors of your document data? 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? Which two operators are used as calculation context operators? (Choose two.) Which two options should you take before you finish creating a variable in Web Intelligence? (Choose two.) Which method should you use to force each section of a report to start on a new page? Which two statements are true of grouping sets when using smart measures? (Choose two.) Which three statements are true about alerters? (Choose three.) Which tab should you use to change the page orientation of a report? Where do you set the "Optional prompt" option in Web Intelligence Rich Client? Which method can you use to change the object qualification of an object within Web Intelligence Rich Client? 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? 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? Which three calculations can you use in a measure object in Web Intelligence? (Choose three.) Which two functions could you use to concatenate the First Name and Last Name objects? (Choose two.) How do you duplicate a query? Which three statements are true of calculation contexts? (Choose three.) Which two Web Intelligence Rich Client authentication methods enable you to export Web Intelligence documents (WID) to the Central Management Server (CMS)? (Choose two.) Which method should you use to view alerts in a report? You are using calculation contexts within an If() function. Which two are valid contexts for use in an If() function? (Choose two.) Which scenarios should you use breaks for? (Choose two.) 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? Which three types of local data files can you use to create a BusinessObjects Web Intelligence XI 3.0 document (WID)? (Choose three.) In which two situations should you use sub-queries? (Choose two.) Which two statements are true of contexts? (Choose two.) Which message appears when you select "Use query drill" while Scope of Analysis is set in a BusinessObjects Web Intelligence XI 3.0 report? Which two operators can you use with output context in the Web Intelligence Rich Client? (Choose two.) Which two statements about the If() function are correct? (Choose two.) Which two functions can you use to concatenate the strings "England" and "New" to create the string "New England"? (Choose two.) Which BusinessObjects Enterprise tool supports Offline Mode logins? Which option can you use to convert a table block into a chart in Web Intelligence Rich Client? Which two are running aggregate functions in Web Intelligence? (Choose two.) Which two data sources can you directly access from a Web Intelligence document (WID) using the Web Intelligence Rich Client? (Choose two.) 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? Which two statements are true of the Web Intelligence default behavior when performing a UNION combined query method? (Choose two.) How much impact does data tracking have on the data size of a Web Intelligence document (WID) Compared to the same document without data tracking? Which three statements are true of contexts? (Choose three.) Which three options are valid Page Layout Options in the Properties tab of a document? (Choose three.) Where can you set the default universe when using Web Intelligence within InfoView? Which two are limitations of a detail object? (Choose two.) Which two are benefits of creating queries from existing queries? (Choose two.) Which method should you use to activate data tracking? Which statement describes a Web Intelligence variable? Which three rules apply when you manually synchronize queries? (Choose three.) You are working in the Web Intelligence Rich Client. Which two file formats can you save a document in? (Choose two.) Which three are drill options? (Choose three.) Which is a benefit of using query drill? Which two methods can you use to define document properties? (Choose two.) Which two methods can you use to apply report filters to a BusinessObjects Web Intelligence XI 3.0 document (WID)? (Choose two.)