Inzicht in uw bedrijfsgegevens en processen
Contact   |   Vacatures   |   Inloggen
#1 in inzichten en expertise
menu_header





OBIEE Hierarchy Navigation Functions {HNF} Part 5



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

ISLEAF

From the documentation:


The ISLEAF function applies to both level-based and parent-child hierarchies. For both types of hierarchy, a leaf member is defined as a member that has no child members.


 

Presentation Layer Syntax

ISLEAF(presentation_hierarchy)

 

Example “Hardcoded”:


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


 

Business Model and Mapping Layer Syntax

ISLEAF(logical_dimension) Example “Hardcoded”:


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


Datum: 04-10-2011 Auteur: John Minkjan
verplicht

verplicht

 
 BI Technologie
 Interactive Dashboards
 Answers
 Publishing
 Delivers
 Office integratie
 Server
 BI Applicaties
 Financial Analytics
 Project Analytics
 Human Resource Analytics
 Supply Chain Analytics
 Customer Sales Analytics
 Procurement and Spend Analytics
 Manufacturing Analytics
 BI Projecten
 Project management
 Datawarehousing
 Advisering / BICC
 Consultancy
 Over ons
 Contact
 Netwerkorganisatie
 Portfolio
 Laatste nieuws
 Inzetbare consultants
 Vacatures
 Blog
 FacturatieOffice.nl facturatie software
 Gratis urenregistratie
 Een factuur maken
 Een creditnota maken
 Een offerte maken
 Een pakbon maken
 Een betalingsherinnering maken
 Een factuur voorbeeld

Volg Insight Experts via jouw Facebook page


Deel deze blog met jouw sociale netwerken

Sitemap voor deze pagina

BI