LVSUBMIT Function

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

Data values that you define with LVSUBMIT functions 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 value at a time for each cell containing an LVSUBMIT function.
• You can submit data only to leaf cells or static parents in the Longview data server repository.
• You can submit base data only. You cannot submit schedule data.

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

You can use the LVSUBMIT function in the following ways:

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

LVSUBMIT syntax

In the worksheet cell, type:

=LVSUBMIT("Sym_dim1", "Sym_dim2", "Sym_dim3",…, "Sym_dimN", Value)

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.

Value is the value to be submitted to the data server repository. If the value to submit is a character string, enclose it in double quotation marks. If the value to submit is numeric, do not enclose it in double quotation marks.

For example:

=LVSUBMIT("HEADCOUNT","FINYEAR","CHICAGO","CUSD","DIM4SET",100)

Defining data to be submitted using the Function Arguments dialog

You can define a data value 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 LVSUBMIT. 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.
   value	Enter the value to be submitted to the data server repository.

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