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

Left()

LeftPad()

LeftTrim()

Concatenate()

Right click the footer of the table

Right click the column header of the table

Right click the border of the table

Right click the data of the table

AD

NT

LDAP

Vintella

Kerberos

Enterprise

Contexts are defined in a report.

Contexts are defined in a universe.

You can combine objects in different contexts.

You can combine any objects within the same context to create a query.

1. Right click the section cell.

2. Select Edit Formula.

3. Choose the new dimension.

1. Right click in a blank area of the section.

2. Select Edit Selection.

3. Choose the new dimension.

1. Right click the section cell.

2. Select Sort.

3. Select Advanced.

4. Remove existing dimension.

5. Add the new dimension.

1. Right click in a blank area of the section.

2. Select Format Selection.

3. Modify dimension after "Section on".

From within the BI launch pad, and sent automatically by using the sharing option to group of users

From within the BI launch pad, save a document as a personal document in the BIP

From within the BI launch pad, send a document to another user or group of users

Publish documents to the CMS as a public or personal document

The Padding options at single level of your document

The Format options at various levels of your document

The Page break options at various levels of your document

The Format options at single level of your document

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

The "Computation Error" error message is displayed.

The "Incompatible Data Types" error message is displayed.

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

Right-click the table, select "Custom Sort"

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

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

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

Crystal Reports

Desktop Intelligence

Web Intelligence in InfoView

Web Intelligence Rich Client

To conditionally show rows in a block

To conditionally execute a scheduled report

To display dynamically grouped values

To display a dynamic list of values

UNION

MINUS

UNION ALL

INTERSECT

It must contain Boolean operators.

It restricts the data used to calculate the measure expression.

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

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

Run the query

Launch panel to generate data

SQL is executed to extract data

Report is displayed

Validate query filter

Designer query filters

Predefined query filters

Single and multi-value filters

Prompted filters

OR

AND

NOR

NAND

The objects are rearranged in the block based on the order in the Results Objects pane.

The reordered objects are removed from the block.

The block is sorted in ascending order based on the first object in the Results Objects pane.

The block remains unchanged.

Universe

Text File

Web Service

OLAP Cube

To change the universe connection of your universe

To use the production universe instead of the test universe

To use different objects from the universe

To change the order of execution for existing queries

It will stay the same size.

It will increase two times.

It will increase three times.

It will increase by 50% on each refresh.

In the Report Map pane

In the Available Objects pane

In the Document Structure and Filters pane

In the Query panel

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.

Block

Global

Custom

Dynamic

Result produces two table blocks.

Dimension objects are automatically merged.

Results are shown on two different report tabs.

Dimension objects are not automatically merged.

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

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

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

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

Sort

Filters

Format Cell

Merge Dimensions

Generate a running sum in multiple table blocks.

Remove repeated values in one table block.

Break the table into multiple table blocks.

Generate subtotals in one table block.

Apply a break

Section the report

Insert a blank cell

Format the table

Semicolon (;)

Percent (%)

Underscore (_)

Comma (,)