Siebel Consumer Goods Guide > Sales Volume Planning >

Locking and Modifying SVP Data (End User)

Locking allows users to modify data throughout the account-product-category hierarchy without interfering with the modifications of other users.

The SVP module offers two options for locking account-product nodes:

• Automatic locking based on the account-product node's position in the SVP hierarchy. Any user in the account hierarchy can automatically lock a node to prevent users at lower positions in the account hierarchy from modifying their account-product nodes.
• Manual locking.

This task is a step in Roadmap for Sales Volume Planning.

Automatically Locking Account-Product Nodes

To prevent overwriting numbers, account nodes must be locked before their numbers can be edited. Locking a node prevents other people from making any modifications to any ascendant account node or any descendant account node. The SVP module uses an allocation lock process during the allocation and aggregation process. An allocation lock is a Boolean variable that is kept at the highest account level. When an allocation lock is set, the lock prevents all subordinate account levels from updating SVP data. Before an allocation lock is granted, the application checks the current account node to confirm that its upper lock is active and searches to ascertain that no allocation lock is currently held in the superior account node.

Allocation locks are maintained for the account hierarchy. In a single instance of the category-product hierarchy, all updates are allocated and aggregated immediately.

After a user completes SVP allocation-related updates, the actual allocation is invoked, and the application modifies the locks as follows:

• By updating the upper lock in the originating allocation node
• By disallowing further changes there until the user performs the Aggregate action

NOTE:  You can see the nodes that are locked by viewing the Allocate Lock column in the Accounts list in the Sales Volume Planning screen. You might need to manually refresh this view to see the results of a recently attempted lock request.

Locking, Modifying, and Allocating Account-Product Nodes

You can lock and unlock an account-product node manually. However, you can unlock the account-product node only if no changes are made. If changes are made, the node remains locked until one of the following actions occurs:

• The changes are allocated.
• A user performs an aggregate action, and the specific updates are aggregated up the organizational hierarchy.

The following procedure uses baseline planning quantity as an example to describe how to lock and modify account-product nodes. It also includes information about how locking and unlocking can occur automatically.

To lock, modify, and allocate the baseline planning quantity

1. Navigate to the Sales Volume Planning screen, then the Baseline view.
2. In the Accounts list, select an account record.
3. Lock the category for which you want to modify the baseline planning quantity as follows:
   • To lock the category manually, click Lock.
   • To lock the category automatically:
     • In the Category list, select the category for which you want to modify the baseline planning quantity.
     • Optionally, navigate down to the product list, and select the product for which you want to modify the baseline planning quantity.
4. Scroll down to the Category Baseline or Product Baseline list, select the record that you want to modify, and edit the fields.

   Modifying a baseline planning value automatically locks the selected account nodes when connected to the server (even if you did not click Lock in Step 3).

5. To apply the same change to multiple periods, click Mass Change, complete the fields in the Baseline Mass Change dialog box, and click Execute.

   Adjustments that you make to the baseline planning quantity affect only the products and categories in the account.

6. Perform one of the following steps to view the navigation mechanism for the Product Baseline:
   1. Navigate to a category sublevel. In the Category Baseline list, from the Category Baseline drop-down list, select one of the following values:
      • Period Analysis
      • Sub-Account Baseline
      • Sub-Category Baseline
      • Sub-Product Baseline
   2. Navigate to a product sublevel, and perform the following steps:
      • In the Category List, select a product.
      • Scroll down to the Product Baseline list, and from the Product Baseline drop-down list, select Sub-Account Baseline.
   3. In the Category Baseline or Product Baseline lists, click Refresh.

      This step is for informational purposes only to see how Step 4 and Step 5 (if executed) impact the allocation of values for an account down through the category hierarchy. The Basis% field is recalculated to reflect the new proportions of the account-product hierarchy.

7. Repeat Step 4 until you finish modifying the basis planning quantity.
8. Scroll up to the Accounts list, and click Allocate.

   The baseline planning quantity is allocated to the next lower level of the account hierarchy. When the allocate action is complete, the account-product node is unlocked. Managers at the next lower level of the account hierarchy repeat this process until the baseline planning quantity is allocated to the lowest level of the account hierarchy.

   NOTE:  If the allocation does not complete (due to pending subaction records that are not processed), then the action does not complete, and the account remains in locked mode.