Implementing Structures in Queries

1.

There are two correct answers.

Use a cell as a reference cell so that it can be referenced in calculations.

Define help cells that contain comments for formulas in the report.

Apply cell formulas or selection conditions to any cell in your Analysis report.

Define formulas and selection conditions for cells to overwrite the initial cell definition.

2.

There are two correct answers.

To create a key figure structure, right-click on the key figure to open its context menu and choose Create Structure.

Formulas can only be defined within key figure structures.

You can only use one key figure structure in a query.

Each component of a key figure structure must contain a key figure.

3.

There are two correct answers.

You can define a maximum of two structures.

You must always define one structure in the columns and one structure in the rows.

You can only use one structure without key figures in a query.

By using both the structures in the rows or in the columns you can avoid formula collision.

You can only use one structure with key figures in a query.

4.

Choose the correct answer.

True

False

Knowledge quiz