Free SAP C-BOWI-42 Exam Dumps Questions & Answers

What options are available when linking to another document? (2 answers)

• A.  Refresh on open
• B.  Target an area within the document
• C.  Change data source
• D.  Combine queries

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.  Update the shared element in the document-
• B.  Enable the "Check for Shared Element update on open".
• C.  Set the document to "Refresh on open".
• D.  Schedule the document.

What do you use to search for content in multiple documents?

• A.  BI launch pad
• B.  Central Configuration Manager (CCM)
• C.  Report map
• D.  Central Management Console (CMC)

How can you combine Microsoft Excel spreadsheet data with universe query data?

• A.  Filter the universe query using subqueries.
• B.  Extend the universe query using a scope of analysis
• C.  Merge dimensions from two data sources.
• D.  Combine the data using a minus query.

A table contains a dimension [CITY] and a measure [SALES]. You insert a column to display the formula AVERAGE([SALES]). Which operator do you add to the formula so that it displays the average for the table in every row? (2 answers)

• A.  In Body
• B.  For AII ([CITY])
• C.  ForEach ([CITY])
• D.  In Block