Figure 2, Smart View Worksheet with Essbase Data shows a Smart View worksheet with monthly sales figures for four sales regions. The figures are loaded from Essbase. Crystal Ball assumptions have been defined for the monthly figures. Crystal Ball forecasts have been defined for the quarterly and yearly totals. This worksheet includes no formulas. Totals come from Essbase business rules.
At the beginning of the simulation, Crystal Ball EPM temporarily stores current data values for all assumption cells. Then, while the simulation is running, Crystal Ball EPM generates values for the assumption cells and submits them to Essbase. The values returned in the forecast cells are saved for analysis and reporting. These can be viewed and analyzed as described in Smart View Data Linking Example.
When the simulation ends, Crystal Ball EPM restores the original values in the worksheet to Essbase.Smart View Data Linking Example.