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





OBIEE Hierarchy Navigation Functions {HNF} Part 2



In Part 1 we did ISPARENT. ISPARENT is basically the ISANCHESTOR function with a distance of 1.

ISANCHESTOR

From the documentation:


The ISANCESTOR function enables you to find the ancestors of a member of a parent-child hierarchy, either all the ancestors of a member, or the ancestors at a specified hierarchical distance from the member.



Presentation Layer Syntax


ISANCESTOR(pc_presentation_hierarchy, member_identifier [, distance] )


 

Example “hardcoded” , no distance:


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



This will show all anchestors!

Example “hardcoded” , distance = 2:


Case When ISANCESTOR("Sales Person"."H5 Sales Rep",'21',2 ) Then 'YES' else 'NO' END



Example “Session Variable” , distance =2:


Case When ISANCESTOR("Sales Person"."H5 Sales Rep",VALUEOF(NQ_SESSION.HierarchyUser),2 ) Then 'YES' else 'NO' END




Business Model and Mapping Layer Syntax


ISANCESTOR(logical_dimension, member_identifier [, distance])



Example “hardcoded”, distance =1:


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



Example “hardcoded”, distance =2:


Case When ISANCESTOR("13 - Hierarchy levels"."H5 Sales Rep",'22' ,2) Then 'YES' else 'NO' END



Example “SessionVariable”:


FILTER("13 - Hierarchy levels"."F0 Sales Base Measures"."1- Revenue" USING  ISANCESTOR("13 - Hierarchy levels"."H5 Sales Rep",  VALUEOF(NQ_SESSION."HierarchyUser"),2))


 

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