LVLOCK Function

Using the LVLOCK function, you can define a section of the Longview data server repository to lock. Before you can submit data, you must lock the section of the data server repository that you plan to submit data to. This prevents conflicts with other users who are working with the server data.

Locks that you define with LVLOCK functions are not applied to the data server repository until you select one of the Apply Locks options from the Submit button in the ribbon.

For more information on applying locks, see Submitting data using the Longview Add-In for Office.

Use the LVLOCK function in conjunction with the LVSUBMIT function in the data submission process. For more information, see LVSUBMIT.

You can use the LVLOCK function in the following ways:

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

LVLOCK syntax

In the worksheet cell, type:

=LVLOCK("SymSpecs_dim1", "SymSpecs_dim2", "SymSpecs_dim3",…, "SymSpecs_dimN", "Comment")

where:

• SymSpecs_dimN is the symbol specification for the symbol or symbols in dimension N to include in the locked section of the Longview data server repository. Include at least one symbol specification for each dimension in the Longview data server repository.

For each symbol specification, specify a symbol name and the level of symbols below that symbol in the hierarchy to include in the locked section of the Longview data server repository. You can use the following:

If you specify multiple symbol specifications for a dimension, they must be delimited by commas ( , ).

Always type the symbol specifications 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, enter an account for the first symbol specification. To find out the order of the dimensions in the Longview data server repository, use the LVDIMNAME function. For more information, see LVDIMNAME.

Comment is a parameter that specifies a brief description of the lock. If you do not specify a comment, the lock description is left blank.

For example:

=LVLOCK("TOTASSET#99","FINYEAR#99","CHICAGOT","CUSD","DIM4SET#99","Longview Total Assets Lock")

Defining data to be locked using the Function Arguments dialog

You can define a section of the Longview data server repository to lock by completing the function parameters in the Function Arguments dialog.

To define data to be locked:

1. Click the Longview tab.
2. In the Formulas group, click Longview Functions, and click LVLOCK. 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 at least one symbol specification for each dimension in your system. You may use the Symbol Selector control or manually type in each symbol name.
   Comment	Enter a brief description of the lock.

4. Click OK. LVLOCK: Ready to lock appears in the worksheet cell.
5. Proceed to apply the lock to the data server repository. For more information, see Submitting data using the Longview Add-In for Office.