If you are an old Essbase person like me, you probably got excited to see that the Oracle EPM suite now allows a couple options for how to interact in Smart View. Users now have the option of pulling down data similar to Essbase Ad Hoc views or Planning Ad Hoc views. If you’re coming from an on-prem environment or just used to using Essbase natively, now you can view Smart View data like you remember with a simple setting change.
The option between the two behaviors is available under Navigator->Settings
The Native vs Standard Smart View behavior are both unique. Before you decide which is right for your organization consider the following.
The views between the two environments are not vastly different but they do have some slight variations that users should understand. Prior to the introduction of this option, the Smart View behavior was all Native. It’s the same behavior that Planning Ad Hoc has been for years. Specifically, the default is to put Period and Years in the Column and the dimensions tagged for Account and Entity in the rows. All other dimensions are displayed in a floating POV.
As usual, Oracle’s development team listened to the requests of users and introduced a new behavior called Standard. The Standard behavior by default displays all of their dimensions displayed on the sheet just like traditional Essbase Ad Hoc displays.
The first row is the same as the floating tool bar, and if you click on POV you will be able to hide the first row and display the floating toolbar just like the Native view. This option gives you the best of both worlds.
The biggest benefit of the Native floating POV is that it allows users to have a clean sheets where no rows are hidden and the POV can be pulled to anywhere on the screen. Keeping the sheet clean of confusing dimensions, especially when sending files to users who do not have access to the application, makes reports and formal queries easier to read. If you like having all the dimensions displayed, you can, eliminate the POV by entering all the members on the screen, essentially making it look like the Standard behavior.
The Standard behavior is often preferred by administrators and users so they can see all the members by default on the sheet. This often eliminates any confusion as to where you are querying in the database. It is also the same behavior that Essbase users are familiar with
However, the biggest bang for your buck with the Standard behavior is the ability to query multiple databases/cubes on the same sheet! This is huge benefit that has been available with Essbase Ad Hoc for a while in the on-prem world. If you have a mult-cube or multiple application environment you can now query one cube, then highlight an area and point to another cube. This functionality is great if you have one cube with details that you want to compare to a more high level view, such as a P&L view to Revenue Detail by Product.
Things to Consider
Before you turn this setting on and begin to play with it, StratAlyze Solutions strongly recommends you do this in a test environment. As soon as you make that setting change, it impacts all users immediately. The good news is if you change it from Native to Standard, all of the Native reports should work fine. However, if you change the behavior from Standard back to Native and you have already created a report with the Standard behavior you will get a messages saying “Standard Ad Hoc mode is not enabled in Application Settings.”
Choosing between which behavior you want really depends on the needs of your business, how people are used to interacting with Smart View and how you first deployed the behavior. If you are considering a change to Smart View behavior make sure it is well tested with all existing reports and that users are trained on the new functionality.