Wednesday, September 14, 2011

OBIEE Hierarchy Navigation Functions {HNF} Part 6

In Part 1 we did ISPARENT, in part 2 ISANCHESTOR, in part 3 ISCHILD, in part 4 ISDESCENDANT, in part 5 ISLEAF.

ISROOT

From the documentation:
A presentation hierarchy member is defined as a root member if it has no ancestors above it in a parent-child presentation hierarchy.

Presentation Layer Syntax

ISROOT(pc_presentation_hierarchy)


Example “Hardcoded”:


Case When ISROOT("Sales Person"."H5 Sales Rep" ) Then 'YES' else 'NO' END


Business Model and Mapping Layer Syntax


ISROOT(logical_dimension)


Example “Hardcoded”:


Case When ISROOT("13 - Hierarchy levels"."H5 Sales Rep" ) Then 'YES' else 'NO' END


image

Till Next Time

No comments: