Connect to Oracle BI EE Presentation Server.

Navigate through the Oracle BI EE Presentation Catalog.

Import pre-created BI Answers views from Presentation Catalog into Microsoft Excel, PowerPoint, and Word. For example, you can:

Copy Oracle BI EE Dashboard content and paste it into Smart View client documents. The data, metadata, and view layout are copied.

Create simple views in Excel using Oracle BI EE Presentation Server as the source for metadata and data.

Interact with content imported into Smart View documents, such as prompt selections.

Manage the imported content in Smart View; for example, refresh, mask, copy and paste, and document contents.

Mask BI data from Oracle BI EE objects in Office so that users must log in to view the data. Masked objects can be viewed upon refresh.

Program using Visual Basic. See New VBA Functions to Support Oracle BI EE for a list of the new functions.

InsertView—Insert an Oracle BI EE object into Smart View

EditPrompts—Edit the prompts of a view.

EditPagePrompts—Edit the page selections of a view.

GetPrompts—Get prompt values of a view.

GetPagePrompts—Get page selections of a view.

DeleteView—Delete a view in an Office application.

DirProperties—Fetch properties of a directory.

InvokeMenu—Invoke the Oracle BI EE ribbon in Smart View

Oracle Essbase

Oracle Hyperion Financial Management

Oracle Hyperion Planning

12413229 -- The Member Name Display options are now available in the Member Selection dialog box. See Member Display Options Available in Member Selector for more information.

13069501 -- During installation, an error occurs noting that Smart View handled an unknown exception thrown by Microsoft Office.

13597347 -- The HsDescription function is not returning correct connection information and, in turn, the HsGetValue function is not working properly.

13933116 -- In the Smart Query panel in Italian versions of Smart View, if you specify Ordering for a set with Value Based option and Dimension/Member selected, you may receive an exception error when you next right-click the set.

14098463 -- The floating POV toolbar does not display correctly when nonstandard screen resolution settings are used.

14119969 -- In some cases, you cannot start Smart View with Excel 2003.

14149839 -- On certain machines, when trying to start Smart View, you may get a “Failed to create a Smart View Extension Activator object” error.

14349868 -- Some larger workbooks may fail to open or may take longer to open. See Opening Large Workbooks in Smart View for more information.

14463026 -- When refreshing functions, the Smart View Progress bar does not display if the “Show Progress Information After” option is set to a value of 1 or greater. The progress bar displays correctly if this value is set to 0 (meaning that the progress bar will appear for all operations regardless of time spent).

The Smart View Progress bar displays correctly for operations other than functions, regardless of the value set.

14486400 -- The down arrow icon at the bottom of the scroll bar in Excel does not work properly. Instead of clicking and holding the down arrow to scroll to the end of a report, you must repeatedly click the down arrow and move down in the report one row at a time.

14521300 -- Excel may stop responding when opening workbooks that contain many rows and columns, graphical objects, or comments. See Opening Large Workbooks in Smart View for more information.

14840654 -- The progress bar does not display when Refresh All is selected, even though the progress bar is enabled and a time in seconds is specified.

15830346 -- Selecting a member in the Member Selection dialog box while performing ad hoc queries causes an error message to display.

15852500, 16073780 -- An HTTP 405 (Method not allowed) error appears after entering certificate Authentication in an Oracle Access Manager (OAM) form.

10419113 -- Calculation scripts and Business Rules may be displayed in random order in the Calculation Scripts dialog box in Smart View when Essbase Server is running on Linux.

Workaround: You may sort calculation scripts in ascending or descending order by clicking on the header, “Calculation Script” in the Calculation Scripts dialog box. You also have the option of sorting by cubes by clicking on the header, “Cube”.

14232278 -- When running an MDX query, users need to make sure that the query generates a valid grid with the rows, columns, and POV defined in order to continue to refresh properly in Smart View.

14183292 -- The results returned when running the VBA function HypExecuteMDXEx are incorrect in that all values returned are long integers.

14459137 -- The GetVBCompatibleMDXStructure procedure in the VBA function HypExecuteMDXEx returns a subscript out-of-range error when attempting to return dimension properties in an MDX query.

14607740 -- Smart View fails to retrieve data when there are multiple grids on a worksheet and the worksheet name contains a dot (for example, MySheet.1).

14625003 -- Excel failed when refreshing a worksheet multiple times in succession.

15926969 -- While performing ad hoc analysis with multiple grids, clicking Refresh deletes the formulas in the Excel sheet.

14725951 -- In Query Designer, changes to the POV for an existing Excel sheet causes the POV to lose focus, that is, there is a mismatch between the criteria in the POV and the content of the sheet.

14802497 -- Numeric data is not retained on Refresh, and Change Alias does not display the latest selection.

14137560 -- Large reports imported into Word as function grids take an excessively long time to be inserted, or the insertion never finishes and the process hangs.

14217769 -- When connected to a Financial Management provider, clicking Refresh in a worksheet that contains hidden columns will cause the columns to be unhidden.

14636363 -- The Instructions dialog box cannot be resized.

14646703 -- In sheets with Freeze panes, the panes disappear when performing a refresh.

11935907 -- Starting with release 11.1.2.2, Oracle Hyperion Provider Services automatically discovers Essbase from the Shared Services Registry. Therefore, you will no longer receive the following error when opening a Planning web form in Smart View through EPM Workspace: “Web launch operation has been cancelled.”

12865097 -- On Planning forms, a formula entered in a writable cell which pulls a value from another cell (whether on the form or outside its boundaries) cannot be deleted.

14278383 -- In German and French versions of Smart View, Planning Smart Lists do not work.

14473064 -- In some non-English versions of Smart View, a conflict may arise between the Formatting settings, “Scaling” and “Decimal Places,” causing the numbers in Planning forms to display incorrectly.

14483407 -- The cell Lock feature is not working in Planning forms.

14405968 -- When Financial Reporting report data contains currency symbols and number formatting (such as decimal places), importing the data into Word as a Function Grid causes the currency symbols and decimal places from the Financial Reporting report to not appear in the Word table.

13870482 -- In Word, when you reopen a saved Financial Reporting function grid and refresh, a new “NEED_REFRESH” column is incorrectly added next to each header.

14197682 -- In Word, function grids are not refreshed correctly after a change to the POV.

6576419 -- When installing on Windows Vista, you are not prompted for administrator privileges at the beginning of installation as expected. Instead, you get an error message during installation that you do not have sufficient privileges.

Workaround: In Windows Explorer, right-click SmartView.exe and select “Run as administrator”. You will then be prompted to supply administrator credentials

9798801, 8839088, 7634745 -- Do not uninstall this version of Smart View and then install a previous version of Smart View. If you must, then delete the registry key HKEY_CURRENT_USER\Software\Microsoft\Office\Outlook\Addins\Hyperion.CommonAddin.

14233719 -- If you are upgrading to this release from a Smart View PSE release, Oracle recommends that you first uninstall the PSE release and then install release 11.1.2.2.310.

6568645 -- In PowerPoint, you may not be able to access Smart View functions through Microsoft smart tags.

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

6579310 -- 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.

6909914 -- 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.

7408376 -- Replacement labels for missing data and other preferences specified in the Smart Slice Options dialog box during Smart Slice creation are not applied to function grids based on the Smart Slice. Instead, the options specified by Smart View users in the Options dialog box are applied to function grids.

7432260 -- You cannot resize columns in table reports.

Workaround: This is expected behavior; to enable column resizing, do the following:

7447990 -- Unlike EPM Workspace, the Smart View Panel does not display hidden files or files with duplicate names. Therefore, file counts may differ between Workspace and Smart View.

7524675 -- 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.

8312407 -- If you open a workbook in Excel 2003 that was previously saved in Excel 2007 as an .xlsx file, you may get an error message. This is a Microsoft issue.

Workaround: Save the file in Excel 2007 with an .xls extension; it will then open properly in Excel 2003.

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

9083246 -- When you try to close Excel, it may terminate abruptly. This is a Microsoft issue. Ensure that you save your work before closing Excel.

9283525 -- 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.

9315130 -- Microsoft security update KB969604 for Office 2007 breaks Smart View functionality in Word. See Microsoft documentation for information about fixing this problem.

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

9477466 -- 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 EPM Workspace from Smart View.

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

10046845 -- 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 2003 and 2007. See the Microsoft support site for information about working around this issue.

10086585 -- In Excel 2003, if you dock the POV to the right or to the left, the POV dimensions disappear, and only the refresh button remains.

11068363 --It may take more than one attempt to log into the Workspace server for Crystal Ball.

11659670 -- Interfaces in Arabic and Hebrew versions of Smart View may contain layout, alignment, and other display issues.

11683285 -- When you upgrade from Internet Explorer 6 to 7 or 8, the default timeout is reduced from 3 minutes to 30 seconds. This setting is leveraged by Smart View and may cause timeout issues on long-running queries.

Workaround: Increase the default keep-alive time-out value in Internet Explorer as described on the Microsoft support site.

11793797 -- In Word, the Delete function in Document Contents does not work.

11934177 -- If Excel transition options are enabled, many Excel functions, including copy/paste and automation API calls, do not work. This is a Microsoft limitation.

12569072 -- Excel macros may not work after Smart View is installed.

Workaround: From the Advanced page of Smart View Options, select Improve Metadata Storage.

12795181 -- 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.

13497798 -- 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 Essbase for the connection.

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

13987451 --For larger workbooks, a “not enough resources” error may occur.

Workaround: Try to break up your workbook into smaller workbooks.

14270083 -- On larger workbooks, Refresh may take longer than in previous versions.

14342691 -- 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.

14343188 -- Autofit fails on some function grids if the document has headers and footers.

14401306, 14401320 -- Reports that were created in release 11.1.2.2 and earlier will not migrate, convert, or insert correctly.

Workaround: In order to migrate and use these reports, you must install the owc11.dll file. Go to the Microsoft web site to download and install owc11.dll.

14648478 -- The Smart View installer does not fully support bidirectional (BiDi) languages. This can result in installer screens containing formatting errors such as overlapping or misaligned text and icons. The installer can be used, however, and the installed Smart View product will display correctly in BiDi languages.

14506528 -- If you are using an XML file for shared connections, as described in “Accessing Shared Connections from an XML File” in the , be sure to note that only ASCII characters are supported in the XML file. Do not use non-ASCII characters in any of the entries you make in this file.

14851501 -- Copying and pasting cells between Excel worksheets using the keyboard commands Ctrl-C and Ctrl-V does not work when Smart View is enabled.

Workaround: From the Smart View ribbon, select Options, then Advanced, and then select the Improve Metadata Storage option.

15990732 -- Instead of prompting for a user name and password, an error occurs when empty user name and password strings are passed in the HypConnect function, even though the user has already signed onto the system using Single Sign-on credentials.

16020511 -- After an ad hoc grid with either a row or column count of one has been copied from Excel and pasted into Word, an error occurs when deleting the grid from the Documents Contents pane in Word. Grids of at least two rows and two columns will delete without error.

16180415-- Drill-through to Oracle Fusion General Ledger applications fails when you are not already logged into the applications. Be sure to log into applications before performing drill-through operations in Smart View.

16225354 -- Drill-through fails when the default browser is Internet Explorer.

Workaround: Go to Tools, and then Internet Options. On the General tab, Tabs group, click Settings. In the Tabbed Browser Settings dialog box, select either option: A new window or The current tab or window.

8763144 -- In the Query Designer, Smart View generates a syntax error when you perform a descendants or top/bottom query on a member whose name contains a dot (.).

6573303 -- Calculation scripts that run from Essbase may not run from Smart View. This can happen if you have restricted calculation access in Smart View. Calculation scripts are run against the connected database.

7111403 -- When you perform an Undo, only the previously selected POV is saved, and recently selected members are removed.

Workaround: instead of using Undo, use Pivot to POV, which will replace all members on that dimension to the POV.

8305216 -- When you perform Smart View operations in a Smart Slice and refresh, you may get an Assertion Failed error message if you try to close Excel by clicking the X in the upper right corner. The message is harmless; you can click OK to close it.

8494250 -- Using Find in the Member Select dialog box may cause Excel to perform excessively slowly or freeze if the dimension contains more than approximately 100,000 members.

10097094 -- If you use merged cells, you may encounter the following issues:

11841013 -- You may not be able to change members in a Smart List.

12330977 -- The POV must contain more than one dimension. If there is only one dimension on the POV, it will be pivoted to the grid when you refresh.

12810510 -- The Function Builder cannot distinguish among substitution variables with the same name.

12884154 -- When you select Pivot from the Essbase ribbon to pivot a row member, the member is moved instead to the POV toolbar.

12890030 -- If you change alias tables, members that you drag from the POV toolbar to the grid may be lost.

12879435 -- A member name in the grid may be displayed as its alias instead of as its name in the Query Designer. However, despite the inconsistent names, the query will execute properly.

12913962 -- When you associate a connection to an ad hoc worksheet using Set Active Connection, members may disappear from the worksheet when you refresh.

Workaround: Instead of associating a connection, perform direct ad hoc analysis on the worksheet.

12928916 -- Numerical values entered into cells that are outside the grid may be lost upon refreshing

13438966 -- If you add members in a column left of a column of blank cells, the new members may be lost after you refresh. This happens because the blank cells are not valid intersections.

13516151 -- When you zoom in on the uppermost dimension in a column that contains more than one dimension, children are displayed with blank columns in between. This happens when Preserve Formulas and Comments in Ad Hoc Operations is selected in the Member Options page of the Options dialog box.

Workaround: Do not select Preserve Formulas and Comments in Ad Hoc Operations.

13657620 -- If you are connected to an earlier version of Essbase, custom members that you create using Smart Query may not be applied when you switch from a Smart Query worksheet to ad hoc analysis.

13729593 -- When you use Firefox 9.x or 10.x, data may not be displayed in the Oracle Hyperion Financial Data Quality Management ERP Integration Adapter for Oracle Applications landing page when you drill through from Smart View.

Workaround: Go to the Add-ons menu in FireFox and ensure that the Smart View extension is enabled.

13737573 -- Member names that contain a hash mark (#) may cause errors.

Workaround: Do not use hash marks in member names.

13770097, 13796543 -- Smart View does not support dual- monitor operation. For example, in Microsoft Word and PowerPoint, the POV control in Smart Slices may not display properly when you are connected to more than one monitor.

13801866 -- In Spanish and German versions of Excel 2003, Smart Query sheets cannot be opened by selecting New Smart Query Sheet.

Workarounds: Open the Smart Query panel from the Home button on the Smart View Panel. Or, upgrade to Excel 2007 or later.

14470264 -- The HsGetVariable function does not support non-ASCII variable values.

15927555 -- The “Disconnect All” command is not breaking all open connections.

6533549, 6549255 -- If a member cell contains a formula that calculates the value for a summary time period, that cell should be locked, but instead, Smart View may mark it as dirty if the data for the member is modified.

7462718 -- If you have cascaded a report created from a new Smart Slice containing at least one function grid and a control (slider or POV) across an Excel workbook, Excel may terminate abruptly if you choose not to save the cascaded report.

7492465 -- Smart View does not permit the use of #Missing in Calc Manager rules, even if the variable is set to permit #Missing.

7641072 -- In data forms previously saved in an Excel workbook, expanding a member may result in data that is incorrectly displayed as zero or No Access.

Workaround: To display the correct data, refresh the worksheet or submit data

9261943 -- Tasks imported into Outlook via Smart View can cause errors if Outlook is configured for Oracle Beehive.

Workaround: In Outlook Send/Receive settings, select None for the Task List folder. See the Outlook documentation for information.

9414544 -- When you are connected to a Planning provider through shared connections and try to add a server via Provider Services, you may get the following error message: “Check if the Server/URL you provided is correct and if the server is up and running." This is an SSL certificate issue. In the enterprise SSL offloading setup, connections from Provider Services to Planning must be HTTP and not HTTPS.

9440181 -- Read-only Dynamic Calc cells may be displayed incorrectly as writable in offline data forms with the suppress missing option set to true.

9445303 -- The Offline wizard continues to be displayed in English when you change to a different language in Smart View.

9445722 -- Planning servers added via Add new server from the Smart View Panel are not displayed in the Smart View Panel in Outlook.

9455001, 9481367 -- If Suppress Rows is enabled in the Planning data form, new rows of data created in offline mode by means of a business rule are not saved when you synchronize back to the server.

9481405 -- If the option Keep data changes made in offline mode is unselected, then any changes made in an offline data form should be overwritten with data from the Planning web when you refresh. However, if the suppress missing rows option is selected for the data from, these changes are retained when you refresh.

9783131 -- When you open a 2003 Excel spreadsheet from the File menu, the spreadsheet flickers and you cannot copy and paste data from one worksheet to another. This happens when one or both of the Lotus compatibility setting - Transition formula evaluation and Transition formula entry are enabled in Excel.

Workaround: Disable both settings. The following macro disables these settings on all worksheets.

Public Sub SVSubmitAllSheets() 
     Dim wk1, wk 
     Set wk1 = ActiveSheet 
     For Each wk In Sheets 
         wk.Activate 
         wk.TransitionExpEval = False 
         wk.TransitionFormEntry = False 
    Next wk 
     wk1.Activate 
 . 
End Sub

10086585 -- In Excel 2003, if the POV is docked to the right or left, the POV dimensions are not displayed. This is a Microsoft limitation.

10225866 -- In the Outlook 2007 shortcut menu for tasks, the Assign Task and Mark Complete items may work only intermittently.

10225958 -- Closing the Smart View Panel in Outlook may take a long time after you open a task from a large task list. The reason is that task lists are always refreshed upon closing, and the time needed to refresh depends, in part, on the number of tasks in the task list.

10379821 -- Starting with Release 11.1.2.1, Smart View cannot be connected to Planning through Provider Services. You can connect to Planning directly.

11898135 -- Data forms fail to open if you are using Planning 11.1.2.0 with this release of Smart View.

12775474 -- If other add-ins besides Smart View are enabled for Excel, forms, especially larger ones, may take a long time to open. This does not happen if the other add-ins are disabled.

12877317 -- If you connect to Planning through Oracle Hyperion Provider Services in Release 11.1.2.1 or later, ad hoc analysis, the Query Designer, and copy/paste functionality is not available.

Workaround: Connect directly to Planning.

14361743 -- In a Planning form, choosing a Spread Value of “4-5-4” results in “38082” being displayed.

15857523 -- When performing ad hoc on Oracle Hyperion Planning forms, if you click on any column and then click Member Selection, a “dimensions not resolved” error occurs.

7608591 -- In German operating systems, multiple zeroes may be incorrectly appended to numbers that are entered into the Cell Text field. For example, 15 may become 1500000. To avoid this problem, precede numbers that you enter into Cell Text with a single quotation mark, for example, '15.

9296160 -- POV controls inserted into a report may be disabled when you close and reopen the document containing the report. This happens when ActiveX controls are disabled.

Workaround: Enable ActiveX controls in Microsoft Office.

9382988 -- In the Customize Field dialog box, shortcut keys do not work.

Workaround: To navigate fields in this dialog box, use the tab key.

12914817 -- For applications that contain a large number of dimensions, the Member Selection dialog box may not be available when the POV is docked just below the toolbar. This happens only in Excel 2003.

Workaround: Upgrade to Excel 2007 or later.

13524210 -- The VBA function HypGetMembers returns both member name and description; it should return only the description.

13630839 -- A connection timeout occurs when performing a refresh in the latest version of Smart View when connected to the 11.1.2 version of Financial Management. This issue is addressed starting with Financial Management 11.1.2.2.

14074129 -- Problems with the column suppression options are causing Financial Management grids to open with a “grid is not well formed” error.

14074533 -- Cell text is displaying instead of data in Smart Slices after the second Refresh.

14208900 -- When performing ad hoc while connected to a Financial Management data source, with the Suppress Columns options “No Data/Missing” and “Zero” selected, after clicking Refresh, the corresponding columns are not suppressed and still appear in the sheet.

14643318 -- An “Invalid Pointer” error results during login when the data source connection has timed out and you attempt to refresh a previously-saved report that contains a function grid.

Workaround: Close the workbook and Excel. Then, restart Excel, open the workbook, and perform the refresh.

14600472 -- In an imported query-ready report, some line items may change after a refresh.

14788220 -- In Word, some report images are not inserted correctly into the document.

6575786 -- Refresh and Refresh All do not work if two pages of a Oracle Hyperion Web Analysis report are imported sequentially.

Workaround: Use All Pages to import multiple pages of a report.

6908330 -- Reporting and Analysis documents are not displayed in Import Workspace Document Folder Tree if EPM Workspace is under WebSeal and configured for a context path (http://<server>:<port>/<context path>/workspace) other than the default (http://<server>:<port>/workspace).

6940642 -- Filters are not updated in POV toolbar after you edit them; however, data is changed successfully.

7674839 -- When you import a Financial Reporting report into Smart View and refresh, the worksheet becomes solid black, except for the cells imported from Financial Reporting .

Workaround: From the Excel Tools menu, select Options. On the Color tab, click Reset and then OK.

8443524 -- If you have an open Excel document when you export a Financial Reporting report in query-ready mode to Excel, the open Excel document will be overwritten without warning.

Workaround: Save and close any Excel documents before exporting.

9743859 -- Web Analysis reports imported from EPM Workspace to PowerPoint 2010 do not open correctly.

Workaround: Save the report file as an .html file. Then open directly in PowerPoint; do not try to import from Oracle Hyperion Enterprise Performance Management Workspace. This issue does not apply to versions of PowerPoint other than 2010.

12564498 -- When you export an Oracle Hyperion Interactive Reporting report from Internet Explorer into Smart View 11.1.2.1.x, the Smart View ribbon disappears in Excel.

Workaround: Open Excel before exporting from Internet Explorer.

12870087 -- Autodeployment does not work for Reporting and Analysis release 11.1.1.4 or earlier.

13704460 -- You may receive an error if you try to import a Financial Reporting report into Microsoft Word.

13852842 -- When attempting to edit a Oracle Hyperion Reporting and Analysis (BQY) document imported in Excel using Smart View, the following error occurs: "An exception was thrown: AUTHEN_CSSLoginFailed."

14722340 -- When connected to Web Analysis or Interactive Reporting, you cannot use the Document Contents feature with Word or PowerPoint. Web Analysis and Interactive Reporting support the Document Contents feature in Excel only.

14800357 -- You cannot delete image-based reports for Oracle Hyperion Financial Reporting, Oracle Hyperion Interactive Reporting, or Oracle Hyperion Web Analysis using the Delete option in the Document Contents panel.

Workaround: Delete the entire sheet containing the report.

15834207 -- When working with reports that had previously been saved in release 11.1.2.1 or earlier of Smart View, you cannot update tables, and you cannot zoom in or zoom out on members.

13571266 -- On Windows XP, the Hyperion Enterprise migration utility may fail to load.

Workaround: Install Microsoft Visual C++ 2010 Redistributable Package (x86), available from the Microsoft web site.

8725279 -- Oracle Hyperion Financial Data Quality Management does not support alias tables for Essbase drill-through.

14275486 -- When Oracle Hyperion Disclosure Management doclets are combined into master documents, table autofit formatting may be lost.

13698118 -- When changing the scenario from an open report, the change is reflected only in the selected report, not in the Account View or other open reports.

Workaround: Change the scenario from the Account View to propagate the change to all open reports.

14110329 -- The “Set Active Connection for this Worksheet” option is available forOracle Hyperion Strategic Finance connections, but it should not be selected. This functionality is not intended for extension and subsequent operations on the sheet will likely not work.

14238189 -- If the data size for a series is more than 8192 characters, inserting a chart generates an exception. In this case, the resulting data set has exceeded the Office chart size limitation and the chart cannot be displayed correctly.

Workaround: Modify the report so the resulting data set is smaller or consider importing it as an image.

14342299 -- An error can occur when you have multiple Oracle BI EE connections open at one time.

Workaround: Disconnect all Oracle BI EE connections and keep only one connection open at a time.

14345387 -- Smart View does not support direct insert of stepped and curved line charts. When inserting a stepped or curved line chart, Smart View will substitute the closest match, a default line chart.

14355587 -- Selection lists specified for prompts in BI Answers (radio button lists and check box lists) are converted to list controls in Smart View.

14458848 -- In bidirectional (BiDi) language versions of Smart View, the text in the Prompt Selector dialog box is displayed from left to right, instead of BiDi format (right to left).

14469040 -- Charts, or graphs, do not display data formats correctly, but do display the correct data values.

14563557 -- Checking or clearing the “Use unified scale” option in BI Answers requires that you use the “Replace View” option when refreshing in Smart View.

For information on setting refresh preferences, see “Specifying Preferences for Refreshing Views” in the “Smart View and Oracle BI EE” chapter of the .

14507281 -- Only one connection at a time is supported to an Oracle BI EE provider. If you attempt to connect to a second Oracle BI EE provider, the catalog will not display the contents of the second connection correctly.

14580332 -- Time zone preferences set in Oracle BI EE account preferences are not exposed in Smart View.

14583775 -- Smart View does not display prompt values on double columns based on code column values when the double columns are set up in BI Answers with the "Enable User to select by code column" option selected.

14594347, 14594221 -- When performing an Insert as Excel Table or Insert as Excel Pivot Table, the order in which columns are rendered Smart View may not match the order that was specified in design mode in BI Answers.

14600296 -- In the Prompt Selector, there is a limit of 256 items that can be displayed in drop-down list controls or option lists.

Workaround: Increase the value of the setting in Prompts/MaxDropDownValues in instance.config in BI Answers.

14672455 -- Graph creation may fail due to memory limits on Windows machines.

14685678 -- An error may occur when users attempt to edit prompts when a double column prompt is defined for a column. With double columns, configurable in Oracle BI EE, column data includes a display column that has a code column mapped to it.

14685723 -- An exception occurs when an invalid value is typed as an input in the text box corresponding to a double column prompt.

14689283 -- In View Designer, you cannot create a view where a hierarchy member is positioned at the top of a list of members in any edge. For example, using the Sample Sales database, you cannot position the Time Hierarchy, and then the D3 Organization member below it, in the Row edge.

14737958, 14750088 -- In View Designer, you cannot create a view with a column of numeric type on the Page or Section edges.

14754719 -- Table or pivot table views containing two or more hierarchy members cannot be created in the View Designer.

14761830 -- After inserting rows or columns before a pivot table created using View Designer, an exception occurs upon refresh.

14780195 -- Copying and pasting table views from an Oracle BI EE dashboard to Smart View results in an “invalid object” error when the analysis contains a static text view or narrative view.

14782104 -- There is no “Refresh All” available in PowerPoint. You can refresh either individual views, or all views on a slide. However, you cannot refresh all views in a presentation with a single action.

14788102 -- Smart View fails when inserting a pivot table where all the columns in the Row edge of the pivot table are hidden.

Workarounds: Insert as a table instead. Alternatively, exclude the columns.

14794872 -- In PowerPoint, tables representing sections may overlap upon refresh when the Refresh option is set to “Replace View.”

14826073 -- The created/modified/accessed dates of Oracle BI EE views and folders may not reflect any locale changes, but always appear in the mm/dd/yyyy format.

15840478 -- Pie charts are not refreshed after adding a filter in BI Answers if the filter added is on a dimension that defines the number of pies that display.

Workaround: If there is a change in a filter column that is also defined as a number-of-pies dimension, then you should change the refresh option on the chart view to Replace View, and then perform another refresh. This ensures a correct refresh, updating the number of pies and the chart titles that correctly reflect the new data.

See “Specifying Preferences for Refreshing Views ” in the for instructions.

15840538 -- Pie charts are not refreshed after removing a filter in BI Answers if the filter removed is on a dimension that defines the number of pies that display.

Workaround: See the workaround specified for bug 15840478.

15886617 -- The precision of digits that Smart View can display in Excel is limited to the precision of digits allowed by Excel.

For example, the following is an 18-digit number formatted with two decimal places:

123456789123456789.12

Because of Excel's 15-digit precision limitation, the digits after the 15th digit are changed to zeroes in Excel and the number would be displayed as follows:

123456789123456000.00

15886902 -- In Word 2007, graph objects may overlap when inserting a compound view.

Workaround: Reposition the graph objects manually.

15896037 -- Copying and pasting content from an Oracle Business Intelligence Enterprise Edition dashboard to Word 2007 may result in Word hanging if the content involves a table followed by one or more charts.

Workaround: Insert one or more blank lines before pasting the content into Word 2007.

15931324 -- Only the selected graph is affected when invoking Edit Prompts or Edit Page Prompts.

Workaround: Select each chart individually and invoke the Edit Prompts or Edit Page Prompts on each one.

15932113 -- In Excel, when a tabular view consists of multiple sections, data in section table may get overwritten upon refresh.

Workaround: Re-insert or replace the view.

15932298 -- In multibyte environments, table objects and graph objects may overlap when inserting a compound view.

Workaround: The graph objects are “floating” objects and can be positioned manually.

15958725 -- Copying report content from BI Answers and pasting into Word using the Smart View Paste option causes Word to stop responding.

15961118 -- If you refresh an inserted Excel pivot table successive times, changing the refresh mode in “Refresh Options” each time (that is, changing it from Refresh Data to Replace View, and back to Refresh Data), an incorrect “replace view” message displays.

16026143 -- In the Oracle BI EE catalog in Smart View, in some cases, the views in an analysis may not display when the analysis contains views with hierarchical columns.

16032052 -- When all column prompts are deleted from a tabular view on the Oracle BI EE server, an error occurs when attempting to refresh or replace the view in Smart View.

Workaround: Use Document Contents to delete the view, and then re-insert it.

16218081 -- Content copied from BI Answers and pasted into Smart View is not cleared from the clipboard with the next Smart View Copy and Paste operation. The previously-copied BI Answers content is pasted along with the newly-copied Smart View content.

Workaround: Ensure that the Office clipboard is cleared before the next Smart View Copy and Paste operation. Refer to the Microsoft Office documentation for information on displaying and clearing clipboard content.

16218211 -- An “Unsupported AMF version” message appears when attempting to perform an action after the Oracle BI EE server connection has timed out.

Workaround: Terminate the Office application, restart it, and then reconnect to Oracle BI EE.

16219221 -- Scatter charts and bubble charts do not display correctly if the data size for a series contains more than 8192 characters.

16616561 -- Inserting table views and pivot table views results in an error when the view contains sections along with hierarchical columns on the row edge that have been drilled into.

Workaround: In BI Answers, remove sections in the view or undo the drill operations, save the analysis, and then re-insert into Smart View. Alternatively, you may apply selection steps and filtering to the analysis in Oracle Business Intelligence Answers to achieve the same effect.

Rows and columns

Graphical objects

Excel comments

15865312 -- In the “Smart View General Operations” chapter, “Copying Data Between Excel, Word, and PowerPoint” topic, the following bullet item should be reworded:

Excel formatting is preserved when data is pasted into Word and PowerPoint. Apply the formatting in Excel before copying and pasting data.

The correct wording should read:

Numeric formatting in Excel is preserved when data is pasted into Word and PowerPoint. Apply numeric formatting in Excel before copying and pasting data.

15915678 -- In the “Smart View and Oracle BI EE” chapter, “Supported Oracle BI EE Chart and Object Types” topic, the statements regarding Time Line Series, Pareto, and Waterfall graphs and Gauge and Funnel objects may be misleading. These graphs and objects may be masked and refreshed, but the refresh will not retrieve any updated data as these graphs and objects are being inserted as images only.

The correct statements should read as follows:

In the non-English versions of and online help, the section “Zooming and Formatting” in the “Ad Hoc Analysis” chapter is incorrect. Instead of the information given there, use the new option Move Formatting on Operations, as described in “Formatting Options” in the “Smart View Options.” chapter.

In the and online help, there is an error in the “Accessing Shared Connections from an XML File” topic. In steps 8.b and 9.c, the example shown should use forward slashes, not backslashes. The corrected example is:

C:/Oracle/SmartView/bin/SmartViewProviders.xml

Ensure that you use forward slashes (/) as separators in the file path in steps 8.b and 9.c.