About Calc on the Fly
With calc on the fly, you can change data values and see calculated changes instantly, without submitting the updated values.
Data source types: Enterprise Profitability and Cost Management, Financial Consolidation and Close, FreeForm, Planning, Planning Modules, Tax Reporting
You can perform calc on the fly using member formulas during ad hoc analysis and while working on Forms 2.0 in the web application of your business process as well as in Oracle Smart View for Office. You can enter values or change existing values in the data cells and see the cells with formulas refresh immediately with the calculated values, without actually saving or submitting the changes. You do not need to run any business rules or perform calculation functions to refresh the values in the grids.
With calc on the fly enabled, you can view calculations instantaneously, save calculation time, and make multiple changes to the form or grid, without reloading it every time. When you have completed all your changes and are satisfied with the calculations, you can then submit the changed values to the database. Or you can close without submitting your updated values.
Member formulas are based on Essbase calculation functions. In ad hoc grids, when you insert member formulas, they are fetched from the server, converted into Excel-based formulas, and inserted in the grid in Smart View. In Forms 2.0, the formulas are inserted automatically when the Enable Calc on the Fly option is enabled for the form. You can view the Essbase formulas and their Excel-converted format as tooltips in both ad hoc grids and Forms 2.0 by clicking the cells with formulas.
Tutorials
Tutorials provide instructions with sequenced videos and documentation to help you learn a topic.
| Your Goal | Learn How |
|---|---|
| Learn how to perform calc on the fly during ad hoc analysis using member formulas. You can work with calc on the fly either in the web application or with Smart View. |
