Switch Symbol

Use this command to move a symbol in the database from one parent symbol to another.

When you switch a parent symbol, you switch all its child symbols as well. The new parent symbol can reside in another hierarchy or the same hierarchy as the original parent. You can have a maximum of 47 levels in a hierarchy in the Data Server repository.

This command must be used in conjunction with Maintenance. While it is enabled, no other users can perform maintenance related activities in the Data Server repository. When you are finished, you must remember to disable the Maintenance mode, and thereby allow normal access by other users. For more information, see Maintenance or Exclusive.

SWITCH SYMBOL DimName SymName PARENT FROM OldParent TO NewParent "Weight"        

where:

• DimName is a dimension that contains the symbol.
• SymName is the name of the symbol.
• OldParent is the name of the old parent symbol.
• NewParent is the name of the new parent symbol.
• "Weight" is one of the following:

  Value	Description
  + or 1	To add the symbol’s value to the specified parent value.
  - or -1	To subtract the symbol’s value from the specified parent value.
  0	To ensure the symbol has no mathematical effect on the specified parent value.

Note: For the Accounts dimension, weight is determined by the credit/debit balance relationship of the parent and child symbols.

MAINTENANCE ON
SWITCH SYMBOL ACCOUNTS NewSales PARENT FROM Regional TO National +        
MAINTENANCE OFF    

Creating ASCII input files

To switch a large number of symbols in the database, create a text file specifying the following information for each symbol:

SymName{PARENT{FROM{OldParent[TO{NewParent{Weight

SWITCH SYMBOL DimName @SymFileName            

where:

• DimName is a dimension that contains the symbol.
• @SymFileName is an ASCII file containing the data. It can include a complete or partial folder path in the format C:\...\FileName. If FileName includes spaces, enclose it in double quotation marks; for example:

  @"C:\My Documents\My Data.txt"

Note: If the document is in the same location as lv_af.exe, you do not need to specify the drive or path.

MAINTENANCE ON
SWITCH SYMBOL ACCOUNTS @C:\Temp\SymSwitch.asc             
MAINTENANCE OFF