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

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.

Page numbers

Last refresh date

Bar charts

Vertical tables

Dimension value formats must be the same.

Dimensions with different names can be merged.

Dimensions with different data types can be merged.

Dimensions from multiple data sources can be merged.

Select the "Track" button on the toolbar.

In the Query panel, enable "Keep History".

In the InfoView Preferences, enable "Track Data Changes".

Right-click the column in the report and select "Activate Data Tracking".

Add a combined query, displaying all stores and revenues, using the intersection operator.

Add a subquery, displaying all stores and revenues with the operator "Greater than or equal to" your store's revenue.

Add a combined query, displaying all stores and revenues, using the union operator.

Add a second query, displaying all stores and revenues and merge the store name dimensions.

=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

Map

Data

Template

Properties

Sum

Detail

Measure

Dimension

In([State])

Out([State])

ForAll([State])

ForEach([State])

Report Element>Chart>Insert Column Chart

Chart> Report Element >Insert Column Chart

Chart> Insert Column Chart >Report Element

Insert Column Chart>Chart>Report Element

You can have multiple blocks projected from the same microcube within a single report, all sub-grouped to the sectioned level

You can have single block projected from the same microcube within a single report, all grouped to the sectioned level

You can insert subtotal cells, repeated in each section, which are created by the simple process of drag and drop

You can insert tables, different in each section, which are created by the simple process of drag and drop

1.00

1.05

1.10

1.15

1.18

Relational databases

Business Explorer (BEx) Queries

XML files

OLAP cubes

Inbox

My Favorites

My Documents

Personal Documents

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

Auto detect

Format number

Product locale

Preferred viewing locale

Drill By

Drill Up

Drill Down

Drill Through

It displays the definition of the block.

It displays the report page by default.

It defines what the report will look like when printed.

It defines what the report will look like in PDF mode.

Relative Position

Start on New Page

Keep Blocks Together

Avoid Page Break in Section

Block

Global

Custom

Dynamic

Personal data files

Stored procedure data source

Queries from the same universe

Queries from different universes

Blocks in the report are repeated for each section value.

Page breaks are created to divide each section value

Header and footer cells are created for each section value.

Free-standing cells are created to label each section value.

Ascending

Descending

Custom Sort

Adaptive Sort

In a report

In a universe

In a derived table

At the database level

You can combine objects in different contexts.

You cannot combine objects in different contexts.

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

You can combine only measures within the same context to create a query.

Improve function

Matches data task

Report Element

Data Access

Analysis task

It prompts you to choose a hierarchy level and waits for your response before retrieving the data.

It notifies you that it needs to retrieve additional data to complete the drill and retrieves the data.

It inserts a prompted query filter in the query and reruns the query.

It inserts a prompted report filter on the report and refreshes the report view.

Some of the selected objects are restricted.

Some of the selected objects are not synchronized.

Some of the selected objects have different data formats.

Some of the selected objects do not have different data types.

Click Report Element → Map → Insert Column Chart

Click Report Element → Report → Insert Column Chart

Click Report Element → Chart → Insert Column Chart

Click Report Element → Sec on → Insert Column Chart