SAP BW Questions

Where is a Web Intelligence variable stored?

A. In the document

B. In the Central Management Server (CMS)

C. In the Metadata Cube

D. In the cell

Which method should you use to group query filters together to form one AND statement?

A. Select the filters, then click the Group Filters button on the toolbar

B. Select the filters, right-click and select Group

C. Drag the queries together

D. Drag the query filters to the Group panel

What is the primary purpose of having multi-dimensional data models?

A. To deliver structured information that the business user can easily navigate by using any possible combination of business terms to show the KPIs.

B. To make it easier for developers to build applications, that will be helpful for the business users.

C. To make it easier to store data in the database and avoid redundancy.

D. All the above

Criteria for selecting PSA and IDOC methods for Data Transfer

A. Load performance.
B. Query performance.
C. Volume of Data.

What happens when you drop a dimension into a blank part of a report that contains two blocks, without the ALT key selected?

A. The currently selected cell is displayed.

B. A new section is created

C. A new block is created.

D. An error message is displayed.

Which message appears when you select Use query drill while Scope of Analysis is set in a BusinessObjects Web Intelligence XI 3.0 report?

A. The Scope of Analysis is empty

B. The query drill mode option is enabled

C. The query drill mode option is not enabled

D. The Scope of Analysis is not empty

Which two operators are available when using wildcards in a query filter? (Choose two.)

A. Matches Pattern

B.  LIKE

C. Different from Pattern

D. Not equals Pattern

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?

A. Click the Undo button in the Query panel.

B. Rebuild the filters.

C. Close the Query panel without executing and then open the query

D. From the Tools menu, select Recover Operator.