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",["include_comments"])

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.

• 'include_comments' is an optional parameter that specifies whether comments are retrieved from the Longview database. Specify one of the following:

  Value	Description
  FALSE	No comments are retrieved from the database. This is the default value.
  TRUE	Comments are retrieved from the database for the LVCELL intersection and displayed as an Excel cell comment. Comments refresh automatically when the LVCELL function is refreshed.

For example:

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

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.
   <include_comments>	Optionally, specify whether comments are retrieved from the Longview database. By default, it is FALSE, and LVCELL displays no comments. If set to TRUE, LVCELL shows the associated comment as an Excel cell comment.

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.

Viewing Audit Data

The 'View Audit Data' feature enables users to quickly access audit trail information for a specific data intersection directly from an LVCELL. By using the right-click context menu, users can launch the existing Audit Data application with relevant audit records automatically filtered to the selected intersection. This streamlines access to audit information and eliminates the need for manual searches.

Prerequisites :

• Audit Trail must be enabled for the system.
• The user must have the appropriate permissions to access the Audit Data application.

Note: If Audit Trail is disabled, the View Audit Data option is hidden or unavailable in the LVCELL right-click context menu.

Steps to View Audit Data for an LVCELL:

1. Navigate to the worksheet or grid containing the target LVCELL.

2. Right-click the LVCELL for which you want to review audit information.

3. From the context menu, select View Audit Data.

4. The Audit Data application opens in a new view.

5. The audit data is automatically filtered to display records related to the selected LVCELL intersection, including dimensions such as account, time period, entity, and other applicable dimensions.

The Audit Data application displays historical changes for the selected intersection, including previous values, updated values, timestamps, and user information. The information displayed is based on system configuration and user permissions.