SAP SAP Certifications C_BOWI_42 Questions & Answers

• Question 231:

  How do you allow a user to type a value for a prompt? (2 answers)

  A. Deselect the "Prompt with list of values" property.

  B. Deselect the "Select only from list" property.

  C. Deselect the "Set default values" property.

  D. Select the "Optional prompt" property.

  Correct Answer: AB

• Question 232:

  Your data source has the following values: SMITH, SMYTH, SMALL, SMOOTH, SMART, SMILEY. What syntax do you use to show only the names SMITH and SMYTH?

  A. SM%TH

  B. SM*TH

  C. SM_TH

  D. SMand

  Correct Answer: C

• Question 233:

  Which of the following can you use to filter results dynamically? (2 answers)

  A. Results Object pane

  B. Element linking

  C. Input control

  D. Report map

  Correct Answer: BC

• Question 234:

  What data source can you select when creating a document using the Web Intelligence Rich Client? (2 answers)

  A. BEx Query

  B. XML files

  C. Lumira Dataset

  D. Analysis view

  Correct Answer: AD

• Question 235:

  You have a document that includes a shared element. How do you ensure that the document includes the most current version of the shared element?

  A. Enable the "Check for Shared Element update on open".

  B. Set the document to "Refresh on open".

  C. Schedule the document.

  D. Update the shared element in the document-

  Correct Answer: D

• Question 236:

  In the Annual Revenue column, what formula calculates the total annual revenue in each row (shown in the attached graphic)?

  A. =sum([Sales revenues] In([Year])) In ([Quarter])

  B. =sum([Sales revenues] In([Year];[Quarter])) In ([Quarter])

  C. =sum([Sales revenues] In([Year];[Quarter]))

  D. =sum([Sales revenues] In([Year];[Quarter])) In ([Year])

  Correct Answer: D

• Question 237:

  Why is the subtotal missing from the bottom of each break in the attached diagram?

  A. The default aggregation on the measure is delegated.

  B. The report is NOT sectioned by year.

  C. The break footers display option is NOT selected.

  D. The calculation was applied to the table before the break.

  Correct Answer: D

• Question 238:

  To what can you apply conditional formatting rules (2 answers)

  A. Data in a chart

  B. Data in a section header cell

  C. Data in a table

  D. Data in a query filter

  Correct Answer: BC

• Question 239:

  What is the required argument of the UserResponse( ) function?

  A. Report name

  B. Dimension

  C. Prompt_string

  D. Measure

  Correct Answer: C

• Question 240:

  How can you change the data source of a document with multiple queries?

  A. Use the Change Source Wizard to change the queries one at a time.

  B. Use the Change Source Wizard to change the queries all at once.

  C. Use the query panel to remap the objects to a new data source.

  D. Use the query panel to duplicate the queries and map them to a new data source.

  Correct Answer: A