LVSCELL Function

Using the LVSCELL function, you can query single schedule 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.

You can use the LVSCELL function in the following ways:

• Type the function syntax into a worksheet cell.

• Complete the function parameters in the Function Arguments dialog.

LVSCell syntax

In the worksheet cell, type:

=LVSCELL(“ScheduleName”, "Sym_dim1", "Sym_dim2", "Sym_dim3",…, "Sym_dimN", “ESym_dimN”)

where:

• ScheduleName is the name of the schedule.
• 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.
• ESym_dimN is the name of the symbol in schedule dimension N that serves as a schedule coordinate for the specific data server repository cell. Specify one symbol name per schedule dimension.

The Longview data server repository may contain a maximum of sixteen dimensions and eight schedule dimensions. Include as many symbols as there are dimensions. For example, if there are six base dimensions and 1 schedule dimension in the schedule in the Longview data server repository, include six symbols and 1 schedule symbol.

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.

For example:

Querying schedule cell values using the Function Arguments dialog

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

To query a schedule cell value:

1. Click the Longview tab.
2. In the Formulas group, click Longview Functions, and click LVSCELL. 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.
   Schedule	Specify the name of the schedule.
   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.
   Sym_schedule Dim1... Sym_scheduleDimN	Specify a symbol name for each schedule 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.