Hierarchy examples

Related topics

In the Hierarchy Build Wizard, in the Display Options step, you can specify a Type, Value Type, and Value combination to define the look and feel of the drill up and drill down links that the end user clicks to drill up or down in the hierarchy.

Literal Text Link

Drill Up/Down Options

Note: A literal text link displays only when there is additional data to drill up or down to. In this example, there is no additional data for JONES, so there is no link.

 

Type

 Value Type

 Value

Drill Up

Text

Literal

Up

Drill Down

Text

Literal

Down

In the Hierarchy Build Wizard, in the Display Options step, you can specify a Type, Value Type, and Value combination to define the look and feel of the drill up and drill down links that the end user clicks to drill up or down in the hierarchy.

Literal Text Link

Drill Up/Down Options

Note: A literal text link displays only when there is additional data to drill up or down to. In this example, there is no additional data for JONES, so there is no link.

 

Type

 Value Type

 Value

Drill Up

Text

Literal

Up

Drill Down

Text

Literal

Down

Column Expression Link

Drill Up/Down Options

Note: A column expression link displays the column expression value even if there is no associated link. In this example, JONES displays with its associated JOB column expression (MANAGER), but this is not an active link as in the other elements of the hierarchy.

 

Type

 Value Type

 Value

Drill Up

Text

Column

'(' || JOB || ')'

Drill Down

Text

Column

'(' || JOB || ')'

Button with a Literal Value

Drill Up/Down Options

Note: A button with a literal value displays only when there is additional data to drill up or down to. In this example, there is no additional data for JONES, so there is no button displayed.

 

Type

 Value Type

 Value

Drill Up

Button

Literal

/\

Drill Down

Button

Literal

\/

Button with Column Expression Value

Drill Up/Down Options

Note: A button with column expression value displays the column expression even if there is no associated link. In this example, JONES displays with its associated JOB and DEPTNO information (MANAGER-20), but this is not an active link as in the other elements of the hierarchy.

 

Type

 Value Type

 Value

Drill Up

Button

Column

JOB || '-' || DEPTNO

Drill Down

Button

Column

JOB || '-' || DEPTNO

Image Link

Drill Up/Down Options

Note: When the Type is Image, the Value Type is ignored. The image file specified must be in the /images/ virtual directory of the listener.

 

Type

 Value Type

 Value

(click to list files)

Drill Up

Image

N/A

arrowu.gif

Drill Down

Image

N/A

arrowd.gif

Related topics

What are hierarchies?