CertsTopics Logo

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

Free and Premium SAP C_BOWI_4302 Dumps Questions Answers

Page: 1 / 8
Total 218 questions
Get C_BOWI_4302 Full Access Download C_BOWI_4302 PDF

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

Question 1

You have two columns: order date and ship date. How do you calculate the processing time from the order date to the ship date?

Options:

A.

Use the "daynumberofyear" function after subtracting both dates.

B.

Use the "daysbetween" function with order date and ship date.

C.

Use the "currentdate" function and subtract the ship date.

D.

Use the "isdate" function on both dates and subtract the dates.

Buy Now
Question 2

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 3

Which two statements about the If() function are correct?

There are 2 correct answers to this question.

Response:

Options:

A.

Can contain a SQL statement

B.

Can contain a Case expression

C.

Contains a Boolean expression

D.

Can contain nested If() statements

Question 4

Identify from the correct option from the following - To Navigate from Section to Section?

Please choose the correct answer.

Response:

Options:

A.

The Report Element pane to work on one report to another and navigate from Multiple section

B.

The Report Map pane to jump from one cell to another and navigate one and two sections

C.

The Report Map pane to jump from one report to another and navigate from section to section

D.

The Report Element to jump from one section to another and navigate from column to row

Question 5

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 6

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 7

Which method can you use to build a custom sort?

Please choose the correct answer.

Response:

Options:

A.

Right-click the table, select "Custom Sort"

B.

Right-click the table, select "Sort" and select "Custom Sort"

C.

Select a column; on the toolbar, click the "Custom Sort" button

D.

Select a column; on the toolbar, click the "Apply Sort" button and select "Custom Sort"

Question 8

Why is the subtotal missing from the bottom of each break in the attached diagram?

Options:

A.

The report is NOT sectioned by year.

B.

The default aggregation on the measure is delegated.

C.

The calculation was applied to the table before the break.

D.

The break footers display option is NOT selected.

Question 9

Which two are running aggregate functions in Web Intelligence?

There are 2 correct answers to this question.

Response:

Options:

A.

RunningMax()

B.

RunningSum()

C.

RunningTotal()

D.

RunningMean()

Question 10

Which statement is a benefit of using a Web Intelligence formula?

Please choose the correct answer.

Response:

Options:

A.

The formula can be reused in a document from the Data tab.

B.

The formula can be reused to create a variable.

C.

The formula can be saved into a new function.

D.

The formula can be saved and reused in a measure object.

Question 11

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:

Options:

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

Question 12

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 13

You use the Last Refresh Date cell from the Templates in the Report Manager on your report page. You then reformat the cell as Tuesday, January 22, 2014. What is the result when you edit the formula, using the Formula toolbar, to concatenate the string "Last Refresh Date: " and the LastExecutiondate() function?

Please choose the correct answer.

Response:

Options:

A.

The cell reads "Last Refresh Date: 1/22/14".

B.

The "Computation Error" error message is displayed.

C.

The "Incompatible Data Types" error message is displayed.

D.

The cell reads "Last Refresh Date: {Tuesday, January 22, 2014}".

Question 14

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

Please choose the correct answer.

Response:

Options:

A.

Map

B.

Data

C.

Properties

D.

Templates

Question 15

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 16

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

Please choose the correct answer.

Response:

Options:

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

Question 17

Which type of relationship links sub-queries by default?

Please choose the correct answer.

Response:

Options:

A.

OR

B.

AND

C.

NOR

D.

NAND

Question 18

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 19

Which two options should you take before you finish creating a variable in Web Intelligence?

There are 2 correct answers to this question.

Response:

Options:

A.

Save

B.

Parse

C.

Export

D.

Validate

Question 20

Which three statements are true of calculation contexts?

There are 3 correct answers to this question.

Response:

Options:

A.

If no context is defined the default context is assumed.

B.

You can use NoFilter() as an extended syntax keyword when using contexts.

C.

The ForEach context operator automatically takes the dimensions in the block into account.

D.

You must place parentheses around the values listed after the Where keyword when using the Where operator.

Question 21

Which three layout options can you use when creating sections in a report?

There are 3 correct answers to this question.

Response:

Options:

A.

Relative Position

B.

Start on New Page

C.

Keep Blocks Together

D.

Avoid Page Break in Section

Question 22

From the following identify which of the option is not a method to copy a chart from Web Intelligence to a target application?

Please choose the correct answer.

Response:

Options:

A.

Right-click the chart, and, from the contextual menu, select Copy.

B.

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

C.

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

D.

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

Question 23

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)

Options:

A.

Auto detect

B.

Format number

C.

Product locale

D.

Preferred viewing locale

Question 24

In which of the following can you use If ( ) function in Web Intelligence?

Options:

A.

Prompts

B.

Variables

C.

Input control

D.

Drill filters

Question 25

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

There are 2 correct answers to this question.

Response:

Options:

A.

In

B.

Out

C.

ForAll

D.

Output

Question 26

Which statement describes the performance impact that data tracking has on report refresh times, assuming that the data changes but the number of rows retrieved and the data volume stays the same?

Please choose the correct answer.

Response:

Options:

A.

It will refresh up to three times faster.

B.

It will refresh up to three times slower.

C.

It will refresh faster each time the report is refreshed.

D.

It will refresh slower each time the report is refreshed.

Question 27

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 28

Which data sources can you access directly using Web Intelligence?

Options:

A.

Relational databases

B.

Business Explorer (BEx) Queries

C.

XML files

D.

OLAP cubes

Question 29

Where are contexts created?

Please choose the correct answer.

Response:

Options:

A.

In a report

B.

In a universe

C.

In a derived table

D.

At the database level

Question 30

Which of the following make up a semantic layer for a rational data source? (3 answers)

Options:

A.

Section

B.

Universe

C.

Block

D.

Dimension

E.

Measure

Question 31

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

Question 32

You want to subtotal the data by year in a table but you do not have a location for the subtotal in the table. What must you do to create the location for the subtotal in the table?

Options:

A.

Apply a break

B.

Section the report

C.

Insert a blank cell

D.

Format the table

Exam Detail
Vendor: SAP
Certification: SAP Other Certification
Exam Code: C_BOWI_4302
Exam Name: SAP Certified Application Associate - SAP BusinessObjects Web Intelligence 4.3
Last Update: Apr 1, 2025
C_BOWI_4302 Question Answers
Page: 1 / 8
Total 218 questions
Get C_BOWI_4302 Full Access Download C_BOWI_4302 PDF