Tuesday, May 7, 2024

Oracle Hyperion and EPM - SmartView for Office - Update for Browser and MAC

 24.05 May Update for SmartView and What is new ?

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.
  • With the new Submit Zero option, you can choose to submit numeric zero values in place of #Missing label. 
    • Applies to: Enterprise Profitability and Cost Management, Financial Consolidation and Close, FreeForm, Planning, Tax Reporting

  • In Smart View Options, you can enter #NumericZero as a value for replacing missing data values with zeros (0). 
    • With #NumericZero, you can use functions but cannot submit zeros to the database. With the new Submit Zero option enabled, cells with the #NumericZero label are considered as actual zero (0) value for calculations and are submitted to the database correctly.

To enable submitting zeros as replacement for missing values:

  1. Open the Smart View Option panel, and then go to the Data Options tab.
  2. Under Replacement, enter #NumericZero in the #Missing/NoData Label field.
  3. Select the Submit Zero check box.

Business Benefit: The new Submit Zero check box enables you to submit zero as a replacement for missing values to the database for calculations.

  1. STEPS TO ENABLE

  • To use the Submit Zero option, Service Administrators deploy a new or reuse an existing Smart View (Mac and Browser) manifest file.
  • To deploy a new or existing manifest file:

  1. Create a new manifest file or reuse an existing manifest file.
  2. In the Create Manifest File page, make any other selections and modifications, as you require.
  3. Deploy the manifest file to Smart View (Mac and Browser) users.

No comments:

Post a Comment