SAP c-bowi-43 practice test

SAP Certified Application Associate - SAP BusinessObjects Web Intelligence 4.3 Exam


Question 1

A document displays a data in the format: MM/DD/YY. What option allow you to change the format
to DD/MM/YY? (2 answers)

  • A. Auto detect
  • B. Format number
  • C. Product locale
  • D. Preferred viewing locale
Answer:

B, D

Discussions

Question 2

Why do you use the "Turn into" functionality?

  • A. To change the data source of a document
  • B. To change the table into a chart
  • C. To change the object of a section
  • D. To change the data type of an object
Answer:

B

Discussions

Question 3

What is the output of the following expression when the CurrentDate is January 31, 2014?
If (MonthNumberOfYear(CurrentDate())=1;
Year(CurrentDate())-1;
Year(CurrentDateQ))

  • A. 2014
  • B. 01/31/2014
  • C. 01/31/2013
  • D. 2013
Answer:

D

Discussions

Question 4

You have applied report filters to your document. How do you ensure that end users are aware of this
when viewing a document in Reading mode?

  • A. Display prompt values in free-standing cells.
  • B. Display the Report filters in free-standing cells.
  • C. Display predefined filters in free-standing cells.
  • D. Display the Query Summery in a free-standing cell.
Answer:

B

Discussions

Question 5

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

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

D

Discussions

Question 6

What option do you select to change the Total Revenue to a currency (shown in the attached
graphic)?

A.
1. Right click a number in the Total Revenue column.
2. Select Format Number.
B.
1. Right click the Total Revenue column name.
2. Select Format Number.
C.
1. Right click on the edge of the table.
2. Select Format Table.
D.
1. Right click a number in the Total Revenue column.
2. Select Format Cell.

Answer:

D

Discussions

Question 7

Which data sources can you access directly using Web Intelligence?

  • A. Relational databases
  • B. Business Explorer (BEx) Queries
  • C. XML files
  • D. OLAP cubes
Answer:

B

Discussions

Question 8

What is the correct formula for the RunningSum column (shown in the attached graphic)?

  • A. RunningSum([Sales revenues];([Year];[Quarter]))
  • B. RunningSum([Sales revenues];[Year];[Quarter])
  • C. RunningSum([Sales revenues];([Year]))
  • D. RunningSum([Sales revenues] in [Quarter])
Answer:

C

Discussions

Question 9

When using the ranking feature on a table, which expression allows you to display the total of all
values (both ranked and unranked) in the footer of the block?

  • A. NoFilter(Sum([measure]))
  • B. Sum([measure) For Each [dimension])
  • C. Sum([measure]) In Block
  • D. RefValue(Sum([measure]))
Answer:

A

Discussions

Question 10

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

  • A. Analysis view
  • B. XML files
  • C. BEx Query
  • D. Lumira Dataset
Answer:

A, C

Discussions
To page 2