大家好,亨利(@henri_wajsblat),tristan(@tristan.colgate),我正在开始一系列新的讨论主题。本周的主题将涉及Anaplan的优化功能。优化器是一个相对较新的功能,它使用线性编程来使最终用户通过在指定约束中最大化或最小化目标来解决复杂问题。当我第一次阅读它时,我立即想起了Excel的求解器附加组件,我确实认为这两个非常相似。但是,Anaplan的优化器可以在更大的数据集上工作,并根据对仪表板的访问具有安全性。Anaplan的优化器也由Gurobi提供动力,Gurobi是最快的优化求解器。优化器具有许多用例,其中许多可以在Anaplan的白皮书中找到。优化器可用于“假设”方案,并根据最佳选择帮助组织计划。在设置优化器之前需要采取几个步骤:确定您的目标(用于线性编程)有助于指导优化器到解决方案可以是最大或最低值,例如,公式可以生成最大收入或最低成本可行性编程不需要的间接级别数量的限制定义变量(s)优化器输出将是什么值? Can be integer (whole number), real (decimal number), or binary (0 or 1) Define Constraint(s) (optional) limit on the value (max, min, no negative numbers). Needs to be Boolean (True/False) with summary of ALL Can be generated by a formula (with limit on the number of levels of indirection) Some problems may not have a feasible or optimal solution--and an error will be output in those cases. There may also be limitations on performance, the number of decimals, and the formulas used for the objectives and constraints. I would suggest reading the Anapedia sections on Limitations and Indirection to understand more about these limitations. Lastly, Optimizer can only be used to solve linear problems. The actual setup of Optimizer is pretty simple. To create the Optimizer action, click on Actions in the Model Settings. From the New Action menu, select Optimizer. From there, you can name the action (Button Text), set the Time Out (number of seconds after which the Optimizer will stop processing), select whether to use Linear Programming (selecting the optimal solution) or Feasibility Programming (selecting a possible solution in the feasible region). An example of the feasible region can be illustrated here. If you select Linear Programming, you will need to select your Objective. In both Linear and Feasibility Programming, you will need to enter the Variable(s). Constraint(s) are optional for both. To try out Optimizer and to get an understanding of how the formulas for the Objective and Constraints can be created, I highly recommend completing the training. If you want to learn more about optimizer, are interested in a demo, want to share how your organization uses optimizer, or have any discussion topic suggestions, please leave a comment below to let us know! Additional Training and Resources: Anapedia: Optimizer Optimizer: Under the Hood Optimizer: Exercise Walkthrough Optimizer: Dynamic Time Setup
。。。View more