General

  • In PowerPoint, you may not be able to access Oracle Smart View for Office functions through Microsoft smart tags.

    Workaround: Retype “smartview” (the Smart View smart tag) to cause PowerPoint to reload the smart tag.

  • When you open a saved free-form workbook and change the Member Name Only or Member Name and Description setting in the Options dialog box before refreshing, the member display options do not work.

    Workaround: Refresh the grid before entering Member Name Only or Member Name and Description.

  • Because of a Microsoft Word limitation, if the value of the system-defined option "List separator" is set to one of the regular expression anchor characters (including but not limited to "^" and "$"), Word might fail to insert fields of type "Formula," which will cause failure of copy and paste.

    Workaround: Go to Control Panel, then Regional and Language, then Options, then Standards and Formats, then Customize, and then Numbers, and change the list separator option.

  • Do not change the file extension when you save an Excel workbook with the Get function that has been retrieved through simulation workbooks in the Smart View Panel.

  • Sheet names may be truncated if they are longer than 31 characters; this is an Excel limitation.

  • To use Outlook with Smart View, Visual Basic Scripting Support must be installed and Run From My Computer must be selected in Outlook. See Outlook product documentation for information.

  • In Microsoft Word, slider controls may be resized in reports created in the Report Designer.

  • When you perform drill-through from an Oracle Essbase Studio-sourced cube to FDM, if the EPM System Single Sign-On (SSO) token expires before the sessions of all products involved expires (Workspace, Provider Services, Essbase, Essbase Studio, FDM), the following message is displayed: “Error: An error occurred logging on to the system using single sign-on. Please contact your administrator. Error: 2067 -- You do not have access to the application!”

    Workaround: Log in again to Oracle Hyperion Enterprise Performance Management Workspace from Smart View.

  • When you delete a worksheet containing a reporting object from the Report Designer, Excel may terminate abruptly. This is a Microsoft issue.

  • Sliders in Smart Slice reports do not display properly after the report is closed and reopened. This happens because of a Microsoft security setting for ActiveX controls and OLE objects in Office 2007. See the Microsoft support site for information about working around this issue.

  • If you use Microsoft COM or Automation Add-ins to open Excel, the Smart View ribbon or menu is not displayed, and you cannot automate Smart View. This happens because Smart View cannot be loaded through automation.

    Workaround: Open Excel from EXCEL.EXE located in the Office installation folder, typically C:\Program Files\Microsoft Office\Office12. This workaround is effective only if you do not need to do any further automation. For more information and a complete workaround, see Knowledge Base Document 1453237.1, "SmartView Functionality Changed: Cannot Automate SmartView from Another Program, " available from My Oracle Support.

  • In Smart Query, no results may be returned when you use an equals sign (=) in a filter definition based on value. This happens if the decimal places displayed for numbers in Excel in Smart View is different from that set in Oracle Essbase for the connection.

    Workaround: Use the same "decimal places displayed for numbers" setting in both Excel and Essbase.

  • When working with larger workbooks, or performing an operation that results in a large data set, a "not enough resources" error may occur.

    Workarounds:

    • Break up your workbook into smaller workbooks.

    • Upgrading to Office 64-bit may resolve the issue.

  • When inserting a Smart Slice into a report and refreshing the sheet, the report table is not refreshed and the table data is not visible.

    Workaround: If the data is not visible, click on the first few empty cells; data will then start displaying.

  • Zooming out after performing a zoom in can leave blank rows on the worksheet.

    Workaround: This is not a specific Smart View issue but may be related to excess formatting not being removed by Excel. Oracle recommends trying the following Microsoft workarounds:

  • On computers where Smart View is installed, an error occurs when updating links in PowerPoint that were copied from Excel to PowerPoint.