Oracle Smart View for Office (MAC and Browser) update

SUBMIT NUMERIC ZERO AS REPLACEMENT FOR MISSING VALUES IN SMART VIEW (MAC AND BROWSER)

With the new Submit Zero option, you can choose to submit numeric zero values in place of #Missing label.

To enable submitting zeros as replacement for missing values:

Open the Smart View Option panel, and then go to the Data Options tab.

Under Replacement, enter #NumericZero in the #Missing/NoData Label field.

Select the Submit Zero check box.

ADD MORE DIMENSION ROWS IN FUNCTION BUILDER IN SMART VIEW (MAC AND BROWSER) 

For HsGetValue and HsSetValue functions, you can now add more dimension rows to the Members List in the Function Builder.

Earlier, the number of rows in a function were limited to 10. Now, you can add more rows and enter additional dimensions as per your requirement. Click the Add button to add a new row at the bottom of the Member List.

USER INTERFACE IMPROVEMENTS IN SMART VIEW (MAC AND BROWSER)

User interface improvements have been done in the Home panel and User Preferences panel in Smart View (Mac and Browser).

Right-click menu in Smart View Home panel: You can now right-click on forms, ad hoc grids, and other artifacts in the Smart View Home panel to open forms or ad hoc grids and launch other functionalities such as Job Console, Copy Version, Business Rules, Task List, Approvals, and User Preferences. These options are additionally available under the Action menu in the Smart View Home panel.

Variables tab in User Preferences panel: The associated dimension of a user variable is now seen up-front below the user variable name, instead of as a tool tip. Earlier, the user variable name acted as a button to open the Member Selector dialog, which was not intuitive. Now, a dedicated ellipses menu is introduced for opening the Member Selector dialog.

DISPLAY MEMBER NAMES AND ALIASES IN SEPARATE COLUMNS IN SMART VIEW (MAC AND BROWSER) AD HOC GRIDS

A new Member display option, Member Name and Alias, allows you to display both the member names and their aliases in separate columns on row dimensions in ad hoc grids.