SAP C_BOWI_41 Online Practice Questions and Exam Preparation

SAP C_BOWI_41 Online Questions & Answers

• Question 121:

  You set the drill option "Prompt when drill requires additional data". Now you drill outside the scope of analysis on your report. How does Web Intelligence respond?

  A. It prompts you to choose a hierarchy level and waits for your response before retrieving the data.
  B. It notifies you that it needs to retrieve additional data to complete the drill and retrieves the data.
  C. It inserts a prompted query filter in the query and reruns the query.
  D. It inserts a prompted report filter on the report and refreshes the report view.
  A. It prompts you to choose a hierarchy level and waits for your response before retrieving the data.

• Question 122:

  Which two methods can you use to aggregate measures at the section level in BusinessObjects Web Intelligence 4.0?

  A. Drag the measure from the Data tab into the section header.
  B. Copy the measure from the Data tab into the section header.
  C. While pressing the ALT key, drag the measure from the table to the section header.
  D. While pressing the CTRL key, drag the measure from the table to the section header.
  A. Drag the measure from the Data tab into the section header.
  D. While pressing the CTRL key, drag the measure from the table to the section header.

• Question 123:

  Which three data sources can you synchronize in a Web Intelligence 4.0 document (WID)?

  A. Personal data files
  B. Stored procedure data source
  C. Queries from the same universe
  D. Queries from different universes
  A. Personal data files
  C. Queries from the same universe
  D. Queries from different universes

• Question 124:

  You try to select a number of data objects from the Data tab to drag into a report, but some of them are grayed out and in italics. Which statement explains this behavior?

  A. Some of the selected objects are restricted.
  B. Some of the selected objects are not synchronized.
  C. Some of the selected objects have different data formats.
  D. Some of the selected objects do not have different data types.
  B. Some of the selected objects are not synchronized.

• Question 125:

  In which two situations should you use sub-queries?

  A. When the query filter involves values that are known
  B. When the query filter involves values that are not known
  C. When the query filter for the report involves a value that will change over time
  D. When the query filter for the report involves a value that will never change over time
  B. When the query filter involves values that are not known
  C. When the query filter for the report involves a value that will change over time

• Question 126:

  Which two settings can you configure for the Sample option in the Properties tab of the Web Intelligence Query panel?

  A. You can enable the "Fixed" option.
  B. You can set the "Max retrieval time".
  C. You can set the "Max rows retrieved".
  D. You can specify a "Sample Result" set.
  A. You can enable the "Fixed" option.
  D. You can specify a "Sample Result" set.

• Question 127:

  Which DaysBetween() function syntax should you use to calculate the number of years since your birth, assuming the date object is Birth_date?

  A. =DaysBetween([Birth_date] ; CurrentDate ) / 365.25
  B. =DaysBetween([Birth_date] , CurrentDate() ) / 365.25
  C. =DaysBetween([Birth_date] ; CurrentDate() ) / 365.25
  D. =DaysBetween(CurrentDate() ; [Birth_date] ) / 365.25
  C. =DaysBetween([Birth_date] ; CurrentDate() ) / 365.25

• Question 128:

  You have a regional sales report with State, City and Sales Revenue dimensions. You want to create a variable that excludes State from the output context.

  Which output statement should you use?

  A. In([State])
  B. Out([State])
  C. ForAll([State])
  D. ForEach([State])
  C. ForAll([State])

• Question 129:

  You want to force the calculation context of a variable in a table so thatits values do not change when adimension is added to the table. Which of the following statements is correct?

  A. You include the dimension using the input context.
  B. You exclude the dimension using the input context.
  C. You include the dimension using the output context.
  D. You exclude the dimension using the output context.
  D. You exclude the dimension using the output context.

• Question 130:

  Which object types can you merge when using Multi Queries in a Web Intelligence document (WID)?

  A. Dimension - Detail
  B. Measure - Measure
  C. Dimension -Measure
  D. Dimension - Dimension
  D. Dimension - Dimension