[CLOSED] Get parents in a FML Hierarchy or display an upline hierarchy
Is there a way to display an upline report on an FML Hierarchy.?
I know that if i use the following I will get all the children(Donwline) starting from &ENTITY. Is there a way to get all the parents associated to a certain point in the hierarchy.?
TABLE FILE HIER PRINT NAME FOR CHILDID '&ENTITY' WITH CHILDREN ALL AS CAPTION LABEL NAME ENDThis message has been edited. Last edited by: Kerry,
App Studio Version 8202 windows Platform SQL Server 2008/2012
September 27, 2009, 05:34 PM
Waz
Reversing the Hierarchy should be easy, as you already have the parent-child relationship.
All you need to do is change the master to have PARENT_OF on the child and point to the parent.
Waz...
Prod:
WebFOCUS 7.6.10/8.1.04
Upgrade:
WebFOCUS 8.2.07
OS:
Linux
Outputs:
HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!
September 28, 2009, 08:51 AM
<JG>
By definition a child in a hierarchy can only have 1 parent. And you can not report against multiple hierarchies in a single request