Which two statements are true about the AND operator? (2) Used when only one condition is met by any of the filters Used when all conditions are met by two filters Used when any condition is met by two filters Used when all conditions are met by more than two filters.
How do you duplicate a query? Choose Duplicate Query in the Tools Menu Right-click the Query Tab in the Query Panel and select Duplicate Query Select Duplicate Query in Properties in the Query Panel Right-click Query in the Report Manager and select Duplicate Query.
Which two settings can you configure for the Sample option in the Properties tab of the Web Intelligence Query panel? (2) You can enable the "Fixed" option. You can specify a "Sample Result" set. You can set the "Max rows retrieved". You can set the "Max retrieval time".
Which methods can you use to apply report filters to a BusinessObjects Web Intelligence XI 4.x document (WID)? (2) Dynamic Block Global Custom.
Where can you set the priority options for saving a Web Intelligence document (WID) to Microsoft Excel? Web Intelligence Rich Client Microsoft Excel File Options Web Intelligence InfoView Preferences.
Which operator should you use to control the output context of a calculation that is relevant to the different environment levels within your document? ForEach ForAll In Out.
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? In([State]) ForAll([State]) ForEach([State]) Out([State]).
Which operators can be used in an Input calculation context? (2) Input ForAll In ForEach.
In the Query Panel, you can view and modify the default query properties. The query properties allow you to perform following actions, identify the correct answers from the following options? (2) Restrict the retrieval of duplicate data rows Set Multiple security options in the query panel Improve- numerical data in the report Control potential ambiguous query results.
You insert the function CurrentDate() into a cell. To clarify the date you add a string so that the formula is now:
="Sales Report from "+CurrentDate()
Which formatting capability is disabled for the cell? Format cell Format number Hide cell Align text.
|
