Oracle® Crystal Ball

New Features

Release 11.1.2.3.500


Copyright © 2014, Oracle and/or its affiliates. All rights reserved.

Authors: EPM Information Development Team

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.

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, the following notice is applicable:

U.S. GOVERNMENT END USERS:

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.

This software or hardware and documentation may provide access to or information on 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. 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.


Table of Contents:

New Features, Release 11.1.2.3.500

Features Introduced in Earlier Releases

This section describes the new features introduced in release 11.1.2.3.500 of:

  • Oracle Crystal Ball (and related classroom products)

  • Oracle Crystal Ball Decision Optimizer

  • Oracle Crystal Ball Enterprise Performance Management

For a description of new features introduced in previous related releases, see Features Introduced in Earlier Releases.

Correlation Definition Enhancements

Correlating assumptions is enhanced with the following features:

  • The Define Correlations command is now available through the Crystal Ball ribbon (Microsoft Excel 2007 or later) or menu (Microsoft Excel 2003).

  • Smart Selection algorithms make it easier to define a correlation matrix by selecting one or a few more cells.

  • Matrix view supports consistency checks with adjustment capability plus the ability to switch between adjusted and unadjusted matrix views.

  • Matrix view includes an optional interactive correlation chart.

  • Scatter charts can be easily generated for correlation pairs within a matrix.

  • The Crystal Ball Developer Kit has new calls and constants to support these features.

Bulk Constraint Handling for OptQuest

The OptQuest feature of Crystal Ball Decision Optimizer can now handle single constraint formulas that define multiple constraints. Users can enter formulas with arrays of values instead of separate formulas, for example “A1:A5 <= B1:B”.

Distribution Parameter Enhancements

The following distributions have increased parameter limits as noted:

  • Beta distribution, limit of Shape parameters and their sum = 1e5

  • Binomial distribution, Trials parameter limit = 1e6

  • Gamma distribution, Shape parameter limit = 1e6

  • Hypergeometric distribution, Population parameter limit = 1e5

  • Negative binomial distribution, Shape parameter limit = 1e6

  • Pareto distribution, Shape parameter limit = 1e6

  • Weibull distribution, Shape parameter limit= 1e6

Features Introduced in Earlier Releases

This section describes the new features introduced in release 11.1.2.3.000 of:

  • Crystal Ball (and related classroom products)

  • Oracle Crystal Ball Decision Optimizer

  • Oracle Crystal Ball Enterprise Performance Management

For a description of new features introduced in previous related releases, see Features Introduced in Earlier Releases.

Redesigned Tornado Analysis Tool

The Crystal Ball Tornado Analysis tool has been redesigned with a new wizard interface. Numerous enhancements include individual variable test range customization, updated tornado and spider charts with the ability to save style changes, and the calculation of variable elasticity and explained variation statistics in the output. Enhancements also include a new programming interface to enable automation through Microsoft Excel Visual Basic for Applications or similar Excel development environments.

Integrated Correlation Matrix Tool

Correlations can now be edited in either pair-wise or matrix views. In addition, Crystal Ball now supports direct editing of correlation matrixes within the product, and offers the possibility to link directly to matrixes within Microsoft Excel spreadsheets.

Crystal Ball Developer Kit

The addition of several new developer kit functions offer enhanced access to Crystal Ball statistics. Added functions include:

  • CB.GetAssumStat

  • CB.GetAssumStatFN

  • CB.Spearman

Expanded OptQuest Efficient Frontier Results View

An option has been added to the OptQuest Efficient Frontier results view that enables users to view the test points of all of the best solutions.

Support for Microsoft Excel 2013

Crystal Ball release 11.1.2.3.000 now supports Microsoft Excel 2013.

Support for Microsoft Windows 8

Crystal Ball release 11.1.2.3.000 now supports Microsoft Windows 8.

Localization into Additional Languages

Oracle Crystal Ball user documentation as well as the user interface are now translated into French, German, Japanese, Portuguese, and Spanish.

Documentation Now Certified on Apple Mobile Devices

Documentation files for Release 11.1.2.3 are now available in two mobile formats: .mobi files, available previously, and .epub files. ePub documentation files are supported on all Apple Mobile devices (iPad, iPhone, and iPod Touch). ePub files are supported on many mobile devices; however, they are certified only on Apple Mobile devices. Additional devices will be certified over time.

Release 11.1.2.0, 11.1.2.1, or 11.1.2.2

If you are coming from Release 11.1.2.0, 11.1.2.1, or 11.1.2.2, use the Cumulative Feature Overview tool to review the list of new features added between those releases. This tool enables you to identify current products, the current release version, and the 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:

https://support.oracle.com/oip/faces/secure/km/DocumentDisplay.jspx?id=1092114.1