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





OBIEE Hierarchy Navigation Functions {HNF} Part 4



In Part 1 we did ISPARENT, in Part 2 ISANCHESTOR, in Part 3 ISCHILD. Now it’s time for:

ISDESCENDANT

From the documentation:


 

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



Presentation Layer Syntax


ISDESCENDANT(pc_presentation_hierarchy, member_identifier [, distance])



Example “Hardcoded” distance = 1:


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




Example “Hardcoded” distance = 2:


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



Example “SessionVariable” distance = 2:


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



Note: If you leave the distance option out you will get all the children.
 

Business Model and Mapping Layer Syntax


ISDESCENDANT(logical_dimension, member_identifier [, distance])



Example “Hardcoded” distance = 1:


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



Example “Hardcoded” distance = 2:


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



Example “SessionVariable”:


FILTER("13 - Hierarchy levels"."F0 Sales Base Measures"."1- Revenue" USING  ISDESCENDANT("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