Assign Symbol

Use this command to specify a parent symbol for a child symbol in the Data Server repository.

You can use the Assign Symbol command to specify a parent symbol for an unattached child symbol in the Data Server repository, or to specify multiple parent symbols for an attached child symbol in the Data Server repository. 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.

Note: If you have an existing database that is already partitioned, and you want to add child symbols and assign parent symbols, add the child symbols first, and then assign them to the appropriate parents. If you add a symbol, and then make it a parent, Longview Application Framework moves the symbol to a different partition, and you will not be able to assign the parent/child relationship properly.

ASSIGN SYMBOL DimName ChildSymName PARENT ParentSymName ["Weight" [Priority]]        

where:

• DimName is a dimension containing the symbol.
• ChildSymName is a child symbol.
• ParentSymName is a parent symbol. You can have a maximum of 47 levels in a hierarchy in the Data Server repository.
• Weight is the mathematical effect of the child symbol on its parent symbol, enclosed in double quotation marks. Valid options are "+", "-", and "0". This parameter is optional.
• Priority is a number that designates the symbol’s position in the hierarchy relative to its parent. Symbols are listed in order of ascending priority, with zeros falling at the bottom of the list. This parameter is optional; however, you can specify Priority only if you also specify Weight.

MAINTENANCE ON
ASSIGN SYMBOL ACCOUNTS NewSales PARENT SaleT "+" 1                
MAINTENANCE OFF            

Creating an ASCII input file

To specify parent symbols for a large number of symbols, specify the parameters for this command in an ASCII file.

Create an ASCII file containing the following information for each symbol:

ChildSymName{PARENT{ParentSymName{Weight[Priority]            

ASSIGN SYMBOL DimName @FileName                            

where:

• DimName is a dimension containing the symbols.
• FileName 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
ASSIGN SYMBOL ACCOUNTS @C:\Temp\Test.asc            
MAINTENANCE OFF

See also

• Create Symbol