C_BOWI_42 Online Practice Questions and Answers

Where do you view merged dimensions? Please choose the correct answer. Response:

A. In the Report Map pane

B. In the Available Objects pane

C. In the Document Structure and Filters pane

D. In the Query panel

Which Report Manager tab should you use to change report formatting?

Please choose the correct answer.

Response:

A. Map

B. Data

C. Properties

D. Templates

How do you duplicate a query? Please choose the correct answer. Response:

A. Choose Duplicate Query in the Tools Menu

B. Select Duplicate Query in Properties in the Query Panel

C. Right-click Query in the Report Manager and select Duplicate Query

D. Right-click the Query Tab in the Query Panel and select Duplicate Query

You are creating a "Target Revenue Based on Required % Growth" variable that is represented by 5% revenue growth for California and 18% for Massachusetts. Which If() function statement is valid?

Please choose the correct answer.

Response:

A. =If[State] = "California" Then [Sales revenue] * 1.05 Else[State] = "Massachusetts" Then [Sales revenue] * 1.18 Else [Sales revenue]

B. =If[State] = "California" Then [Sales revenue] * 1.05 ElseIf[State] = "Massachusetts" Then [Sales revenue] * 1.18 Else [Sales revenue]

C. =If[State] = "California" ; [Sales revenue] * 1.05 ElseIf[State] = "Massachusetts" Then [Sales revenue] * 1.18 Else [Sales revenue]

D. =If[State] = "California" Then [Sales revenue] * 1.05 ElseIf[State] = "Massachusetts" Then [Sales revenue] * 1.18 Else [Sales revenue] End

Where are contexts created? Please choose the correct answer. Response:

A. In a report

B. In a universe

C. In a derived table

D. At the database level

Which two locations can you use to set the drill options? There are 2 correct answers to this question. Response:

A. Report Properties

B. Query Panel Properties

C. Preferences in InfoView

D. Scope of Analysis Properties

E. Tools/Options in Web Intelligence Rich Client

Which two operators can you use with output context in the Web Intelligence Rich Client?

There are 2 correct answers to this question.

Response:

A. In

B. Out

C. ForAll

D. Output

Which BusinessObjects Enterprise tool supports Offline Mode logins? Please choose the correct answer. Response:

A. InfoView

B. Java Panel

C. Interactive Panel

D. Web Intelligence Rich Client

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

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])