Skip to main content

LVDIMNAME Function

Using the LVDIMNAME function, you can query the name of a dimension to a worksheet cell.

You can use the LVDIMNAME function in the following ways:

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

LVDIMNAME syntax

In the worksheet cell, type:

=LVDIMNAME(Dim)

where:

  • Dim is the dimension number. 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.

For example:

=LVDIMNAME(1)

Querying dimension names using the Function Arguments dialog

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

To query a dimension name:

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

    Dim

    Specify the dimension number. LVDIMNAME syntax

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

Was this article helpful?

We're sorry to hear that.