Create Schedule

Use this command to create schedules using a text file. Create a new text file, and for each new schedule, on a separate line, include the following:

Item file syntax (for standard or static schedule)

syntax

where:

• SchedName is the name of the schedule.
• SchedDesc is the description of the schedule.
• SchedType is STANDARD or STATIC.
• ListDims is a list of the dimensions that do not receive rollups.
• ExtraDimsNum is the number of extra dimensions this schedule will have.
• ExtraDimName is the name of an extra dimension.
• ExtraDimDesc is the description of the extra dimension.
• MirrorType is one of MIRROR, SIMPLE SYMBOL, or NUMERIC.
  • For MirrorType = MIRROR:
    • DimName;Attr=Value is the name of a dimension, an attribute, and the value of that attribute.
    • LeafInclusion is either TRUE to include leaf symbols or FALSE and to not include leaf symbols.
    • SortType is the way symbols are sorted and can be UNSORTED to not sort symbols, SORT_NAME to sort symbols by name, or SORT_DESC to sort symbols by description.
  • For MirrorType = SIMPLE SYMBOL:
    • SymName1,SymName2,... is the list of symbols to be used in a schedule where MirrorType is SIMPLE SYMBOL.
  • For MirrorType = NUMERIC:
    • StartRange is the value at the beginning of a range in a schedule where MirrorType is NUMERIC.
    • EndRange is the value at the end of a range in a schedule where MirrorType is NUMERIC.
    • Padding is either TRUE to use decimal padding or FALSE to not use decimal padding.

Item file syntax (for intercompany schedule)

Create a new text file, and for each new schedule, on a separate line, include the following:

Syntax:

where:

• SchedName is the name of the schedule.
• SchedDesc is the description of the schedule.
• SchedType is STANDARD or STATIC.
• ListDims is a list of the dimensions that do not receive rollups.
• ExtraDimsNum is the number of extra dimensions this schedule will have.
• ExtraDimName is the name of an extra dimension.
• ExtraDimDesc is the description of the extra dimension.
• MirrorType is one of MIRROR, SIMPLE SYMBOL, or NUMERIC.
  • For MirrorType = MIRROR:
    • DimName;Attr=Value is the name of a dimension, an attribute, and the value of that attribute.
    • LeafInclusion is either TRUE to include leaf symbols or FALSE and to not include leaf symbols.
    • SortType is the way symbols are sorted and can be UNSORTED to not sort symbols, SORT_NAME to sort symbols by name, or SORT_DESC to sort symbols by description.
  • For MirrorType = SIMPLE SYMBOL:
    • SymName1,SymName2,... is the list of symbols to be used in a schedule where MirrorType is SIMPLE SYMBOL.
  • For MirrorType = NUMERIC:
    • StartRange is the value at the beginning of a range in a schedule where MirrorType is NUMERIC.
    • EndRange is the value at the end of a range in a schedule where MirrorType is NUMERIC.
    • Padding is either TRUE to use decimal padding or FALSE to not use decimal padding.
• OffsetFlag is either TRUE or FALSE and indicates whether or not there is an offset dimension.
• FixedDimFlag is either TRUE or FALSE and indicates whether or not there is a fixed dimension. This is used only when OffsetFlag is FALSE in an intercompany schedule.
• FixedDimSymName is the name of the fixed dimension symbol. This is used only when OffsetFlag is FALSE and FixedDimFlag is TRUE.

Syntax example - For STANDARD MIRROR schedule type

Syntax example - For INTERCOMPANY MIRROR schedule type with an offset dimension

Syntax example - For INTERCOMPANY MIRROR schedule type without an offset dimension

Syntax example - For NUMERIC schedule type

Syntax example - For SIMPLE SYMBOL schedule type

Syntax (with an ASCII file):

CREATE SCHEDULE @FileName

where:

• 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.