LVCOMMENT Function

Using the LVCOMMENT function, you can query comments associated with specific data intersections from the Longview data server repository. This function is useful when you want to display detailed information that users have provided for a specific data intersection in your Microsoft Excel reports. These references can be refreshed to display the latest comments from the data server repository.

You can use the LVCOMMENT function in the following ways:

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

LVCOMMENT syntax

In the worksheet cell, type:

=LVCOMMENT("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:

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

Querying Comments using the Function Arguments dialog

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

To query a comment:

1. Click the Longview tab.
2. In the Formulas group, click Longview Functions, and click LVCOMMENT. 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.