Formatting Options Supported for Essbase Ad Hoc

Table 5-12 Formatting Options Supported for Essbase Ad Hoc

Option Ad Hoc
Use Cell Styles Yes
Use Excel Formatting

—Move Formatting on Operations

Yes
Retain Numeric Formatting No
Adjust Column Width and Row Height Yes
Freeze Row and Column Headers Yes
Scale Yes
Use Custom Number Format Yes
Use Thousands Separator Yes
Decimal Places Yes
Negative Number Format Yes
Repeat Member Labels No

Note:

For Essbase, if the number formatting options are not set or retained as default in Smart View Options, then the existing behavior of using the General format for numbers will continue for Essbase ad hoc grids.