Data source types: Oracle Essbase, Oracle Hyperion Planning, Oracle Planning and Budgeting Cloud, and Oracle Hyperion Financial Management
You can associate Excel formulas with member and data cells in ad hoc grids and set cell styles to identify such cells.
See Cell Styles.
By default, formulas are preserved when you perform ad hoc operations, except for Pivot. To achieve faster execution of queries, you can disable the preservation of formulas and comments. However, if you select this option, formulas are overwritten when you perform ad hoc operations.
To specify preservation of formulas in ad hoc grids: