LVCHILD Function

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

You can use the LVCHILD function in the following ways:

• Type the function syntax into a worksheet cell. For more information,
• Complete the function parameters in the Function Arguments dialog.

LVCHILD syntax

In the worksheet cell, type:

=LVCHILD("Dim", "Sym_name", [number])

where:

• Dim is the name, description, or number of the dimension containing the child 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 parent symbol.
• number is an optional parameter that represents the numeric position of the child symbol relative to the other child symbols at the same level in the hierarchy. If you do not specify a value for number, a default value of 1 is used.

For example:

=LVCHILD("TIMEPER","2014",1)

Querying child symbols using the Function Arguments dialog

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

To query a child symbol:

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

   Field	Description
   Dim	Specify the dimension containing the child symbol.
   Sym_name	Specify the name of the parent symbol. You may use the Symbol Selector control or manually type in the symbol name.
   <number>	Optionally, specify a number indicating the relative position of the child symbol.

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