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:
- Click the Longview tab.
- In the Formulas group, click Longview Functions, and click LVDIMNAME. The Function Arguments dialog opens.
- Complete the following fields:
Field Description Dim
Specify the dimension number. LVDIMNAME syntax
- Click OK. The query data appears in the worksheet.