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.
Syntax regular:
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.
Syntax example:
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
Syntax (with an ASCII file):
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.
Syntax example:
MAINTENANCE ON
SWITCH SYMBOL ACCOUNTS @C:\Temp\SymSwitch.asc
MAINTENANCE OFF