LVSUBMITCOMMENT Function

Using the LVSUBMITComment function, you can define a comments to be submitted to the Longview data server repository. Before you submit comments to base data cells, you must lock the section of the data server repository that you plan to submit data to. For more information, see LVLOCK.

Comments that you define with LVSUBMITCOMMENT function are not submitted to the data server repository until you select one of the Submit options from the Submit button in the ribbon. For more information, see Submitting data using the Longview Add-In for Office.

Keep in mind the following when using this function:

• You can submit one Comment at a time for each cell containing an LVSUBMITCOMMENT function.

Note: Longview recommends that you avoid using two or more LVSUBMITCOMMENT functions that specify the exact same coordinates for a data server repository cell but different data values, in the same worksheet. If you use LVSUBMITCOMMENT functions in this way, unexpected behavior can occur.

You can use the LVSUBMITCOMMENT function in the following ways:

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

LVSUBMITCOMMENT syntax

In the worksheet cell, type:

=LVSUBMITCOMMENT("Sym_dim1", "Sym_dim2", "Sym_dim3",..., "Sym_dimN", "Comment")

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 only 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.

• Comment specifies the text of the comment to be submitted.

For example:

=LVSUBMITCOMMENT("HEADCOUNT","FINYEAR","CHICAGO","CUSD","DIM4SET","Longview comment")

Defining data to be submitted using the Function Arguments dialog

You can define a comment to be submitted to the Longview data server repository by completing the function parameters in the Function Arguments dialog.

To define data to be submitted:

1. Click the Longview tab.
2. In the Formulas group, click Longview Functions, and click LVSUBMITCOMMENT. The Function Arguments dialog opens.
3. Complete the following fields, where N is the total number of dimensions in your system:

   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 one symbol specification for each dimension in your system.
   Comment	Enter the comment to be submitted to the data server repository.

4. Click OK. LVSUBMITCOMMENT: Ready to submit (Comment) appears in the worksheet cell, where Comment is the text entered in the Comment field.
5. Proceed to submit data from the LVSUBMITCOMMENT cell to the data server.For more information, see Submitting data using the Longview Add-In for Office.