LVPARENT Function

Using the LVPARENT function, you can query the name of a parent symbol to a worksheet cell.

You can use the LVPARENT function in the following ways:

1. Type the function syntax into a worksheet cell.
2. Complete the function parameters in the Function Arguments dialog.

LVPARENT syntax

In the worksheet cell, type:

=LVPARENT("Dim", "Sym_name", ["sym_root"])

where:

• Dim is the name, description, or number of the dimension containing the parent symbol. If you enter a dimension description, the parameter is not case sensitive.

  Note: The dimension number is an integer corresponding to the order of the dimension as it appears in the Longview data server repository. For example, if you have six dimensions in your system, the dimensions are numbered from 1 to 6. If you specify a dimension number for Dim, do not enclose it in double quotation marks.

• Sym_name is the name of the child symbol.

• sym_root is an optional parameter for the name of the root symbol of the hierarchy containing the parent symbol. Specify a root symbol if the child symbol specified for Sym_name belongs to multiple parent symbols. If you do not specify a value for sym_root, the first parent symbol in the hierarchy is returned.

For example:

=LVPARENT("ENTITIES","TORONTO","ABCOPERATIONS")

Querying parent symbols using the Function Arguments dialog

You can query a parent symbol by completing the function parameters in the Function Arguments dialog.

To query a parent symbol:

1. Click the Longview tab.
2. In the Formulas group, click Longview Functions, and click LVPARENT. The Function Arguments dialog opens.
3. Complete the following fields:

   Field	Description
   Dim	Specify the dimension containing the parent symbol.
   Sym_name	Specify the name of the child symbol. You may use the Symbol Selector control or manually type in the symbol name.
   <sym_root>	Optionally, specify the name of the root symbol of the hierarchy containing the parent symbol.

4. Click OK. The query data appears in the worksheet.