C_BOWI_30 - SAP Certified Application Associate - SAP BusinessObjects Web Intelligence XI 3.x
Go back to SAP
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?
=RunningSum([Sales Revenue] ; ([Region]))
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?
Some of the selected objects are not synchronized.
Your document displays all data in black. Which dialog box should you use to configure the colors of your document data?
Data Tracking Options
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?
Select the section; in the Properties tab, check "Start on New Page".
Which two statements are true of grouping sets when using smart measures? (Choose two.)
It is a set of dimensions that generates a result for a measure.
The generated SQL includes grouping sets for all the aggregations of that measure that are included in the report.
Which three statements are true about alerters? (Choose three.)
You can apply multiple alerters to one block.
You can apply the same alerter to multiple blocks.
You can control the order in which alerters are applied.
Which tab should you use to change the page orientation of a report?
Select the report page; in Report Manager, select the "Properties" tab and select the "Page Orientation"
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?
In the Query panel, select the qualification.
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?
The cell reads "Last Refresh Date: 1/22/08".
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?
=If[State] = "California" Then [Sales revenue] * 1.05 ElseIf[State] = "Massachusetts" Then [Sales revenue]* 1.18 Else [Sales revenue]
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.)
=[First Name]+[Last Name]
=Concatenation([First Name];[Last Name])
How do you duplicate a query?
Right-click the Query Tab in the Query Panel and select Duplicate Query
Which three statements are true of calculation contexts? (Choose three.)
If no context is defined the default context is assumed.
The ForEach context operator automatically takes the dimensions in the block into account.
You must place parentheses around the values listed after the Where keyword when using the Where operator.
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?
Select a block; on the toolbar, click the "Alerters" button
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.)
Generating subtotals in one table block
Grouping repeated values in one table block
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.)
When the query filter involves values that are not known
When the query filter for the report involves a value that will change over time
Which two statements are true of contexts? (Choose two.)
You can combine objects in different contexts.
You can combine any object within the same context to create a query.
Which message appears when you select "Use query drill" while Scope of Analysis is set in a BusinessObjects Web Intelligence XI 3.0 report?
The Scope of Analysis is not empty.
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.)
Contains a Boolean expression
Can contain nested If() statements
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?
Web Intelligence Rich Client
Which option can you use to convert a table block into a chart in Web Intelligence Rich Client?
Right-click the table block and select "Turn To"
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.)
It performs a UNION.
It returns all values less the duplicates.
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?
It will increase two times.
Which three statements are true of contexts? (Choose three.)
Contexts are defined in a universe.
You can combine objects in different contexts.
You can combine any objects within the same context to create a query.
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.)
It cannot be drilled on.
It cannot be merged in a document.
Which two are benefits of creating queries from existing queries? (Choose two.)
Accurate duplication of query parameters
Reduced creation time for complex reports
Which method should you use to activate data tracking?
Select the "Track" button on the toolbar.
Which statement describes a Web Intelligence variable?
A variable is a formula with a name stored in the document.
Which three rules apply when you manually synchronize queries? (Choose three.)
Dimension value formats must be the same.
Dimensions with different names can be merged.
Dimensions from multiple data sources can be merged.
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.)
Hide drill toolbar
Prompt if drill requires additional data
Synchronize drill on report blocks
Which is a benefit of using query drill?
Dedicated SQL statements are generated for each drill.
Which two methods can you use to define document properties? (Choose two.)
Right-click the report tab, select "Document Properties" and enter the required information.
Right-click a blank space on the report page, select "Document Properties" and enter the required information.
Which two methods can you use to apply report filters to a BusinessObjects Web Intelligence XI 3.0 document (WID)? (Choose two.)