New Year Special 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: save70

Free and Premium SAP C_BOWI_43 Dumps Questions Answers

Page: 1 / 8
Total 1 questions

SAP Certified Application Associate - SAP BusinessObjects Web Intelligence 4.3 Questions and Answers

Question 1

Discuss the instructions appropriate for how you want the data in a table and manipulate the data within the table

There are 2 correct answers to this question

Response:

Options:

A.

Right-click the table and, from the contextual menu, select Copy

B.

In the target document, right-click the section cell and, from the contextual menu, click Copy and paste

C.

Drag and drop the table from Web Intelligence to the target application

D.

In the target application, right-click the area where you want the table to appear and, from the contextual menu, select Paste

Buy Now
Question 2

Where in Web Intelligence Rich Client interface can you see the data source for a document built on a local data source?

Please choose the correct answer.

Response:

Options:

A.

Global Settings

B.

Report Settings

C.

Query Properties

D.

Document Properties

Question 3

Which statement is true of the Where operator when used within a variable?

Please choose the correct answer.

Response:

Options:

A.

It instructs the variable to calculate only where certain values are true.

B.

It modifies the HAVING clause of the SQL generated to calculate the measure expression.

C.

It modifies the WHERE clause of the SQL generated to calculate the measure expression.

D.

It is not necessary to place parentheses around the values listed after the Where operator.

Question 4

Which Report Manager tab should you use to add a free-standing cell to a BusinessObjects Web Intelligence 4.0 document (WID)?

Please choose the correct answer.

Response:

Options:

A.

Map

B.

Data

C.

Template

D.

Properties

Question 5

How does WHERE operator affect a formula?

Options:

A.

It adds the dimension to the default context.

B.

It removes the dimension from the default context.

C.

It determines the order of the results.

D.

It restricts the dimension used to calculate a measure.

Question 6

What happens if an operational prompt is blank when you execute a query?

Options:

A.

The query filter is ignored.

B.

The query returns an empty record set.

C.

The query is filtered by the default value of the prompt.

D.

The query is filtered by the last value selected.

Question 7

For what purposes can you use the Page Layout of a report?

There are 2 correct answers to this question.

Response:

Options:

A.

To display the definition of the block.

B.

To define how the report will look like in PDF mode.

C.

To define how the report will look like when printed.

D.

To display the report page by default.

Question 8

Which two properties can you set in the hyperlink dialog box when you create a hyperlink to a document?

There are 2 correct answers to this question.

Response:

Options:

A.

Refresh on open

B.

Color and font style for the link

C.

Drill level for the target document

D.

Link to a specific area in the document

Question 9

Which operators can be used in an Input calculation context?

There are 2 correct answers to this question.

Response:

Options:

A.

Input

B.

ForAll

C.

ForEach

D.

In

Question 10

Explain the different types of data changes that Web Intelligence can highlight with the data tracking feature?

There are 2 correct answers to this question

Response:

Options:

A.

Multiple data

B.

Duplicate data

C.

Removed data

D.

Modified data

Question 11

Which method should you use to activate "Interactive Viewing"?

Please choose the correct answer.

Response:

Options:

A.

Preferences in Web Intelligence

B.

Preferences in InfoView

C.

In the Document Properties

D.

In the Report Properties

Question 12

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

Please choose the correct answer.

Response:

Options:

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.

Question 13

Elucidate the advantages of saving formulas as variables?

Please choose the correct answer.

Response:

Options:

A.

Use as options available in the Format and Report Element toolboxes

B.

You can reuse the formula without having to enter it each time

C.

Create the formulas and feed it with all its dimensions

D.

Use variables in any report within the document

Question 14

Which three types of local data files can you use to create a BusinessObjects Web Intelligence 4.0 document (WID)?

There are 3 correct answers to this question.

Response:

Options:

A.

TXT

B.

XML

C.

CSV

D.

XLS

Question 15

What items can be presented in a free-standing cell? (2 answers)

Options:

A.

Page numbers

B.

Last refresh date

C.

Bar charts

D.

Vertical tables

Question 16

You create a document with data from multiple data providers. Which two tasks can you perform to include all data from all providers in the same report block?

There are 2 correct answers to this question.

Response:

Options:

A.

Synchronize the data providers.

B.

Manually merge all dimensions.

C.

Synchronize the data providers SQL.

D.

Manually merge the parent dimensions.

Question 17

In what application mode can you freeze column headers?

Please choose the correct answer.

Response:

Options:

A.

Data

B.

Design, With Data

C.

Reading

D.

Design, Structure Only

Question 18

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

There are 2 correct answers to this question.

Response:

Options:

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.

Question 19

To where can you copy a formula used in a document?

Please choose the correct answer.

Response:

Options:

A.

To another block on a report

B.

To the Available Objects panel

C.

To a conditional formatting rule

D.

To the universe

Question 20

Which of the following is not a rule to apply on the report elements?

Please choose the correct answer.

Response:

Options:

A.

Columns in vertical tables

B.

Rows in horizontal tables

C.

Cells in conditional tables

D.

Cells in forms and cross tables

Question 21

You insert the function CurrentDate() into a cell. To clarify the date you add a string so that the formula is now:

="Sales Report from "+CurrentDate()

Which formatting capability is disabled for the cell?

Please choose the correct answer.

Response:

Options:

A.

Format cell

B.

Hide cell

C.

Align text

D.

Format number

Question 22

What does the Change Source Wizard use to remap existing objects to a new data source? (2 answers)

Options:

A.

Data type

B.

Object name

C.

Description

D.

Cluster Unique Identifier (CUID)

Question 23

Which two locations can you use to set the drill options?

There are 2 correct answers to this question.

Response:

Options:

A.

Report Properties

B.

Query Panel Properties

C.

Preferences in InfoView

D.

Scope of Analysis Properties

E.

Tools/Options in Web Intelligence Rich Client

Question 24

Name the types of query filters that you can use in Web Intelligence?

There are 3 correct answers to this question

Response:

Options:

A.

Validate query filter

B.

Designer query filters

C.

Predefined query filters

D.

Single and multi-value filters

E.

Prompted filters

Question 25

What happens when you drop a dimension into a blank part of a report that contains two blocks, without the ALT key selected?

Please choose the correct answer.

Response:

Options:

A.

A new block is created.

B.

A new section is created.

C.

An error message is displayed.

D.

The currently selected cell is displayed.

Question 26

Which two statements are correct about saving documents?

There are 2 correct answers to this question.

Response:

Options:

A.

They are stored in folders.

B.

They are stored in categories.

C.

They can be assigned to a folder.

D.

They can be assigned to a category.

Question 27

Which two panels can you use to purge data from a BusinessObjects Web Intelligence 4.0 document (WID)?

There are 2 correct answers to this question.

Response:

Options:

A.

Query

B.

Report

C.

Active X

D.

Slice and Dice

Question 28

Which method should you use to force each section of a report to start on a new page?

Please choose the correct answer.

Response:

Options:

A.

Select the section, Press CTRL-Enter.

B.

Right-click the section, select "Start Section on New Page".

C.

Select the section; in the Properties tab, check "Start on New Page".

D.

Select the section; click Report > Section and select "Start on New Page".

Question 29

Which two are limitations of a detail object?

There are 2 correct answers to this question.

Response:

Options:

A.

It cannot be drilled on.

B.

It cannot be used in the report filter.

C.

It cannot be merged in a document.

D.

It cannot be used in the WHERE statement of the query.

Question 30

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?

Please choose the correct answer.

Response:

Options:

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.

Question 31

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?

Options:

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.

Question 32

Which three options appear in the Scope of Analysis pane in the Query panel?

There are 3 correct answers to this question.

Response:

Options:

A.

None

B.

Default

C.

Custom

D.

One Level

Page: 1 / 8
Total 1 questions