You can even add new dimensions to B2 and C3, or turn A1 from a single cell to a cube, and =A1+B2*C3 will automatically calculate results across the additional dimensions.īetter Optimization and Simulation Models Formulas like =A1+B2*C3 need not change at all when you add elements (more cell or database values) to the existing dimensions. This is much easier to do with a Dimensional Model than with a traditional spreadsheet model. Very often, a successful model is expanded to include more products, regions, time periods, etc. Other Psi functions can write cube results to cell ranges. Double-clicking a cube formula displays a built-in multi-dimensional cube result viewer with drag-and-drop pivoting of dimensions. You can also define B2 and C3 based on Pivot Tables containing input data, and easily obtain a Pivot Table that displays the results of =A1+B2*C3. For example, if cell A1 contains a number and cells B2 and C3 contain =PsiCube() functions, a formula like =A1+B2*C3 in a cell will yield a “cube result,” multiplying and adding the appropriate values along several dimensions. You can use everything you know about Excel formulas in Dimensional Modeling. Dimensional Modeling makes it easy to construct multidimensional models, composed of formulas, that you can use in planning the future. But these tools primarily deal with multidimensional data, generally reflecting the past. If you’ve used Pivot Tables or PowerPivot in Excel, or if you’ve used a multidimensional database, data warehouse or business intelligence tool, the concepts behind Dimensional Modeling will probably be familiar. But you can also use it to build more structured, easily readable, compact optimization and simulation models, that represent business situations with many ‘dimensions’ such as products, customer types, geographic regions, or time periods. You can use it to build what-if models and perform sensitivity analysis in new ways. We are watching out for your privacy!ĭimensional Modeling in Analytic Solver Platform, Risk Solver Platform and Premium Solver Platform V2014 is a breakthrough capability for spreadsheet users. And you can turn this on or off via the Help - Support Mode menu option.
Only "events" that occur in our software, such as "an optimization was run", "the model was diagnosed as nonlinear", or "error message xyz appeared", are reported. In V2014, if you encounter a certain number of error messages or unusual conditions, we will automatically create a support ticket in our Help Desk, prompting our support reps to follow up with you by email.Īs always, no information about your actual model, such as numbers or formulas in any worksheet cells, is ever reported to Frontline's servers. Our goal is to minimize time when you're "stuck", and bypass the initial steps of a tech support call or email, where users often struggle to describe what's wrong. We've taken this a step further with ProActive Support. If you've ever found yourself waiting, we think you'll be pleased when you try V2014!Īctive Support in our V12.5 release, with Live Chat to a support rep embedded in Excel, was a hit with our users. But in V2014, we've focused on faster interactive performance, when starting up Excel, switching among worksheets and multiple open workbooks, and working with large models with thousands to hundreds of thousands of formulas, constraints and/or probability distributions. If you've used our software, you've been accustomed to the fastest Monte Carlo simulation in Excel, and the fastest available Solvers for mathematical optimization. The biggest news in our V2014 release is the introduction of Dimensional Modeling, a powerful new facility for building what-if, optimization and simulation models that are better structured, far more compact, and easier to maintain and extend. We're pleased to introduce Version 2014 of Frontline Solvers for Excel, including a new release of our "super-product," Analytic Solver Platform.
0 kommentar(er)
