Improved query security

Accurate duplication of query parameters

Improved performance of query execution

Reduced creation time for complex reports

Used when any condition is met by two filters

Used when all conditions are met by two filters

Used when all conditions are met by more than two filters

Used when only one condition is met by any of the filters

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

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.

Relative Position

Start on New Page

Keep Blocks Together

Avoid Page Break in Section

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.

To create a section

To create multiple table blocks

To remove repeated values in one table block

To manipulate the navigation path

InfoView

Command Line

Start > All Programs

Central Management Console

Right(5; [Product Name])

Right([Product Name]; 5)

Right((Product Name), 5)

Right(5, [Product Name])

Query Panel

Prompts Panel

Slice and Dice Panel

Document Properties

Prioritize data analysis in the Excel document

Prioritize the format of reports in the Excel document

Prioritize easy data processing in the Excel document

Prioritize the selection of best solution in the Excel document

Left()

LeftPad()

LeftTrim()

Concatenate()

Analyze – Analysis of data for required result

Dimension -Typically retrieve character-type data

Detail -Provides descriptive data about a dimension

Measure - Retrieves numeric data that is the result of calculations on data in the database

Improve- Selecting and implementation of the best solution

1.00

1.05

1.10

1.15

1.18

In the Report Map pane

In the Available Objects pane

In the Document Structure and Filters pane

In the Query panel

TXT

XML

CSV

XLS

You want to convert a string object into a date object.

You want to convert a date object into a string object.

You want to format a date so that it is displayed as a string when it is concatenated with another string.

You want to modify the format of a string object into a non-standard date format.

It can be resolved with a loop.

It can be resolved with a context.

It contains all possible combinations of rows from the tables inferred by the objects.

It contains one or more objects that can potentially return two different types of information.

Table

Report

Section

Document

You can apply alerters to charts.

You can apply multiple alerters to one block.

You can apply the same alerter to multiple blocks.

You can control the order in which alerters are applied.

It instructs the variable to calculate only where certain values are true.

It modifies the HAVING clause of the SQL generated 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.

Data in a chart

Data in a section header cell

Data in a query filter

Data in a table

InfoView

Java Panel

Interactive Panel

Web Intelligence Rich Client

It adds the dimension to the default context.

It removes the dimension from the default context.

It determines the order of the results.

It restricts the dimension used to calculate a measure.

Improve function

Matches data task

Report Element

Data Access

Analysis task

Click the "Set Master" button in the toolbar.

Drag the column to be sectioned outside the block.

Select the column; select Reporting Menu Option and then select "Set As Section".

Right-click the column on which you want to create a section. From the drop-down menu, select "Set As Section".

An object or cell contents

A modified data formatting

A cell section

An operator

The conditional formatting