In the latest July (21.07) Oracle Cloud EPM patch, Oracle have provided us with some additional enhanced ad hoc features for Standard mode applications – but if you found yourself wondering what “Standard mode” is and how it is activated, then you’ve come to the right blog!
Firstly, a definition; the difference between Standard vs Native Oracle Smart View for Office Ad Hoc Behaviours available in Oracle Cloud EPM:
- Native – this is the default mode and does not have enhanced features available.
- Standard – must be switched on and enables enhanced ad hoc features.
As Native is the default setting, we need to enable Standard mode in the Oracle Cloud EPM application by performing the below steps:
- Login to the Oracle Cloud EPM system on the web
- Navigate to Application -> Settings
- Scroll down to Smart View Ad Hoc Behaviour
- Use the drop down to select Standard mode
- Save your changes
This will then enable the “enhanced” ad hoc features.
Some of the key enhanced behaviours are:
- In-grid POV – Members in the ‘Point of View’ are placed at the top of the excel grid instead of in the POV toolbar.
- Free-form support – Additional support for empty columns/rows, changing alias table and auto-refresh in free forms.
- Saving ad hoc grids – Ability to save ad hoc grids; however, the Submit Formatting option is not yet available.
- Multiple-grid ad hoc – Support for multiple ad hoc grids on the same Microsoft Excel worksheet.
Finally, as mentioned, as part of the 21.07 July patch, there are some additional enhanced features, including:
- Additional Zoom in Options – Additional commands available:
- Sibling Level – Retrieves the siblings of the selected member(s).
- Same Level – Retrieves all members at the same level of the selected member(s).
- Same Generation – Retrieves all members at the same generation of the selected member(s).
- Multiple-cell Select for Ad Hoc Operations – You can now select multiple row or column member cells and then zoom in, zoom out or use keep/remove only. Note that the integrity and validity of the grid must be maintained.
So, as you can see, some great new features available in ad hoc Oracle Smart View for Microsoft Office – just remember to switch to Standard mode for Smart View Ad Hoc Behaviour to enable these!
For more useful Oracle Cloud EPM and NetSuite ERP blogs posted by my colleagues, see the Brovanture website HERE
Until next time