Focal Point
[CLOSED] Get parents in a FML Hierarchy or display an upline hierarchy

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/396109942

September 25, 2009, 04:47 PM
getit
[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
END

This 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.04Upgrade:WebFOCUS 8.2.07OS:LinuxOutputs: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