LVSLOCK Function

Using the LVSLOCK function, you can lock schedule-based data for a defined section of the Longview Data Server repository. 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 LVSLOCK 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 LVSLOCK function in conjunction with the LVSSUBMIT function in the data submission process. For more information, see LVSSUBMIT.

You can use the LVSLOCK function in the following ways:

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

LVSLOCK syntax

In the worksheet cell, type:

where:

• Schedule is the name of the schedule.

• 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 an optional parameter that specifies a brief description of the lock. If the comment field is left blank, the system automatically generates a default lock description using the workbook and schedule names.

For example:

Defining data to be locked using the Function Arguments dialog

You can define a section of the Longview data server repository to lock schedule-based data 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 LVSLOCK. 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.
   Schedule	Specify the name of the schedule.
   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. If the comment field is left blank, a default lock description is generated using the workbook and schedule names.

4. Click OK. LVSLOCK: Ready to create Schedule Lock appears in the worksheet cell.
5. Proceed to apply the lock to the data server repository.Then,the status changes to created Schedule lock. For more information, see Submitting data using the Longview Add-In for Office.