SAP C_BOWI_41 Online Practice Questions and Exam Preparation

SAP C_BOWI_41 Online Questions & Answers

• Question 1:

  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?

  A. 1.00
  B. 1.05
  C. 1.10
  D. 1.15
  E. 1.18
  A. 1.00

• Question 2:

  Which two are limitations of a detail object?

  A. It cannot be drilled on.
  B. It cannot be used in the report filter.
  C. It cannot be merged in a document.
  D. It cannot be used in the WHERE statement of the query.
  A. It cannot be drilled on.
  C. It cannot be merged in a document.

• Question 3:

  Which three are prerequisites for combining data from multiple data providers?

  A. There are two or more queries in your document.
  B. Both data providers must have the same dimension values.
  C. Data values from each linked dimension must have a common format.
  D. Object name from different universes in both data providers must be the same.
  A. There are two or more queries in your document.
  B. Both data providers must have the same dimension values.
  C. Data values from each linked dimension must have a common format.

• Question 4:

  Which function would you use to extract the word "pants" from the product name "casual pants" of the Product Name field?

  A. Right(5; [Product Name])
  B. Right([Product Name]; 5)
  C. Right((Product Name), 5)
  D. Right(5, [Product Name])
  B. Right([Product Name]; 5)

• Question 5:

  Which two methods can you use to define document properties?

  A. Click the report tab, select "Document Properties" and enter the required information.
  B. Right-click the report tab, select "Document Properties" and enter the required information.
  C. Right-click a blank space on the report page, select "Document Properties" and enter the required information.
  D. In the Properties tab of the Report Manager, select "Document Properties" and enter the required information.
  B. Right-click the report tab, select "Document Properties" and enter the required information.
  C. Right-click a blank space on the report page, select "Document Properties" and enter the required information.

• Question 6:

  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. Rebuild the filters.
  B. Click the Undo button in the Query panel.
  C. From the Tools menu, select Recover Operator.
  D. Close the Query panel without executing and then open the query.
  A. Rebuild the filters.
  D. Close the Query panel without executing and then open the query.

• Question 7:

  Where are formulas stored when created in Web Intelligence?

  A. In the universe
  B. On the report page
  C. In the Central Management Server (CMS) database
  D. In the metadata of the Cube
  B. On the report page

• Question 8:

  Which panel should you use to view a Document Summary of a BusinessObjects Web Intelligence 4.0 document (WID)?

  A. Advanced
  B. Query
  C. Active X
  D. Interactive
  D. Interactive

• Question 9:

  Which two options are valid options when you save a Web Intelligence document (WID) in the Web Intelligence Rich Client?

  A. Save Query As
  B. Save As FTP
  C. Save As
  D. Save to My Computer As
  C. Save As
  D. Save to My Computer As

• Question 10:

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

  A. Drag the queries together
  B. Drag the query filters to the Group panel
  C. Select the filters, right-click and select Group
  D. Select the filters, then click the Group Filters button on the toolbar
  A. Drag the queries together