LVCELL Function

Using the LVCELL function, you can query single cell values from the Longview data server repository. This function is useful when you want to populate your Microsoft Excel reports using direct references to the data server repository. These references can be refreshed to show the latest data server repository values.

Note: You can also run a data query from a worksheet cell that contains an LVCELL function. For more information, see Analyzing LVCELL functions.

You can use the LVCELL function in the following ways:

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

LVCELL syntax

In the worksheet cell, type:

=LVCELL("Sym_dim1", "Sym_dim2", "Sym_dim3",…, "Sym_dimN")

where:

• Sym_dimN is the name of the symbol in dimension N that serves as a coordinate for the specific data server repository cell. Specify one symbol name per dimension.

The Longview data server repository may contain a maximum of sixteen dimensions. Include as many symbols as there are dimensions. For example, if there are six dimensions in the Longview data server repository, include six symbols.

Always type the symbols in the same sequence as the dimensions in the Longview data server repository. For example, if ACCOUNTS is the first dimension in the Longview data server repository, type the name of an account for the first symbol. To find out the order of the dimensions in the Longview data server repository, use the LVDIMNAME function. For more information, see LVDIMNAME.

For example:

=LVCELL("TOTASSET","FINYEAR","CHICAGO","CUSD","DIM4SET")

Querying cell values using the Function Arguments dialog

You can query a single cell value from the Longview data server repository by completing the function parameters in the Function Arguments dialog.

To query a cell value:

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

   Field	Description
   Defaults	If you have user defaults defined in the UGPDNInputDefault or UGPDNQueryDefault attributes, you may select from this drop list to quickly populate the symbol fields below.
   Sym_dim1... Sym_dimN	Specify a symbol name for each dimension in your system. You may use the Symbol Selector control or manually type in each symbol name.

4. Click OK. [Refresh required] appears in the worksheet cell.
5. Refresh the worksheet. For more information, see Refreshing data from cells containing Longview Functions. The query data appears in the worksheet.