Home » Developer & Programmer » Data Integration » XP_HIERMNT Program
XP_HIERMNT Program [message #92858] Sat, 10 November 2001 08:33 Go to next message
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 Go to previous messageGo to next message
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 Go to previous message
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)

----------------------------------------------------------------------
Previous Topic: Re: Queries in Oracle Express - Urgent
Next Topic: Re: OES / OFA / OSA on Linux
Goto Forum:
  


Current Time: Fri Dec 27 11:37:23 CST 2024