LVDESC Function

Using the LVDESC function, you can query the description of a symbol to a worksheet cell.

You can use the LVDESC function in the following ways:

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

LVDESC syntax

In the worksheet cell, type:

=LVDESC("Dim", "Sym_name", ["language"])

where:

• Dim is the name, description, or number of the dimension containing the 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 symbol.
• language is an optional parameter for the language to use. Specify one of the following values:

  Value	Description
  "EN"	The symbol description appears in English.
  "ALT"	The symbol description appears in the alternate language as set for the system.

  If you do not specify a value for language, the symbol description appears in English.

For example:

=LVDESC("ACCOUNTS","IncStmt","EN")

Querying symbol descriptions using the Function Arguments dialog

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

To query a symbol description:

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

   Field	Description
   Dim	Specify the dimension containing the symbol.
   Sym_name	Specify the symbol name. You may use the Symbol Selector control or manually type in the symbol name.
   <language>	Optionally, specify the language to use for the symbol description.

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