LVMIDESC Function

Using the LVDIMDESC function, you can query the description of a dimension to a worksheet cell.

You can use the LVDIMDESC function in the following ways:

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

LVDIMDESC syntax

In the worksheet cell, type:

=LVDIMDESC(Dim)

where:

• Dim is the name or number of the dimension.

  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.

For example:

=LVDIMDESC("ACCOUNTS")

Querying dimension descriptions using the Function Arguments dialog

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

To query a dimension description:

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

   Field	Description
   Dim	Specify the dimension to query.

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