Oracle© Crystal Ball, Fusion Edition

Release 11.1.2.0.000 Patch Set 1 (PS1): 11.1.2.1.000

Readme

Purpose. 1

New Features. 1

Installation Information. 1

Supported Platforms. 2

Supported Languages. 2

Defects Fixed in This Release. 2

Defects Fixed in the Previous Release. 3

Known Issues. 4

Tips and Troubleshooting. 5

Documentation Updates. 5

Accessing EPM System Product Documentation. 5

Copying and Pasting Code Snippets from PDFs. 5

 

Purpose

This document includes important, late-breaking information about this release of Oracle© Crystal Ball, Fusion Edition and related products. Review this Readme thoroughly before installing Oracle Crystal Ball.

It is our goal to make Oracle products, services, and supporting documentation accessible to the disabled community. Oracle Hyperion Enterprise Performance Management System supports accessibility features, which are described in Appendix F of the Oracle Crystal Ball User's Guide. This readme file is accessible in this release in HTML format.

Top of Document

New Features

See the Oracle Crystal Ball New Features Guide.

For new features relating to installation, architecture, and deployment changes in this release, see the Oracle Crystal Ball Installation and Licensing Guide.

Top of Document

Installation Information

Late-breaking information about installation of Oracle Crystal Ball is provided in this Readme and the Oracle Crystal Ball Installation and Licensing Guide. Also see License Key Request Process.html for information about obtaining and applying a Crystal Ball license code. Review this information thoroughly before installing Oracle Crystal Ball.

Top of Document

Supported Platforms

Information about system requirements and supported platforms for Oracle Crystal Ball and related products is available in the Oracle Crystal Ball Installation and Licensing Guide.

Oracle© Crystal Ball Enterprise Performance Management, Fusion Edition supports the latest release of the EPM system.

Top of Document

Supported Languages

Information about supported languages for Oracle Crystal Ball is available in the Oracle Crystal Ball Installation and Licensing Guide. The user interface of this version of Oracle Crystal Ball is translated into Spanish and Japanese. Documentation is not currently translated.

Top of Document

Defects Fixed in This Release

The following customer-reported defects are fixed in this release of Oracle Crystal Ball and related products.

Defect Number

Description of Fix

• 7398458

Comparison chart: The goodness-of-fit comparison chart was not reflecting the Chart Bins Density settings in the Chart Preferences dialog.

• 7402077

Tornado chart: Base case, upside and downside values were not displaying correctly for variables with no impact on the target forecast.

• 7402278

Extreme Speed: Unexpected errors could occur when starting simulations in Extreme Speed on models using the Microsoft Excel OFFSET function.

• 7403413

Performance: Performance can still slow down when pasting assumptions but any performance impact is now linearly related to the number of assumptions; previously the relationship was exponential.

• 9053653

OptQuest: In OptQuest, the formatting of the right hand side of the requirements expression was based on the format of the associated forecast cell. Decimals could be truncated and lose precision.

• 9197703

Integration with other Oracle EPM products: If the Strategic Finance Setup wizard was used to create a Strategic Finance Worksheet using a server-based entity, only entities at the “parent” level were available for selection.

• 9215237

Crystal Ball spreadsheet functions: When  used in Microsoft Excel 2007-format worksheets, the CB.Get...FN calls could not handle more than 256 columns and 65536 rows.

• 9647062

Extreme Speed: If an IF function in a formula contained references to custom distribution assumptions defined with links to data tables in the spreadsheet, a failure resulted.

• 9884588

Developer Kit: CB.ExtractDataND failed when forecast chart windows were suppressed.

• 10117256

Defining assumptions from forecasts: When filters were applied, the filter updated the fitting on the forecast chart but was ignored when defining assumptions from forecasts unless the Apply to All Forecasts option was selected.

 

Top of Document

Defects Fixed in the Previous Release

The following customer-reported defects were fixed in Oracle Crystal Ball, Fusion Edition release 11.1.2.0.000 and related products.

Defect Number

Description of Fix

• 7198126

The Smart View Data Source Manager was unable to add an open file to the Crystal Ball repository.

• 7198129

Smart View displayed an ObjectNotFoundException if a file was deleted from the Crystal Ball repository and another user refreshed the repository folder in the Data Source.

• 7400557

When more than 20 assumptions were included in a Tornado Chart tool analysis, there was a problem in the setting of the upside and downside values for assumptions at the end of the assumption list.

• 7401484

Crystal Ball did not retain the workbook name and Crystal Ball data locations in the Scenario Analysis tool between Crystal Ball sessions.

• 7404692

An HRESULT unexpected error occurred when trying to create a report before the Scenario Analysis results spreadsheet was complete.

• 7405196

An Extreme Speed simulation could run more slowly if you used many SUMIF functions. Also, if the cell ranges passed into the functions were too large (greater than 100 cells) Extreme Speed might not be able to evaluate the functions in vectorization mode, which increased simulation time.

• 7405334

Unexpected errors occurred with certain models when restoring simulation results from .cbr files.

• 7405954

Non-target forecasts could be “frozen” in the Scenario Analysis tool, which yielded inaccurate results.

• 8214275

If Excel values were deleted from assumption cells after running Predictor, an unexpected error occurred when running Predictor again.

• 8532495

When a Crystal Ball EPM simulation was run against a Strategic Finance worksheet, the wrong input values for future forecast values were being pulled in when the "Forecast period input values are constant for all periods" setting was selected.

• 8654188

Crystal Ball data cell definitions could be cleared on Smart View worksheets, but could not be copied or pasted.

• 8665701

Any script that might have been selected on the EPM Preferences, Calculations tab was cleared (set back to None) if the sheet on which the calculation script was defined was renamed, or if a sheet with an ad-hoc analysis was moved to a new workbook, the reference to a defined calculation script was lost.

• 8689320

Non-English preferences files were not populated to a locale-specific folder when migrating to a more recent version of Crystal Ball.

• 8737914

Extreme Speed simulations were setting #N/A values in forecast cells to a value of 0 rather than leaving them undefined.

• 9056747

The CB.GetCertaintyFN spreadsheet function logged an error if the forecast was frozen.

• 9185769

When running OptQuest at Extreme Speed with all decision variables equal to zero, the mean statistic was not calculated correctly.

 

Top of Document

Known Issues

The following issues are the noteworthy known issues of this release.

Defect Number

Known Issues

7403337

CB Tools: The Correlation Matrix tool cannot run on more than 255 assumptions (256 if formatting is not requested).

7407256

Crystal Ball Developer Kit: Always use the English list separator character (,) and the English decimal separator (.).

7475110

Integration with other Oracle EPM products: If the Strategic Finance Setup wizard is used to create a Strategic Finance Worksheet, and then a Crystal Ball simulation is run with charts minimized and worksheets suppressed, it is not possible to stop the simulation manually. However, the Crystal Ball Control Panel, Crystal Ball toolbar buttons, and Run menu can be used to control the simulation when the charts and worksheets are maximized and visible.

7482940

Integration with other Oracle EPM products: If the Strategic Finance Setup wizard is used to create a Strategic Finance Worksheet using a server-based entity, the actual URL for the server is not listed. Only the user-specified name for the server appears on the Setup wizard's Entity Selection panel.

8604284

Integration with other Oracle EPM products: In Crystal Ball EPM, the Enterprise Performance Management connector is inactive by default and must be explicitly activated through the appropriate Crystal Ball More Tools command.

8676929

Integration with other Oracle Enterprise Performance Management (EPM) products: For best results, do not use the Crystal Ball Define, Cell Preferences command on Smart View worksheets.

9074866

Range names: In rare cases, range names disappeared when a Crystal Ball workbook was reopened in Microsoft Office Excel 2007. This was fixed by installing one of the following Microsoft updates, available at http://www.microsoft.com: Microsoft Security Update for Microsoft Office Excel 2007 (KB969682), Release Date: 6/8/2009 or Microsoft Security Update for Microsoft Office Excel 2007 (KB973593), Release Date: 11/9/2009.

9550147

Extreme Speed: Unexpected errors can occur when running Crystal Ball models containing formulas longer than 1024 characters in Extreme Speed mode in Microsoft Excel 2002 (XP) and Microsoft Excel 2003. Workaround: Use formulas that are shorter than 1024 characters or use a later version of Microsoft Excel.

10046029

64-bit OptQuest: For a specified seed value, OptQuest simulation calculations can be slightly different in 32-bit and 64-bit versions of Crystal Ball Decision Optimizer, which can affect the optimization path. If a model is very sensitive to small changes in decision variables, the best solution could differ between versions.

10051948

64-bit Crystal Ball: Although the same calculation algorithms are used in 32-bit and 64-bit versions of Crystal Ball, if a model has extremely large or small parameters, or other edge conditions, results can differ between versions.

10284043

Control Panel: In specific machine system timer environments, the Crystal Ball Control Panel and reports may show a simulation or optimization run time of 0.

10303159

Performance: Crystal Ball Normal speed simulations run significantly slower in Microsoft Excel when the Microsoft Euro Currency Tools add-in is loaded.

11061695

Scatter charts: When scatter charts are set to show correlations and the chart window is resized, incorrect correlation values can display for one or more charts.

11065176

OptQuest: If two unrelated workbooks with OptQuest settings are open -- one of interest and the other secondary -- and an assumption has been defined in the secondary worksheet, optimizations will not run correctly in the other. Workaround: Close the secondary worksheet or freeze all assumptions in it.

11069890

64-bit Crystal Ball: An unexpected error could occur when extracting data with Crystal Ball running in 64-bit Microsoft Excel 2010 when the computer is low on resources.

 

Top of Document

Tips and Troubleshooting

See the "Troubleshooting" section of the Oracle Crystal Ball Installation and Licensing Guide for installation and startup issues not described previously in this document.

Top of Document

Documentation Updates

Accessing EPM System Product Documentation

The most recent version of each EPM System product guide is available for download from the Enterprise Performance Management System Documentation area of the OTN Web site (http://www.oracle.com/technology/documentation/epm.html). For faster access to the documentation, you can also use the Enterprise Performance Management Documentation Portal (http://www.oracle.com/us/solutions/ent-performance-bi/technical-information-147174.html) which also links to EPM Supported Platform Matrices, My Oracle Support, and other information resources.

Deployment-related documentation is also available from the Oracle E-Delivery Web site (http://edelivery.oracle.com/EPD/WelcomePage/get_form).

Individual product guides are available for download on the Oracle Technology Network Web site only.

Copying and Pasting Code Snippets from PDFs

When you cut and paste code snippets from a PDF file, some characters can be lost during the paste operation, making the code snippet invalid.
Workaround: Cut and paste from the HTML version of the document.

Top of Document