Quintiq file version 2.0
|
#parent: #root
|
EDIBroker SM_ImportStrategiesBroker
|
{
|
MDSDefinition: ScenarioManager
|
EDIModelLink.Destination OutputStrategiesToModel0
|
{
|
EDIMLTable KPIWeight
|
{
|
PrimaryKeyColumns: KPIName
|
PrimaryKeyColumns: StrategyName
|
TargetType: KPIWeight
|
TypeIndex: KPIWeightTypeIndex
|
EDIMLColumn KPIName { Attribute: KPIName ValueType: String }
|
EDIMLColumn Level { Attribute: Level ValueType: Number }
|
EDIMLColumn StrategyName { Attribute: StrategyName ValueType: String }
|
EDIMLColumn Weight { Attribute: Weight ValueType: Real }
|
EDIMLTableOwner
|
{
|
TargetType: Strategy
|
TypeIndex: StrategyTypeIndex
|
EDIMLForeignKeyColumn
|
{
|
Column: StrategyName
|
TypeIndexAttribute: Name
|
}
|
}
|
}
|
EDIMLTable Strategy
|
{
|
PrimaryKeyColumns: Name
|
TargetType: Strategy
|
TypeIndex: StrategyTypeIndex
|
EDIMLColumn DefaultNumberOfPeriodsForAvgDemand { Attribute: DefaultNumberOfPeriodsForAvgDemand ValueType: Number }
|
EDIMLColumn Description { Attribute: Description ValueType: String }
|
EDIMLColumn DurationInventoryMixBalancingCheck { Attribute: DurationInventoryMixBalancingCheck ValueType: Duration }
|
EDIMLColumn DurationLotsizeHorizon { Attribute: DurationLotsizeHorizon ValueType: Duration }
|
EDIMLColumn InventoryHoldingScalingFactor { Attribute: InventoryHoldingScalingFactor ValueType: Real }
|
EDIMLColumn IsVisible { Attribute: IsVisible ValueType: Boolean }
|
EDIMLColumn LastAutoScalingRun { Attribute: LastAutoScalingRun ValueType: DateTime }
|
EDIMLColumn MassScalingFactor { Attribute: MassScalingFactor ValueType: Real }
|
EDIMLColumn MetaOptimizerFirstLevelHasOverride { Attribute: MetaOptimizerFirstLevelHasOverride ValueType: Boolean }
|
EDIMLColumn MetaOptimizerFirstLevelOverride { Attribute: MetaOptimizerFirstLevelOverride ValueType: Number }
|
EDIMLColumn MetaOptimizerRunFullPlanPriorToFocus { Attribute: MetaOptimizerRunFullPlanPriorToFocus ValueType: Boolean }
|
EDIMLColumn MetaOptimizerLastLevelHasOverride { Attribute: MetaOptimizerLastLevelHasOverride ValueType: Boolean }
|
EDIMLColumn MetaOptimizerLastLevelOverride { Attribute: MetaOptimizerLastLevelOverride ValueType: Number }
|
EDIMLColumn MetaOptimizerMaxNumberOfSecondsAllIterations { Attribute: MetaOptimizerMaxNumberOfSecondsAllIterations ValueType: Number }
|
EDIMLColumn MetaOptimizerMinimizeInvEndAfterLastLevel { Attribute: MetaOptimizerMinimizeInvEndAfterLastLevel ValueType: Boolean }
|
EDIMLColumn MetaOptimizerIsCollapseLevel { Attribute: MetaOptimizerIsCollapseLevel ValueType: Boolean }
|
EDIMLColumn MetaOptimizerCollapseLevelWeight { Attribute: MetaOptimizerCollapseLevelWeight ValueType: Real }
|
EDIMLColumn MonetaryScalingFactor { Attribute: MonetaryScalingFactor ValueType: Real }
|
EDIMLColumn Name { Attribute: Name ValueType: String }
|
EDIMLColumn NumberOfPeriodsInWindow { Attribute: NumberOfPeriodsInWindow ValueType: Number }
|
EDIMLColumn NumberOfPeriodsPerSlide { Attribute: NumberOfPeriodsPerSlide ValueType: Number }
|
EDIMLColumn NumberOfPeriodsSmartPlan { Attribute: NumberOfPeriodsSmartPlan ValueType: Number }
|
EDIMLColumn TimeAccountScalingFactor { Attribute: TimeAccountScalingFactor ValueType: Real }
|
EDIMLColumn TimeScalingFactor { Attribute: TimeScalingFactor ValueType: Real }
|
EDIMLColumn UseCampaignSequenceOptimizer { Attribute: UseCampaignSequenceOptimizer ValueType: Boolean }
|
EDIMLColumn UseMetaOptimizer { Attribute: UseMetaOptimizer ValueType: Boolean }
|
EDIMLColumn UseSlidingWindowsApproach { Attribute: UseSlidingWindowsApproach ValueType: Boolean }
|
EDIMLColumn MaxNrOfElemementsCampaignOptimizerCombi { Attribute: MaxNrOfElemementsCampaignOptimizerCombi ValueType: Number }
|
EDIMLColumn UseHierarchicalSolver { Attribute: UseHierarchicalSolver ValueType: Boolean }
|
EDIMLColumn UseShiftOptimization { Attribute: UseShiftOptimization ValueType: Boolean }
|
}
|
EDIMLTable StrategyLevel
|
{
|
PrimaryKeyColumns: Level
|
PrimaryKeyColumns: StrategyName
|
TargetType: StrategyLevel
|
TypeIndex: StrategyLevelTypeIndex
|
EDIMLColumn AbsoluteGap { Attribute: AbsoluteGap ValueType: Real }
|
EDIMLColumn Level { Attribute: Level ValueType: Number }
|
EDIMLColumn RelativeGap { Attribute: RelativeGap ValueType: Real }
|
EDIMLColumn RelativeGoalSlack { Attribute: RelativeGoalSlack ValueType: Real }
|
EDIMLColumn SolverSettingGroupName { Attribute: SolverSettingGroupName ValueType: String }
|
EDIMLColumn StrategyName { Attribute: StrategyName ValueType: String }
|
EDIMLColumn TimeLimit { Attribute: TimeLimit ValueType: Number }
|
EDIMLColumn UseAbsoluteGap { Attribute: UseAbsoluteGap ValueType: Boolean }
|
EDIMLColumn MetaLastAutoScalingRun { Attribute: MetaLastAutoScalingRun ValueType: DateTime }
|
EDIMLColumn MetaScalingFactorInventoryHolding { Attribute: MetaScalingFactorInventoryHolding ValueType: Real }
|
EDIMLColumn MetaScalingFactorMass { Attribute: MetaScalingFactorMass ValueType: Real }
|
EDIMLColumn MetaScalingFactorMonetary { Attribute: MetaScalingFactorMonetary ValueType: Real }
|
EDIMLColumn MetaScalingFactorTime { Attribute: MetaScalingFactorTime ValueType: Real }
|
EDIMLColumn MetaScalingFactorTimeAccount { Attribute: MetaScalingFactorTimeAccount ValueType: Real }
|
EDIMLColumn UseHierarchicalSolverAbsTolerance { Attribute: UseHierarchicalSolverAbsTolerance ValueType: Boolean }
|
EDIMLColumn UseHierarchicalSolverRelTolerance { Attribute: UseHierarchicalSolverRelTolerance ValueType: Boolean }
|
EDIMLColumn HierarchicalSolverAbsTolerance { Attribute: HierarchicalSolverAbsTolerance ValueType: Real }
|
EDIMLColumn HierarchicalSolverRelTolerance { Attribute: HierarchicalSolverRelTolerance ValueType: Real }
|
EDIMLTableOwner
|
{
|
TargetType: Strategy
|
TypeIndex: StrategyTypeIndex
|
EDIMLForeignKeyColumn
|
{
|
Column: StrategyName
|
TypeIndexAttribute: Name
|
}
|
}
|
}
|
}
|
EDITransformation.Transformation TransformStrategiesForInput
|
{
|
EDITableTransformation
|
{
|
InputTable: KPIWeights_SM
|
OutputTable: KPIWeight
|
EDIColumnMatch
|
{
|
InputColumn: StrategyName
|
OutputColumn: StrategyName
|
}
|
EDIColumnMatch
|
{
|
InputColumn: Level
|
OutputColumn: Level
|
}
|
EDIColumnMatch
|
{
|
InputColumn: KPIName
|
OutputColumn: KPIName
|
}
|
EDIColumnMatch
|
{
|
InputColumn: Weight
|
OutputColumn: Weight
|
}
|
}
|
EDITableTransformation
|
{
|
InputTable: Strategies_SM
|
OutputTable: Strategy
|
EDIColumnMatch { InputColumn: DefaultNumberOfPeriodsForAvgDemand OutputColumn: DefaultNumberOfPeriodsForAvgDemand }
|
EDIColumnMatch { InputColumn: DurationInventoryMixBalancingCheck OutputColumn: DurationInventoryMixBalancingCheck }
|
EDIColumnMatch { InputColumn: DurationLotsizeHorizon OutputColumn: DurationLotsizeHorizon }
|
EDIColumnMatch { InputColumn: MetaOptimizerFirstLevelHasOverride OutputColumn: MetaOptimizerFirstLevelHasOverride }
|
EDIColumnMatch { InputColumn: MetaOptimizerFirstLevelOverride OutputColumn: MetaOptimizerFirstLevelOverride }
|
EDIColumnMatch { InputColumn: MetaOptimizerRunFullPlanPriorToFocus OutputColumn: MetaOptimizerRunFullPlanPriorToFocus }
|
EDIColumnMatch { InputColumn: MetaOptimizerLastLevelHasOverride OutputColumn: MetaOptimizerLastLevelHasOverride }
|
EDIColumnMatch { InputColumn: MetaOptimizerLastLevelOverride OutputColumn: MetaOptimizerLastLevelOverride }
|
EDIColumnMatch { InputColumn: MetaOptimizerMaxNumberOfSecondsAllIterations OutputColumn: MetaOptimizerMaxNumberOfSecondsAllIterations }
|
EDIColumnMatch { InputColumn: MetaOptimizerMinimizeInvEndAfterLastLevel OutputColumn: MetaOptimizerMinimizeInvEndAfterLastLevel }
|
EDIColumnMatch { InputColumn: MetaOptimizerIsCollapseLevel OutputColumn: MetaOptimizerIsCollapseLevel }
|
EDIColumnMatch { InputColumn: MetaOptimizerCollapseLevelWeight OutputColumn: MetaOptimizerCollapseLevelWeight }
|
EDIColumnMatch
|
{
|
InputColumn: MonetaryScalingFactor
|
OutputColumn: MonetaryScalingFactor
|
}
|
EDIColumnMatch
|
{
|
InputColumn: Name
|
OutputColumn: Name
|
}
|
EDIColumnMatch { InputColumn: NumberOfPeriodsInWindow OutputColumn: NumberOfPeriodsInWindow }
|
EDIColumnMatch { InputColumn: NumberOfPeriodsPerSlide OutputColumn: NumberOfPeriodsPerSlide }
|
EDIColumnMatch { InputColumn: NumberOfPeriodsSmartPlan OutputColumn: NumberOfPeriodsSmartPlan }
|
EDIColumnMatch
|
{
|
InputColumn: TimeAccountScalingFactor
|
OutputColumn: TimeAccountScalingFactor
|
}
|
EDIColumnMatch
|
{
|
InputColumn: MassScalingFactor
|
OutputColumn: MassScalingFactor
|
}
|
EDIColumnMatch
|
{
|
InputColumn: Description
|
OutputColumn: Description
|
}
|
EDIColumnMatch
|
{
|
InputColumn: InventoryHoldingScalingFactor
|
OutputColumn: InventoryHoldingScalingFactor
|
}
|
EDIColumnMatch
|
{
|
InputColumn: IsVisible
|
OutputColumn: IsVisible
|
}
|
EDIColumnMatch { InputColumn: LastAutoScalingRun OutputColumn: LastAutoScalingRun }
|
EDIColumnMatch { InputColumn: TimeScalingFactor OutputColumn: TimeScalingFactor }
|
EDIColumnMatch { InputColumn: UseCampaignSequenceOptimizer OutputColumn: UseCampaignSequenceOptimizer }
|
EDIColumnMatch { InputColumn: UseMetaOptimizer OutputColumn: UseMetaOptimizer }
|
EDIColumnMatch { InputColumn: UseSlidingWindowsApproach OutputColumn: UseSlidingWindowsApproach }
|
EDIColumnMatch { InputColumn: MaxNrOfElemementsCampaignOptimizerCombi OutputColumn: MaxNrOfElemementsCampaignOptimizerCombi }
|
EDIColumnMatch { InputColumn: UseHierarchicalSolver OutputColumn: UseHierarchicalSolver }
|
EDIColumnMatch { InputColumn: UseShiftOptimization OutputColumn: UseShiftOptimization }
|
}
|
EDITableTransformation
|
{
|
InputTable: StrategyLevels_SM
|
OutputTable: StrategyLevel
|
EDIColumnMatch { InputColumn: Level OutputColumn: Level }
|
EDIColumnMatch
|
{
|
InputColumn: SolverSettingGroupName
|
OutputColumn: SolverSettingGroupName
|
}
|
EDIColumnMatch
|
{
|
InputColumn: StrategyName
|
OutputColumn: StrategyName
|
}
|
EDIColumnMatch
|
{
|
InputColumn: TimeLimit
|
OutputColumn: TimeLimit
|
}
|
EDIColumnMatch
|
{
|
InputColumn: RelativeGoalSlack
|
OutputColumn: RelativeGoalSlack
|
}
|
EDIColumnMatch
|
{
|
InputColumn: RelativeGap
|
OutputColumn: RelativeGap
|
}
|
EDIColumnMatch
|
{
|
InputColumn: AbsoluteGap
|
OutputColumn: AbsoluteGap
|
}
|
EDIColumnMatch
|
{
|
InputColumn: UseAbsoluteGap
|
OutputColumn: UseAbsoluteGap
|
}
|
EDIColumnMatch
|
{
|
InputColumn: MetaLastAutoScalingRun
|
OutputColumn: MetaLastAutoScalingRun
|
}
|
EDIColumnMatch
|
{
|
InputColumn: MetaScalingFactorInventoryHolding
|
OutputColumn: MetaScalingFactorInventoryHolding
|
}
|
EDIColumnMatch
|
{
|
InputColumn: MetaScalingFactorMass
|
OutputColumn: MetaScalingFactorMass
|
}
|
EDIColumnMatch
|
{
|
InputColumn: MetaScalingFactorMonetary
|
OutputColumn: MetaScalingFactorMonetary
|
}
|
EDIColumnMatch
|
{
|
InputColumn: MetaScalingFactorTime
|
OutputColumn: MetaScalingFactorTime
|
}
|
EDIColumnMatch
|
{
|
InputColumn: MetaScalingFactorTimeAccount
|
OutputColumn: MetaScalingFactorTimeAccount
|
}
|
EDIColumnMatch
|
{
|
InputColumn: UseHierarchicalSolverAbsTolerance
|
OutputColumn: UseHierarchicalSolverAbsTolerance
|
}
|
EDIColumnMatch
|
{
|
InputColumn: UseHierarchicalSolverRelTolerance
|
OutputColumn: UseHierarchicalSolverRelTolerance
|
}
|
EDIColumnMatch
|
{
|
InputColumn: HierarchicalSolverAbsTolerance
|
OutputColumn: HierarchicalSolverAbsTolerance
|
}
|
EDIColumnMatch
|
{
|
InputColumn: HierarchicalSolverRelTolerance
|
OutputColumn: HierarchicalSolverRelTolerance
|
}
|
}
|
}
|
EDIXLSLink.Source InputStrategiesFromExcel
|
{
|
FileName: 'SM_Strategies.xlsx'
|
EDIXLSLinkTable KPIWeights_SM
|
{
|
Columns:
|
[
|
EDIXLSLinkColumn KPIName { ValueType: String }
|
EDIXLSLinkColumn Level { ValueType: Number }
|
EDIXLSLinkColumn StrategyName { ValueType: String }
|
EDIXLSLinkColumn Weight { ValueType: Real }
|
]
|
}
|
EDIXLSLinkTable Strategies_SM
|
{
|
Columns:
|
[
|
EDIXLSLinkColumn DefaultNumberOfPeriodsForAvgDemand { ValueType: Number }
|
EDIXLSLinkColumn Description { ValueType: String }
|
EDIXLSLinkColumn DurationInventoryMixBalancingCheck { ValueType: Duration }
|
EDIXLSLinkColumn DurationLotsizeHorizon { ValueType: Duration }
|
EDIXLSLinkColumn InventoryHoldingScalingFactor { ValueType: Real }
|
EDIXLSLinkColumn IsVisible { ValueType: Boolean }
|
EDIXLSLinkColumn LastAutoScalingRun { ValueType: DateTime }
|
EDIXLSLinkColumn MassScalingFactor { ValueType: Real }
|
EDIXLSLinkColumn MaxNrOfElemementsCampaignOptimizerCombi { ValueType: Number }
|
EDIXLSLinkColumn MetaOptimizerFirstLevelHasOverride { ValueType: Boolean }
|
EDIXLSLinkColumn MetaOptimizerFirstLevelOverride { ValueType: Real }
|
EDIXLSLinkColumn MetaOptimizerRunFullPlanPriorToFocus { ValueType: Boolean }
|
EDIXLSLinkColumn MetaOptimizerLastLevelHasOverride { ValueType: Boolean }
|
EDIXLSLinkColumn MetaOptimizerLastLevelOverride { ValueType: Real }
|
EDIXLSLinkColumn MetaOptimizerMaxNumberOfSecondsAllIterations { ValueType: Number }
|
EDIXLSLinkColumn MetaOptimizerMinimizeInvEndAfterLastLevel { ValueType: Boolean }
|
EDIXLSLinkColumn MetaOptimizerIsCollapseLevel { ValueType: Boolean }
|
EDIXLSLinkColumn MetaOptimizerCollapseLevelWeight { ValueType: Real }
|
EDIXLSLinkColumn MonetaryScalingFactor { ValueType: Real }
|
EDIXLSLinkColumn Name { ValueType: String }
|
EDIXLSLinkColumn NumberOfPeriodsInWindow { ValueType: Number }
|
EDIXLSLinkColumn NumberOfPeriodsPerSlide { ValueType: Number }
|
EDIXLSLinkColumn NumberOfPeriodsSmartPlan { ValueType: Number }
|
EDIXLSLinkColumn TimeAccountScalingFactor { ValueType: Real }
|
EDIXLSLinkColumn TimeScalingFactor { ValueType: Real }
|
EDIXLSLinkColumn UseMetaOptimizer { ValueType: Boolean }
|
EDIXLSLinkColumn UseSlidingWindowsApproach { ValueType: Boolean }
|
EDIXLSLinkColumn UseCampaignSequenceOptimizer { ValueType: Boolean }
|
EDIXLSLinkColumn UseHierarchicalSolver { ValueType: Boolean }
|
EDIXLSLinkColumn UseShiftOptimization { ValueType: Boolean }
|
]
|
}
|
EDIXLSLinkTable StrategyLevels_SM
|
{
|
Columns:
|
[
|
EDIXLSLinkColumn AbsoluteGap { ValueType: Real }
|
EDIXLSLinkColumn Level { ValueType: Number }
|
EDIXLSLinkColumn RelativeGap { ValueType: Real }
|
EDIXLSLinkColumn RelativeGoalSlack { ValueType: Real }
|
EDIXLSLinkColumn SolverSettingGroupName { ValueType: String }
|
EDIXLSLinkColumn StrategyName { ValueType: String }
|
EDIXLSLinkColumn TimeLimit { ValueType: Number }
|
EDIXLSLinkColumn UseAbsoluteGap { ValueType: Boolean }
|
EDIXLSLinkColumn MetaLastAutoScalingRun { ValueType: DateTime }
|
EDIXLSLinkColumn MetaScalingFactorInventoryHolding { ValueType: Real }
|
EDIXLSLinkColumn MetaScalingFactorMass { ValueType: Real }
|
EDIXLSLinkColumn MetaScalingFactorMonetary { ValueType: Real }
|
EDIXLSLinkColumn MetaScalingFactorTime { ValueType: Real }
|
EDIXLSLinkColumn MetaScalingFactorTimeAccount { ValueType: Real }
|
EDIXLSLinkColumn UseHierarchicalSolverAbsTolerance { ValueType: Boolean }
|
EDIXLSLinkColumn UseHierarchicalSolverRelTolerance { ValueType: Boolean }
|
EDIXLSLinkColumn HierarchicalSolverAbsTolerance { ValueType: Real }
|
EDIXLSLinkColumn HierarchicalSolverRelTolerance { ValueType: Real }
|
]
|
}
|
}
|
}
|
