Skip to main content
insightsoftware Documentation insightsoftware Documentation
{%article.title%}
Published:
Was this article helpful?
0 out of 0 found this helpful

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)

Copy

syntax 

SchedName
SchedDesc
SchedType
ListDims
ExtraDimsNum
ExtraDimName
ExtraDimDesc
MirrorType
For MirrorType = MIRROR:
DimName;Attr=Value
LeafInclusion
SortType
For MirrorType = SIMPLE SYMBOL:                                        
SymName1,SymName2,...
SortType
For MirrorType = NUMERIC:
StartRange,EndRange,Padding
SortType

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:

Copy

Syntax

SchedName
SchedDesc
SchedType
ListDims
ExtraDimsNum
ExtraDimName
ExtraDimDesc
MirrorType
For MirrorType = MIRROR:
DimName;Attr=Value
LeafInclusion
SortType
For MirrorType = SIMPLE SYMBOL:                            
SymName1,SymName2,...
SortType
For MirrorType = NUMERIC:
StartRange,EndRange,Padding
SortType
OffsetFlag
FixedDimFlag
FixedDimSymName

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

Syntax example - For STANDARD MIRROR schedule type

MirrorSched1
Standard Mirror Schedule Example with 1 dimension        
STANDARD
NONE
1
DIMNAME1
"Dimension 1 Description
MIRROR
ACCOUNTS;DIM0SET
FALSE
UNSORTED
Copy

Syntax example - For STANDARD MIRROR schedule type with two dimensions

MirrorSched2
Standard Mirror Schedule Example with two dimensions            
STANDARD
NONE
2
DIMNAME1
"Dimension 1 Description
MIRROR
ACCOUNTS;DIM0SET
FALSE
UNSORTED
DIMNAME2
"Dimension 2 Description
MIRROR
ENTITIES
FALSE
UNSORTED
Copy

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

MirrorSched3
Intercompany Mirror Schedule Example with offset dimension        
INTERCOMPANY
NONE
1
OFFSET
"Dimension 1 Description
MIRROR
ENTITIES
FALSE
UNSORTED
TRUE
Copy

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

MirrorSched4
Intercompany Mirror Schedule Example without offset dimension        
INTERCOMPANY
NONE
1
NONOFF
"Dimension 1 Description
MIRROR
ACCOUNTS;DIM0SET
FALSE
UNSORTED
FALSE
TRUE
DIM0SET
Copy

Syntax example - For NUMERIC schedule type

NumericSched
Numeric Schedule
STANDARD
NONE
1
DIMENSION1
"Dimension 1 Description            
NUMERIC
1,100,False
UNSORTED
Copy

Syntax example - For SIMPLE SYMBOL schedule type

SimpleSymSched                                
Simple Symbol Schedule
STANDARD
NONE
1
DIMNAME
"Dimension Description 1
SIMPLE SYMBOL
Taxes,Fees,Other
UNSORTED
Copy

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.
Published:

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)

Copy

syntax 

SchedName
SchedDesc
SchedType
ListDims
ExtraDimsNum
ExtraDimName
ExtraDimDesc
MirrorType
For MirrorType = MIRROR:
DimName;Attr=Value
LeafInclusion
SortType
For MirrorType = SIMPLE SYMBOL:                                        
SymName1,SymName2,...
SortType
For MirrorType = NUMERIC:
StartRange,EndRange,Padding
SortType

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:

Copy

Syntax

SchedName
SchedDesc
SchedType
ListDims
ExtraDimsNum
ExtraDimName
ExtraDimDesc
MirrorType
For MirrorType = MIRROR:
DimName;Attr=Value
LeafInclusion
SortType
For MirrorType = SIMPLE SYMBOL:                            
SymName1,SymName2,...
SortType
For MirrorType = NUMERIC:
StartRange,EndRange,Padding
SortType
OffsetFlag
FixedDimFlag
FixedDimSymName

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

Syntax example - For STANDARD MIRROR schedule type

MirrorSched1
Standard Mirror Schedule Example with 1 dimension        
STANDARD
NONE
1
DIMNAME1
"Dimension 1 Description
MIRROR
ACCOUNTS;DIM0SET
FALSE
UNSORTED
Copy

Syntax example - For STANDARD MIRROR schedule type with two dimensions

MirrorSched2
Standard Mirror Schedule Example with two dimensions            
STANDARD
NONE
2
DIMNAME1
"Dimension 1 Description
MIRROR
ACCOUNTS;DIM0SET
FALSE
UNSORTED
DIMNAME2
"Dimension 2 Description
MIRROR
ENTITIES
FALSE
UNSORTED
Copy

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

MirrorSched3
Intercompany Mirror Schedule Example with offset dimension        
INTERCOMPANY
NONE
1
OFFSET
"Dimension 1 Description
MIRROR
ENTITIES
FALSE
UNSORTED
TRUE
Copy

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

MirrorSched4
Intercompany Mirror Schedule Example without offset dimension        
INTERCOMPANY
NONE
1
NONOFF
"Dimension 1 Description
MIRROR
ACCOUNTS;DIM0SET
FALSE
UNSORTED
FALSE
TRUE
DIM0SET
Copy

Syntax example - For NUMERIC schedule type

NumericSched
Numeric Schedule
STANDARD
NONE
1
DIMENSION1
"Dimension 1 Description            
NUMERIC
1,100,False
UNSORTED
Copy

Syntax example - For SIMPLE SYMBOL schedule type

SimpleSymSched                                
Simple Symbol Schedule
STANDARD
NONE
1
DIMNAME
"Dimension Description 1
SIMPLE SYMBOL
Taxes,Fees,Other
UNSORTED
Copy

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.
For an optimal Community experience, Please view on Desktop