SAP SAP BO C_BOWI_41 Questions & Answers

• Question 41:

  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?

  A. =RunningSum([Sales Revenue], Region)

  B. =RunningTotal([Sales Revenue], Region)

  C. =RunningSum([Sales Revenue] ; ([Region]))

  D. =RunningTotal([Sales Revenue], Reset[Region])

  Correct Answer: C

• Question 42:

  Which two are calculation context types?

  A. Input

  B. Output

  C. Logical

  D. Conditional

  Correct Answer: AB

• Question 43:

  What automatically happens when you create a chart using the Templates tab in Web Intelligence?

  A. Data is filtered using template dimensions.

  B. Structure mode is selected.

  C. Data is displayed on the report page.

  D. Select Objects dialog box opens.

  Correct Answer: B

• Question 44:

  Which method should you use to activate data tracking?

  A. Select the "Track" button on the toolbar.

  B. In the Query panel, enable "Keep History".

  C. In the InfoView Preferences, enable "Track Data Changes".

  D. Right-click the column in the report and select "Activate Data Tracking".

  Correct Answer: A

• Question 45:

  Why would you use the FormatDate() function?

  A. To modify the format of a string object into a non-standard date format.

  B. To convert a string object into a date object.

  C. To convert a date object into a string object.

  D. To format a date so that it is displayed as a string when it is concatenated with another string.

  Correct Answer: CD

• Question 46:

  Which two are benefits of creating queries from existing queries?

  A. Improved query security

  B. Accurate duplication of query parameters

  C. Improved performance of query execution

  D. Reduced creation time for complex reports

  Correct Answer: BD

• Question 47:

  Which BusinessObjects Enterprise tool supports Offline Mode logins?

  A. InfoView

  B. Java Panel

  C. Interactive Panel

  D. Web Intelligence Rich Client

  Correct Answer: D

• Question 48:

  Which panel should you use to create sub-queries?

  A. Data Panel

  B. Query Panel

  C. Report Panel

  D. Slice and Dice Panel

  Correct Answer: B

• Question 49:

  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.

  Correct Answer: BC

• Question 50:

  Which two options can you change when using Quick Display Mode?

  A. Limit Query Results

  B. Sample Query Results

  C. Vertical Records Per Page

  D. Horizontal Records Per Page

  Correct Answer: CD