Oracle® Crystal Ball

New Features


Copyright © 2020, Oracle and/or its affiliates.

Updated: June 2020

Authors: EPM Information Development Team

This software and related documentation are provided under a license agreement containing restrictions on use and disclosure and are protected by intellectual property laws. Except as expressly permitted in your license agreement or allowed by law, you may not use, copy, reproduce, translate, broadcast, modify, license, transmit, distribute, exhibit, perform, publish, or display any part, in any form, or by any means. Reverse engineering, disassembly, or decompilation of this software, unless required by law for interoperability, is prohibited.

The information contained herein is subject to change without notice and is not warranted to be error-free. If you find any errors, please report them to us in writing.

If this is software or related documentation that is delivered to the U.S. Government or anyone licensing it on behalf of the U.S. Government, then the following notice is applicable:


Oracle programs, including any operating system, integrated software, any programs installed on the hardware, and/or documentation, delivered to U.S. Government end users are "commercial computer software" pursuant to the applicable Federal Acquisition Regulation and agency-specific supplemental regulations. As such, use, duplication, disclosure, modification, and adaptation of the programs, including any operating system, integrated software, any programs installed on the hardware, and/or documentation, shall be subject to license terms and license restrictions applicable to the programs. No other rights are granted to the U.S. Government.

This software or hardware is developed for general use in a variety of information management applications. It is not developed or intended for use in any inherently dangerous applications, including applications that may create a risk of personal injury. If you use this software or hardware in dangerous applications, then you shall be responsible to take all appropriate fail-safe, backup, redundancy, and other measures to ensure its safe use. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software or hardware in dangerous applications.

Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.

Intel and Intel Xeon are trademarks or registered trademarks of Intel Corporation. All SPARC trademarks are used under license and are trademarks or registered trademarks of SPARC International, Inc. AMD, Opteron, the AMD logo, and the AMD Opteron logo are trademarks or registered trademarks of Advanced Micro Devices. UNIX is a registered trademark of The Open Group. Microsoft, Windows, PowerPoint, Word, Excel, Access, Office, Outlook, Visual Studio, Visual Basic, Internet Explorer, Active Directory, and SQL Server are either registered trademarks or trademarks of Microsoft Corporation in the United States and/or other countries.

This software or hardware and documentation may provide access to or information about content, products, and services from third parties. Oracle Corporation and its affiliates are not responsible for and expressly disclaim all warranties of any kind with respect to third-party content, products, and services unless otherwise set forth in an applicable agreement between you and Oracle. Oracle Corporation and its affiliates will not be responsible for any loss, costs, or damages incurred due to your access to or use of third-party content, products, or services, except as set forth in an applicable agreement between you and Oracle.

Table of Contents:

Feature Changes, Release

Feature Changes, Release

Features Introduced in Release and Earlier Releases

Feature Changes, Release

The listed changes are included in release of Oracle Crystal Ball products. Also see Feature Changes, Release and Features Introduced in Release and Earlier Releases.

Support for Microsoft Office 2019

Oracle Crystal Ball has been tested and is verified to be compatible with the latest release of Microsoft Office 2019. (Previous versions of Crystal Ball also worked successfully with Microsoft Office 2019, but were not officially supported.)

Removal of Crystal Ball EPM

The Enterprise Performance Management (EPM) connector is removed. This connector enabled Oracle Crystal Ball to work with Oracle Hyperion Planning and Oracle Essbase applications. Currently, there are no plans to replace it.

Feature Changes, Release

The listed changes are included in release of Oracle Crystal Ball products. Also see Features Introduced in Release and Earlier Releases.

Removal of Extreme Speed

Starting with Crystal Ball, The Extreme Speed feature from PSI Technology is removed. No enhancements to the Extreme Speed feature will be provided, and there are currently no plans to replace it.

All Crystal Ball simulations and optimizations will continue to run in Normal Speed, which may be slower than Extreme Speed, depending on the model.

Support for existing PSI Technology Extreme Speed functionality in Crystal Ball Professional, Crystal Ball Premium, Oracle Crystal Ball Decision Optimizer, Oracle Crystal Ball Suite, Crystal Ball Classroom Student Edition, and Crystal Ball Classroom Faculty Edition will follow the published Oracle Lifetime Support Policy.

The Compare Run Modes tool also is removed; it is no longer necessary.

Copying Linked Matrixes

You can now copy and paste cells that are part of a linked matrix. The links are carried over to new assumptions during the copy-paste operation. This feature is useful when you want to apply the same correlation matrix to different sets of assumptions. For details, see Appendix B of the Oracle Crystal Ball User's Guide.

Default Naming Enhancements

Assumptions, decision variables, and forecasts are assigned an automatically-generated, default name when they are defined, either directly or by pasting. When defining these Crystal Ball data cells within tables, the default naming algorithm now includes the column and row headers of the table. For more information, see Chapter 3 of the Oracle Crystal Ball User's Guide.

The listed topics describe features introduced in release of Crystal Ball products.

You can use the Cumulative Feature Overview tool to create reports of new features added in prior releases. This tool enables you to identify your current products, your current release version, and your target implementation release version. With a single click, the tool quickly produces a customized set of high-level descriptions of the product features developed between your current and target releases. This tool is available here:

Support for Microsoft Excel 2016

Beginning with release, Crystal Ball now supports Microsoft Excel 2016.

Support for Microsoft Windows 10

Beginning with release, Crystal Ball now supports Microsoft Windows 10.

Predictor Enhancements

The Predictor feature of Crystal Ball release introduced the following enhancements:

  • You can choose to paste predicted values as “random walk” formulas that refer to assumption cells on a separate support sheet. When you run a Crystal Ball simulation, the formulas generate random walks of the future values within the specified confidence intervals.

  • After you run a prediction, you can view random walks of the predicted values for each series for analytic, training, and demonstration purposes. The random walks are shown as animations in the future values section of the chart.

  • By default, predicted data values are enclosed by lines that show the upper and lower predictions intervals. The space in between is shaded, similar to a fan chart.

  • The Predictor Results chart has new Chart Preferences settings that enable you to set line size as well as line color and type. The Simulation series is added to customize prediction animations described previously.

Cell Preferences Enhancements

The following enhancements to the Crystal Ball Cell Preferences dialog, introduced in release, support Predictor enhancements and further customize Crystal Ball performance:

  • A new Functions tab is added to determine whether spreadsheet functions calculate only during simulations or every time the spreadsheet recalculates. When not running simulations, values can be set to the distribution mean, median, or a specified percentile, or they can vary randomly.

  • Assumption values can also be set to the distribution mean, median, or a percentile.

Localization in Additional Languages

Crystal Ball was previously available in French, English, German, Japanese, Portuguese, and Spanish. It is now available in thirteen additional languages: Arabic, Chinese Simplified, Chinese Traditional, Danish, Dutch, Finnish, Italian, Korean, Norwegian, Polish, Russian, Swedish, and Turkish.


Documentation for release currently is not translated.

OptQuest Optimization Enhancements

The OptQuest Linear Programming (LP) and Mixed Integer Programming (MIP) components are improved to increase their accuracy, efficiency, and robustness when used within Crystal Ball products. Effective LP and MIP solvers play an important role within OptQuest by providing the capacity to handle constraints consisting of systems of linear equations as well as inequalities that often accompany practical simulation applications.

Damped Trend Exponential Smoothing Techniques for Forecasting

The Predictor component of Crystal Ball includes three new forecasting techniques: Damped Trend Smoothing Nonseasonal, Damped Trend Additive Seasonal, and Damped Trend Multiplicative Seasonal. Compared to smoothing models based on a linear trend, the damped trend techniques improve forecast accuracy, particularly with long lead times. Each technique includes standard, simple lead, weighted lead, and holdout methods.

Crystal Ball EPM Integration with Strategic Finance

Support for the Oracle Smart View for Office interface for Oracle Hyperion Strategic Finance is now included in Oracle Crystal Ball Enterprise Performance Management. Direct connection through Smart View to Strategic Finance data providers replaces the previous wizard-based integration and enables you to define Crystal Ball variables and run simulations directly on Strategic Finance workbooks within Smart View.

Crystal Ball Decision Optimizer Integration with Strategic Finance

If you have Oracle Crystal Ball Decision Optimizer and Oracle Crystal Ball Enterprise Performance Management, you can now perform OptQuest optimizations on Oracle Hyperion Strategic Finance workbooks within Oracle Smart View for Office. Oracle Crystal Ball Decision Optimizer enables you to automatically search for optimal solutions while accounting for uncertainty, constraints, and requirements.

Sorting Objects for Selection

When selecting Oracle Crystal Ball variables or other objects for charts, data extraction, and similar operations, you can now sort items in order by name, by cell row, or by cell column.