在Excel中降低复杂多维模型中的电子表格风险
Mitigating Spreadsheet Risk in Complex Multi-Dimensional Models in Excel
摘要：
Microsoft Excel是有史以来最普遍的分析工具。世界各地的公司都利用它的功能，灵活性和易用性。然而，电子表格需要大量手工操作，并且容易出错，这使得公司难以控制电子表格风险。下面的解决方案旨在降低电子表格中定义为“复杂多维模型”的一组常见问题的风险。“复杂”是指某些类型的应用程序需要复杂的算法、具有挑战性的层次结构和数据库回写等功能（即规划、预测等）。而“多维”指的是提供诸如报告、数据输入表单和对与所得到的模型相关联的不同属性的特别分析等能力。该解决方案被定义为“Excel模型”，因为它的工作方式类似于Excel，但旨在利用Microsoft Excel平台的强大功能。
英文摘要：
Microsoft Excel is the most ubiquitous analytical tool ever built. Companies around the world leverage it for its power, flexibility and ease of use. However, spreadsheets are manually intensive and prone to error, making it difficult for companies to control spreadsheet risk. The following solution is designed to mitigate spreadsheet risk for a set of problems commonly addressed in a spreadsheet defined as "complex multi-dimensional models". "Complex" referring to certain types of applications that require functionality such as sophisticated algorithms, challenging hierarchies and database write-back (i.e. planning, forecasting, etc.) and "multi-dimensional" referring to providing capabilities such as reporting, data input forms and ad hoc analysis on the different attributes associated with the resulting model. The solution is defined as a "PivotModel" because it works similarly to a PivotTable but is designed to leverage the robust capabilities of the Microsoft Excel platform.
机构、总结、中文摘要均由AI分析而来，可能存在错误，请以论文正文为准。
