C_BOWI_43 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.

BLOB

DATE

TEXT

NUMBER

They are stored in folders.

They are stored in categories.

They can be assigned to a folder.

They can be assigned to a category.

InfoView

Command Line

Start > All Programs

Central Management Console

RunningMax()

RunningSum()

RunningTotal()

RunningMean()

To define relative pattern of the table on the page

To define horizontal and vertical start on new page

To define rows and columns and background image

Avoid page break and repeat on every page options

Pos([Category] , "" )

Pos((Category) , "" )

Pos([Category] ; " " )

Pos({Category} ; " " )

In the document

In a category

In a query

In the universe

Validate query filter

Designer query filters

Predefined query filters

Single and multi-value filters

Prompted filters

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.

Web Intelligence

InfoView Preferences

Microsoft Excel File Options

Web Intelligence Rich Client

Block

Global

Custom

Dynamic

Report Properties

Query Panel Properties

Preferences in InfoView

Scope of Analysis Properties

Tools/Options in Web Intelligence Rich Client

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.

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

The formula can be reused to create a variable.

The formula can be saved into a new function.

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

In the universe

In the query panel

In the filter bar

In the Input Controls pane

Values within the function must be in quotes.

The function can be used to create a variable.

The function can contain an aggregate function.

Then and Else keywords can be used within the function instead of the semicolon.

Advanced

Query

Active X

Interactive

Design pattern: to find values that match the design you specify

Matches pattern: to find values that match the pattern you specify

Different from pattern: to find values different than the pattern you specify

Defined pattern: to find values that match the defined pattern you specify

?

%

-

*

In

Out

ForAll

Output

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

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

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

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

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

They allow manipulation of reports to change the way the data is displayed.

They allow manipulation of variables to change the way the data is aggregated.

They allow manipulation of universe objects to change the way the data is displayed.

They allow manipulation of universe contexts to change the way the data is aggregated.

2014

01/31/2014

01/31/2013

2013

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

Drag data in a table in the target application and you can add the data contained in the table, click copy and paste

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

Right- click the table to the target application and maintain the formatting from Web Intelligence

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}".

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

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

Use the print option in the browser

Use the Print Screen button on your keyboard

Drag the measure from the Data tab into the section header.

Copy the measure from the Data tab into the section header.

While pressing the ALT key, drag the measure from the table to the section header.

While pressing the CTRL key, drag the measure from the table to the section header.