SSANCESTORONTOP

Controls whether users can specify that ancestors be positioned at the top, in grid client operations.

Syntax

SSANCESTORONTOP [appname [dbname]] TRUE | FALSE
  • appname—Optional. Specifies the application to which the configuration applies.

  • dbname—Optional. Specifies the cube to which the configuration applies.

  • TRUE—Smart View users can specify the ancestor position for hierarchies in ad hoc grids.

  • FALSE—Smart View users cannot specify the ancestor position. This is the default.

Description

If this configuration property is set to TRUE, Smart View users can specify ancestor position for hierarchies in ad hoc grids. By default, this parameter is not enabled, and the ancestor is positioned at the bottom.

Example

SSANCESTORONTOP Sample TRUE

See Also

Specifying Ancestor Position in Ad Hoc Grids in Working with Oracle Smart View for Office (available on the Books tab)