Oracle logo

Oracle® Crystal Ball, Fusion Edition

New Features


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

Authors: EPM Information Development Team

The Programs (which include both the software and documentation) contain proprietary information; they are provided under a license agreement containing restrictions on use and disclosure and are also protected by copyright, patent, and other intellectual and industrial property laws. Reverse engineering, disassembly, or decompilation of the Programs, except to the extent required to obtain interoperability with other independently created software or as specified by law, is prohibited.

The information contained in this document is subject to change without notice. If you find any problems in the documentation, please report them to us in writing. This document is not warranted to be error-free. Except as may be expressly permitted in your license agreement for these Programs, no part of these Programs may be reproduced or transmitted in any form or by any means, electronic or mechanical, for any purpose.

If the Programs are delivered to the United States Government or anyone licensing or using the Programs on behalf of the United States Government, the following notice is applicable:

U.S. GOVERNMENT RIGHTS Programs, software, databases, and related documentation and technical data delivered to U.S. Government customers are "commercial computer software" or "commercial technical data" pursuant to the applicable Federal Acquisition Regulation and agency-specific supplemental regulations. As such, use, duplication, disclosure, modification, and adaptation of the Programs, including documentation and technical data, shall be subject to the licensing restrictions set forth in the applicable Oracle license agreement, and, to the extent applicable, the additional rights set forth in FAR 52.227-19, Commercial Computer Software--Restricted Rights (June 1987). Oracle USA, Inc., 500 Oracle Parkway, Redwood City, CA 94065.

The Programs are not intended for use in any nuclear, aviation, mass transit, medical, or other inherently dangerous applications. It shall be the licensee's responsibility to take all appropriate fail-safe, backup, redundancy and other measures to ensure the safe use of such applications if the Programs are used for such purposes, and we disclaim liability for any damages caused by such use of the Programs.

Oracle, JD Edwards, PeopleSoft, and Siebel are registered trademarks of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners.

The Programs may provide links to Web sites and access to content, products, and services from third parties. Oracle is not responsible for the availability of, or any content provided on, third-party Web sites. You bear all risks associated with the use of such content. If you choose to purchase any products or services from a third party, the relationship is directly between you and the third party. Oracle is not responsible for: (a) the quality of third-party products or services; or (b) fulfilling any of the terms of the agreement with the third party, including delivery of products or services and warranty obligations related to purchased products or services. Oracle is not responsible for any loss or damage of any sort that you may incur from dealing with any third party.

Table of Contents:


New Features, Release

New Features, Previous 11.1.1.x Releases


This document describes the new features introduced in Release of:

  • Oracle Crystal Ball, Fusion Edition

  • Oracle Crystal Ball Decision Optimizer, Fusion Edition

  • Oracle Crystal Ball Enterprise Performance Management, Fusion Edition

For a description of new features introduced in related releases, see New Features, Previous 11.1.1.x Releases.

New Features, Release

The following sections describe features introduced in release of Crystal Ball products:

New Predictor Interface and Developer Kit

Predictor, the time-series forecasting feature of Crystal Ball, was completely rewritten for Release New features:

  • A new Wizard interface for setting up forecasts, previewing forecasts, and viewing results

  • Ability to create reports and extract data

  • Ability to fill-in missing values before charting historical data

  • Ability to adjust outliers before pasting values into worksheets or extracting results

  • Updated formulas and algorithms, including autocorrelations

  • Developer Kit (API) for programming time-series forecasts. Because Predictor has a different code base, this Developer Kit is no longer compatible with previous releases of CB Predictor; code written with the earlier CB Predictor Developer Kit is not compatible with Predictor release or later.

Other Enhancement

Crystal Ball EPM—Enterprise Performance Management Simulator enables direct Crystal Ball simulation of queries and forms within Oracle Hyperion Smart View for Office, Fusion Edition Release

New Features, Previous 11.1.1.x Releases

Starting with Crystal Ball Release, a new version numbering scheme was implemented with additional digit groups to align with Oracle versioning standards. Crystal Ball versions and include the following:

Updated OptQuest Optimization Feature

The OptQuest optimization feature has been completely rewritten and is now available in Crystal Ball Decision Optimizer, beginning with version The new version of OptQuest includes:

  • A new Wizard for setting up optimizations, including direct formula entry for constraints and also a simple constraints solution (introduced in version

  • Full integration with Microsoft Excel and Crystal Ball Decision Optimizer, including the ability to control optimizations through the Oracle Crystal Ball Decision Optimizer, Fusion Edition Control Panel

  • An updated version of OptQuest’s world-class global optimization engine, including:

    • Support for both linear and non-linear constraints

    • More aggressive optimization algorithm

    • New variable types: binary, category, and custom

  • Ability to create reports and extract data

  • Developer Kit (API) for programming optimizations

Location Parameter for Lognormal Distribution

The lognormal distribution now includes a location parameter to help model shifted lognormal distributions. This three-parameter distribution is available for setting up assumptions and for fitting to datasets.

Parameter Locking for Certain Distributions

You can now lock the values of certain parameters of selected distributions while fitting data to those distributions. The following parameters can be locked in this release:

  • Location of lognormal

  • Location and shape of gamma

  • Location and shape of Weibull

  • Degrees of freedom for Student’s t

  • Trials for binomial

  • Trials for hypergeometric

New Discrete Distribution Fitting

Distribution fitting now includes discrete as well as continuous distributions and certain parameters can be locked for increased accuracy. You can fit all discrete distributions supported by Crystal Ball, except the Yes-No distribution, to integer data sets. For discrete fitting, you can view the Chi-square statistic and Chi-square p-values. Anderson-Darling and Kolmogorov-Smirnov statistics are not currently available for discrete fitting.

P-Value Calculations

When fitting to continuous distributions, p-value calculations for Anderson-Darling and Kolmogorov-Smirnov have been added for the following distributions:

  • Normal

  • Exponential

  • Minimum Extreme

  • Maximum Extreme

  • Logistic

  • Uniform

  • Gamma

  • Weibull

  • Lognormal

A New Wizard Format for Crystal Ball Tools

The following Crystal Ball Tools have been rewritten with a wizard format for increased ease of use:

  • Batch Fit

  • Bootstrap

  • Decision Table

  • 2D Simulation

New Data Analysis Tool

A new tool, Data Analysis, imports data directly into Crystal Ball forecasts, one for each data series. Then, you can analyze the data using any of Crystal Ball’s charting, reporting, and data extraction features.

Crystal Ball Licensing Enhancements

You can now use Oracle Crystal Ball, Fusion Edition in evaluation mode for a limited time, usually 15 days, without needing to activate a license. License activation no longer requires an Internet connection with an online licensing server. These enhancements were designed to streamline the installation and licensing procedure.

Universal Availability of Predictor and the Crystal Ball Developer Kit

Predictor and the Crystal Ball Developer Kit are now available to all Crystal Ball users. They are no longer optional products available only in a certain package.

Smart View and Strategic Finance Integration

If you have Crystal Ball EPM version or with appropriate licensing, you can use Smart View to work with Crystal Ball files in a number of ways. You can use the Smart View Connection Manager to store Crystal Ball EPM models within a central repository. Then, you can load them into Smart View, access data from certain other applications also within the repository, and — using cell references — populate the Crystal Ball EPM models with current EPM data for further analysis. Two of the applications that can also be accessed from within the Oracle Hyperion Smart View for Office, Fusion Edition spreadsheet interface are Oracle Essbase and Oracle Hyperion Planning, Fusion Edition. If you have Crystal Ball EPM version with appropriate licensing, you can also create Oracle Crystal Ball Enterprise Performance Management, Fusion Edition worksheets from data in Oracle Hyperion Strategic Finance, Fusion Edition.