XP_HIERMNT Program [message #92858] |
Sat, 10 November 2001 08:33 |
Sandra
Messages: 6 Registered: November 2001
|
Junior Member |
|
|
Can anyone tell me how XP_HIERMNT program works or where can i get documentation about this program ?
thx
----------------------------------------------------------------------
|
|
|
Re: XP_HIERMNT Program [message #92859 is a reply to message #92858] |
Sun, 11 November 2001 19:09 |
M Srinivasa Prasad.
Messages: 2 Registered: November 2001
|
Junior Member |
|
|
Hi,
xp_hiermnt is used to maintain and calculate hierarchies programmatically.
call XP_HIERMNT(Action, Dimension, Hierarchy, Child, Parent).
Action Text 'ADD' adds Child under Parent in the Hierarchy hierarchy
of the Dimension dimension
Text 'CALC' calculates the Hierarchy hierarchy of the Dimension
dimension
Dimension Text The dimension to maintain.
Hierarchy Text The hierarchy to maintain. NA indicates ALL hierarchies.
Child Text The child value to be added.
Parent Text The parent to add the Child value under.
The program does not maintain the dimension, it only maintains the
hierarchy. Changes are saved only if the Express data database is attached
read-write.
----------------------------------------------------------------------
|
|
|
Re: XP_HIERMNT Program [message #92867 is a reply to message #92858] |
Tue, 27 November 2001 07:56 |
Owen
Messages: 18 Registered: September 1999
|
Junior Member |
|
|
This updates the .rel metadata for the hierarchy, and checks that there are no logical loops in the hierarchy (ie. a grandchild is not its own great grand parent)
----------------------------------------------------------------------
|
|
|