Top
 

Oracle Crystal Ball - EPM Edition

SKU: OCB10CSL-EN

Oracle Crystal Ball EPM uses the power of Oracle Hyperion Smart View for Office to access data from your EPM applications, including Hyperion Planning and Essbase directly in Excel to model your risks and predict success. Don'T forget to add optimization and maintenance. All the pieces are right here, just add what you need to the cart.

$3,995.00
$3,795.25
Products specifications
Min. OS Requirement Windows XP
Language 7 languages (EN, FR, JP, DE, ES, CN, KR)
Add-In Requires Excel
Available for Mac No, requires Parallels Emulation
Price includes 1st year maintenance
Requires other Software? Requires Microsoft Excel to run
Scripting Support Built In
Simulation Monte Carlo
VBA Support Built In
CSV Support
XML Support
Distribution Fitting Built In
User Defined Distributions
Distribution Gallery 22 Base distributions + Advanced Custom Parameters
Monte Carlo Sampling
Latin HyperCube Sampling
Process Capability (6 Sigma)
Sensitivity Analysis
Tornado Analysis
Precision Control
Probability calculations functions
Correlation
Correlation Methods Normal Copula Only (Iman- Conover)
SIP Math Support Crystal Ball is SIPMath compatible because it allows for sequential sampling of datasets (SIPs). SIP Libraries can be exported using a 3rd Party Macro.
Decision Trees We recommend : Palisade PrecisionTree
Stats Tools 3rd party option. We recommend Minitab, Analyse-it and Palisade StatsTools
MS Project Support Requires free Crystal Ball Project Macro to be installed
Charting Built In
Charts can be customized
Automated Reporting
Multi-Core Support
Developper Kit
Example Models
Network Licensing Available
Data Base Integration SmartView interface to connect with Oracle EPM applications such as Hyperion Planning, HSF, Essbase…
Supported DBs Standard ODBC sources from Excel + 3rd party connectors
User Defined Distribution Library Distributions can be generated and saved to shared network drive and can be made available to other Crystal Ball users on the network
Time Series as distributions
Time Series Fitting
Time Series Methods 5 Non-Seasonal Methods + 6 Seasonal Methods, Complete ARIMA (1500 Models) and Stochastic Multiple Linear Regression
Multiple Linear Regression Stochastic Linear Regression (Forecast Independent Variables and recombine into a simulated dependant variable using the regression equation)
Seasonal Methods Seasonal Multiplicative, Seasonal Additive, Holt-Winter's Additive, Holt-Winter's Multiplicative, Damped Trend Additive, Damped Trend Multiplicative
Non-Seasonal Methods Double Moving Average, Single Exponential Smoothing, Double Exponential Smoothing, Single Moving Average, Damped Trend
GBM Support
Cubic Spline For Outlier Adjustments. Option can be set to neighbour interpolation also
Heteroscedastic Models
ARIMA Support Yes, Full ARIMA Model (1331 Non-Seasonal + 27 Seasonal Methods)
AutoARIMA
Data Sensoring Outlier Detection Methods: Mean and Standard Deviation, Median Absolute Deviations, Interquartile Deviation
Time-Series Event Support
Define Time Series
Markov Chains
Automatic Data Transform
Manual Data Transform Methods
Manual Deseasonalization
Manual Detrending
Visualize Simulated Output
Exception Reporting
Time Series Scenario Analysis
Error Measures RMSE, MSE, MAD, MAPE, Theil's U, Durbin-Watson
Time Series Fit Criteria BIC, AIC, RMSE, MSE, MAD, MAPE, Theil's U, Durbin-Watson
Product description

Monte-Carlo Simulation + Optimization for Excel 32/64bit

 

Crystal Ball Example ModelOracle Crystal Ball EPM is a powerful set of spreadsheet-based simulation and optimization tool that empower you to forecast your business data and turn your financial and operational spreadsheet models into dynamic analytical applications. Leveraging the power and ease of Crystal Ball Decision Optimizer, Oracle Crystal Ball Enterprise Performance Management enables managers, executives and analysts to better manage risk and improve planning/forecast accuracy across the enterprise using EPM and Business Intelligence (BI) applications.

Crystal Ball EPM uses the power of Oracle Hyperion Smart View for Office to access data from your EPM applications, including Hyperion Planning and Essbase directly in Excel to model your risks and predict success. Furthermore, with Oracle EPM Workspace you can share your Crystal Ball workbooks and analysis across the enterprise to enhance and accelerate collaborative decision making by putting the right information in the hands of the right people.

  • Easy-to-use Interface
  • Powerful graphics and reports
  • Ability to identify factors influencing your results
  • Collaborate with team members and share data
  • CB Predictor :Build sophisticated time-series forecasts (for sales, product demand, production requirements, etc.) right within Essbase/Planning Models.
  • Decision Optimizer (OptQuest) to optimize simple and complex multi-variable models and spreadsheets i.e. Maximize Profit, Minimize Costs, Maximize NPV, Eliminate Production Waste, etc. OptQuest is an optimization tool that runs with Crystal Ball. As an add-in to Crystal Ball, OptQuest enhances simulation models by automatically searching for and finding optimal solutions. At the basic level, OptQuest selects a value for each decision variable, enters those values into your spreadsheet, runs a Monte Carlo simulation on the spreadsheet, records the results, and repeats the process. With OptQuest, you can determine the best combination of decision variables that yields the results you are seeking!
    • Test thousands of scenarios
    • View all the best scenarios
    • 3 Solution Search Models (Scatter, Neural Network and Taboo Solution Searches)
    • Incorporate multiple constraints such as profitability, NPV, quality specs, etc.

 

 

Discover The Power Of Decision Optimizer

Easily add optimization to your Crystal Ball simulation model

Optimize any forecast or output in your model

.
  • Build simple or complexe models
  • Example models covers the Portfolio Allocation Model, Productio Optimization, Queuing, Supply Chain Optimization
.
  • Select optimization objectives from your models forecasts
  • Define requirements for feasible solutions
  • Minimize or maximize any forecast

Use Discreet, Continuous or Custom Variables to test your decisions

Create natural language logical constraints

.
  • Define or modify upper and lower bounds for each decision varable
  • Ability to set continuous or discreet simulations
.
  • Create multiple constraints
  • Use of simple operators
  • Natural Language
  • Logic based constraints

Flexible settings and options to ensure optimal results

   
.
  • Use both stochastic and deterministic simulation to test your models
  • Run either a set of itereration or time limit for the optimization
  • Powerful output and reporting options
   


Compare Editions

Oracle Crystal Ball
 
Distribution Gallery
 
 
Categories of Distributions
 
User-Defined Distributions
 
Publish and Subscribe for Categories
 
 
 
Process Capability features
 
 
Forecast Charts, with split-view
 
 
 
CB Tools
 
Customized Reporting
 
 
 
 
Extreme Speed  
 
 
 
Global Optimization - Deterministic
 
 
VBA Macros for Crystal Ball
 
 
 
VBA Macros for OptQuest  
 
 
 
VBA Macros for CB Predictor
 
Operational within Oracle EPM Workspace      

 

 

Additional information
Products specifications
Min. OS Requirement Windows XP
Language 7 languages (EN, FR, JP, DE, ES, CN, KR)
Add-In Requires Excel
Available for Mac No, requires Parallels Emulation
Price includes 1st year maintenance
Requires other Software? Requires Microsoft Excel to run
Scripting Support Built In
Simulation Monte Carlo
VBA Support Built In
CSV Support
XML Support
Distribution Fitting Built In
User Defined Distributions
Distribution Gallery 22 Base distributions + Advanced Custom Parameters
Monte Carlo Sampling
Latin HyperCube Sampling
Process Capability (6 Sigma)
Sensitivity Analysis
Tornado Analysis
Precision Control
Probability calculations functions
Correlation
Correlation Methods Normal Copula Only (Iman- Conover)
SIP Math Support Crystal Ball is SIPMath compatible because it allows for sequential sampling of datasets (SIPs). SIP Libraries can be exported using a 3rd Party Macro.
Decision Trees We recommend : Palisade PrecisionTree
Stats Tools 3rd party option. We recommend Minitab, Analyse-it and Palisade StatsTools
MS Project Support Requires free Crystal Ball Project Macro to be installed
Charting Built In
Charts can be customized
Automated Reporting
Multi-Core Support
Developper Kit
Example Models
Network Licensing Available
Data Base Integration SmartView interface to connect with Oracle EPM applications such as Hyperion Planning, HSF, Essbase…
Supported DBs Standard ODBC sources from Excel + 3rd party connectors
User Defined Distribution Library Distributions can be generated and saved to shared network drive and can be made available to other Crystal Ball users on the network
Time Series as distributions
Time Series Fitting
Time Series Methods 5 Non-Seasonal Methods + 6 Seasonal Methods, Complete ARIMA (1500 Models) and Stochastic Multiple Linear Regression
Multiple Linear Regression Stochastic Linear Regression (Forecast Independent Variables and recombine into a simulated dependant variable using the regression equation)
Seasonal Methods Seasonal Multiplicative, Seasonal Additive, Holt-Winter's Additive, Holt-Winter's Multiplicative, Damped Trend Additive, Damped Trend Multiplicative
Non-Seasonal Methods Double Moving Average, Single Exponential Smoothing, Double Exponential Smoothing, Single Moving Average, Damped Trend
GBM Support
Cubic Spline For Outlier Adjustments. Option can be set to neighbour interpolation also
Heteroscedastic Models
ARIMA Support Yes, Full ARIMA Model (1331 Non-Seasonal + 27 Seasonal Methods)
AutoARIMA
Data Sensoring Outlier Detection Methods: Mean and Standard Deviation, Median Absolute Deviations, Interquartile Deviation
Time-Series Event Support
Define Time Series
Markov Chains
Automatic Data Transform
Manual Data Transform Methods
Manual Deseasonalization
Manual Detrending
Visualize Simulated Output
Exception Reporting
Time Series Scenario Analysis
Error Measures RMSE, MSE, MAD, MAPE, Theil's U, Durbin-Watson
Time Series Fit Criteria BIC, AIC, RMSE, MSE, MAD, MAPE, Theil's U, Durbin-Watson