About Calc on the Fly
You can perform calc on the fly during ad hoc analysis using member formulas.
Data source types: Enterprise Profitability and Cost Management, Financial Consolidation and Close, FreeForm, Planning, Planning Modules, Tax Reporting
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, you can view calculations instantaneously, save your calculation time, and do multiple changes to the grid at once, without reloading the grid 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. When you insert member formulas, they are fetched from the server, converted into an Excel-based formula, and inserted in the grid in Smart View. You can view the Essbase formula and its Excel-converted format as tooltips on clicking the cells with formula.
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 within FreeForm, Planning, and Planning Modules either in the web or with Oracle Smart View for Office. |
