Latest Verified & Correct SAP C-BOWI-42 Questions & Answers Daily Updated [Q38-Q53]

Rate this post

Latest Verified & Correct SAP C-BOWI-42 Questions & Answers Daily Updated

100% Pass Guaranteed Download SAP Certified Application Associate Exam PDF Q&A

NO.38 Which of the following options involved to Create Variable from the Formula? There are 2 correct answers to this question Response:

Select the cell that contains the formula

Double-click Formula bar and click OK

Click the Create Variable and Select the Formula bar

On the Formula bar, click Create Variable

NO.39 Why do you use the “Turn into” functionality?

To change the data source of a document

To change the data type of an object

To change the object of a section

To change the table into a chart

NO.40 Which keyword is defined as flexible for input contexts?
Please choose the correct answer.
Response:

All

ForAll

ForEach

NO.41 What do you use to conditionally hide a report element?

A formula

A formatting rule

A query filter

A report filter

NO.42 Which Pos() function syntax should you use to find the location of the space in the Category string “Evening wear”? Please choose the correct answer.
Response:

Pos([Category] , “” )

Pos((Category) , “” )

Pos([Category] ; ” ” )

Pos({Category} ; ” ” )

NO.43 How does SAP recommend you print a Web Intelligence document to ensure the document layout is preserved?

Use the Print Screen button on your keyboard

Export data to a CSV file and print the CSV file.

Use the print option in the browser

Export the document to a PDF file and print the PDF file.

NO.44 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? Please choose the correct answer.
Response:

In([State])

Out([State])

ForAll([State])

ForEach([State])

NO.45 What options are available when linking to another document? (2 answers)

Target an area within the document

Refresh on open

Combine queries

Change data source

NO.46 Where should you configure the regional settings of a Web Intelligence document (WID) within InfoView? Please choose the correct answer.
Response:

Local Settings

Browser Preferences

User Machine Settings

InfoView Preferences

NO.47 Which two statements are true of grouping sets when using smart measures? Please choose the correct answer.
Response:

It is a set of dimensions that generates a result for a measure.

It is a set of measures that generates a result for a dimension.

The generated SQL includes grouping sets for all the aggregations of that dimension that are included in the report.

The generated SQL includes grouping sets for all the aggregations of that measure that are included in the report.

NO.48 Which of the following can you use to filter results dynamically? (2 answers)

Results Object pane

Element linking

Input control

Report map

NO.49 You are reviewing a report with the following statement in a variable:
= If([Sales revenue] > 750000) Then “Top Performer” Else If([Sales revenue] Between (200000;650000)) Then “Average Performer” Else If ([Sales revenue] < 200000) Then “Low Performer” Which statement is true of the results produced by the statement for sales representatives with sales between 650,000 and 750,000? Please choose the correct answer.
Response:

They will be Top Performers.

They will be Average Performers.

They will not be included in the report.

They will not have a performance value assigned.

NO.50 Your report contains a table. What happens when you drop a dimension object into a blank part of this report? Please choose the correct answer.
Response:

A new group is created.

A new block is created.

A new free-standing cell is created.

A new section is created.

NO.51 Which message appears when you select “Use query drill” while Scope of Analysis is set in a BusinessObjects Web Intelligence 4.0 report? Please choose the correct answer.
Response:

The Scope of Analysis is empty.

The Scope of Analysis is not empty.

The query drill mode option is enabled.

The query drill mode option is not enabled.

NO.52 What automatically happens when you create a chart using the Templates tab in Web Intelligence? Please choose the correct answer.
Response:

Data is filtered using template dimensions.

Structure mode is selected.

Data is displayed on the report page.

Select Objects dialog box opens.

NO.53 How do you make changes to a document that has been published in the BI Launch pad? (2 answers)

Right click the document and select Properties.

Right click the document and select Document Link.