Advance Criteria Functions

Question 1

Define Selections

Answer 1

are similar to filters in that they’re used to limit the members or data that appear when you run your analysis.

Question 2

T or F: Selections can be applied to attributes or hierarchical numbers that match your criteria.

Answer 2

True.

Question 3

Each selection consists of one or more criteria, referred to as ____.

Answer 3

Steps

Question 4

Where can you view and edit the selections pertaining to an analysis?

Answer 4

Selection pane

Question 5

What does the Selection pane allow you to do?

Answer 5

To create and refine selections as part of your initial designation of analysis criteria, or dynamically in your analysis results

Question 6

T or F: Each selection does not specify the criteria for a set of data that is to be displayed for a particular column.

Answer 6

False

Question 7

What are the three possible steps available?

Answer 7

• Select Members
• Add Groups and Calculated Items
• Apply Condition

Question 8

How can you create steps?

Answer 8

• You can create steps by dragging hierarchical column members into your analysis.
• You can explicitly create a new step by clicking the New link below a column in the Selection Pane

Question 9

T or F: Your analyzer license does not allow you to adjust the formulas for each of your columns once you’ve added those columns to your analysis.

Answer 9

False.

Question 10

Define Groups.

Answer 10

Groups are a way for you to group data for the sake of comparison.
All the members of a group have to be from the same attribute column or hierarchical column

Question 11

T or F: Not all the members of a group have to be from the same attribute column or hierarchical column

Answer 11

False.

Question 12

T or F: You can even nest groups so that groups can be composed of multiple other groups, along with specific members. So in other words, you can create groups of groups.

Answer 12

True.

Question 13

Where are groups saved?

Answer 13

They are saved to the Presentation Catalog, in the subject area, specific directory path, or they can be inline.

Question 14

How are groups created?

Answer 14

1 - Edit > Criteria tab > Results > New Group > Display Label > Ok
2 - Selection Step > Show/Hide Selection Steps pane > New Group > Move > Ok

Question 15

What can a calculated Item do?

Answer 15

• It allows you to override the default aggregation rule based on the Oracle BI Repository.

It allows you to add new members to a column when those members do not exist in the data source