Smartview Common issues Master blog Part 2 Oracle EPMBIContinuation to Previous blog. Issue  Decompression Error In Smart View on a Refresh. Solution  During a large refreshretrieve, Smart View gives an error Decompression Failed. This error may also occur if the Smart View connection has timed out with the additional message Grid Operation Failed. This may be due to Microsoft Windows is timing out the connection. Hello Hyperion Gurus, I have some issues working with Hyperion Smart View for Office, I have already successfully installed Smart View v. E38438_01/epm.111223/sv_new_features/images/graphics/options.gif' alt='Hyperion Smart View Client' title='Hyperion Smart View Client' />Windows network time outs can be too short for large datasets to retrieve. If your users have IE 7 installed, the default timeout is 3. The following two Microsoft articles will assist in increasing the timeout http support. Prior to any installation, upgrade or modification, it is advised that a full backup be done of all related environments. This includes servers, file systems, registry keys, repositories and databases within the related environments. I read about some of the latest features in the Oracle Hyperion Smart View. Smart View. One of my clients reporting. ORACLE HYPERION SMART VIEW FOR OFFICE. Configuration Utility for Smart View, select Always force client to upgrade. Oracle Hyperion Reporting and Analysis. Patch Set Update Oracle Smart View 11. By. Hyperion Product Management recently advised the release of a Patch. On each Smart View client machine. Hyperion Smart View Client' title='Hyperion Smart View Client' />It is strongly recommended to engage your Systems Administrator to assist with the following steps. The following client side registry keys need to be added 1. Click Start, click Run, type Reg. Edit, and then click OK. Locate and then click the following key in the registry HKEYCURRENTUSERSoftwareMicrosoftWindowsCurrent. VersionInternet. Settings. On the Edit menu, point to New, and then click DWORD Value. Type Keep. Alive. Timeout and then press ENTER. On the Edit menu, click Modify. In the Base panel, ensure that decimal is selected. Type the appropriate time out value in milliseconds. It is recommended that you enter 1. Click OK. 9. Repeat steps 3 8 above to add Receive. Timeout and Server. Oracle_hyperion_planning_architecture.png' alt='Hyperion Smart View Client' title='Hyperion Smart View Client' />Info. Timeout per below information HKEYCURRENTUSERSoftwareMicrosoftWindowsCurrent. VersionInternet SettingsReceive. Timeoutdword 0. For more information on configuring the Smart View client for users, see Oracle Hyperion Smart View for Office Users Guide for Oracle Hyperion Smart View. To create reports and integrate documents created using Hyperion Reporting and Analysis tools with Word, Excel, and. Describe Smart View Install Smart View Client. Keep. Alive. Timeoutdword 0. BF2. 0Server. Info. Timeoutdword 0. BF2. After making the changes, the client machine must be rebooted. These registry changes are the recommended settings from Microsoft. In some cases for example, slower connection speeds, you may need to increase the Keep. Alive. Timeout if these settings do not work. Issue  Unable to Perform Essbase Ad Hoc Analysis in Smart View 1. Error Cannot set cube view propertiesSolution When trying to connect from Smart View to Essbase and performing an Ad hoc analysis on SampleBasic, the following error occurs Cannot set cube view properties. Connection. Parity. SupportedZ. The reason being due to JAPI jar version and build number in files essesserver. Nik Software Coupon Code Europe. To check the version of the jar files, open the jar files using a zip extractor and go to meta infoManifest. Replace the following two files with the files contained in the APS 1. E OracleMiddlewareEPMSystem. R1commonEssbase. Java. API1. 1. 1. E OracleMiddlewareEPMSystem. R1commonEssbase. Java. API1. 1. 1. Issue  In Smart View, When an Alias Table is Selected, the Essbase Grid Dimension Metadata Returned Does Not Match the Metadata in the Alias Table. Solution  In Smart View v. Essbase grid C API now returns grid dimension metadata information. However, the metadata information returned does not match with the user selected alias table. To reproduce 1.   In Smart View, connect to Sample. U. Basic. 2.   Select to use alias table German. Names. 3.   Retrieve an empty grid. Expected result grid meta data dimension names match user selected German. Names Jahr, Produkt, Markt, Szenario, Umsatze. Actual result grid dimension names are in English and not matching user selected German. Names alias table Year, Product, Market, Scenario, Measures. The cause of this problem has been identified and verified in unpublished BUG 1. ESSBASE RETURNS GRID META DATA INFORMATION NOT MATCHING SELECTED ALIAS TABLEIssue  Does Smart View 1. Support the MAC Operating System. Solution  Microsoft Office 2. Mac OS is supported only for Financial Management and Financial Reporting. This means that you can access HFM and Financial Report Web from a Mac OS via the workspace. We then also support Office 2. Mac for these products, e. HFMweb you can export a webform to office. For this functionality Office. Mac is supported. Smart View client is currently not supported on Mac. Enhacement request Bug 1. MAC OFFICE 2. 01. SUPPORT FOR SMART VIEW has been filed and is currently under internal review by Development. At this time only Microsoft Windows is supported for Smart View. Issue  Submitting MI From Smart View Without Doing a Refresh is Intermittant. Slimcomputer Portable. Solution Versions Smart View 1. EssbaseAPS 1. 1. We have observed inconsistent behavior while submitting missing. Sometimes SV allows to submit missing and sometimes it does not. The steps are Prepare the data sheet using Smart View. Refresh the sheet. Send the sheet to someone who doesnt have Smart View on their system and edit the data sheet rows with Missing and ask them to send it back to you. Now connect to Smart View and try to submit the sheet. You can see the Missing data is not submitting. Though submit without refresh is supported, submitting Missing from Smart View without doing a refresh is not supported at this time. The problem is with Smart View not identifying Missing cell as dirty. Enhancement Request BUG 1. SUBMITTING MISSING FROM WITHOUT DOING A REFRESH has been submitted. Issue has been fixed in the next release of Smart View. Issue  Smart View Undo Button Is Grayed Out. Solution  Sometimes the Undo button is grayed out after doing an Adhoc Query and does not allow users to click Undo to get back to the original view. The internal Undo buffer had not been generated yet. In order to get the internal undo buffer loaded, run a Refresh when the sheet is first opened. This process should enable the Undo button. The Adhoc Query does not load to the undo buffer. Issue  Error Cannot connect to the provider. Make sure it is running in the specified hostport. Error 5. 03Solution  When running a large query in Oracle Hyperion Smart View, the following error is returned after an extended period of time. Cannot connect to the provider. Make sure it is running in the specified hostport. Microsoft Forefront Endpoint Protection Error 7. Error 5. 03. When this occurs, the user must close Microsoft Excel and then re open and re login to continue working. Reason being Time to complete large query in Smart View exceeds specified maximum session timeout value. To resolve this issue modify session timeout settings, specified in modwlohs. Weblogic Managed server. In the modwlohs. WLIOTimeout. Secs and WLSocket. Timeout. Secs to be a value greater than the time needed for the query to complete. You must restart the Oracle HTTP Server OHS and the Web. Logic managed server for the Analytic Provider Services APS server for the new setting to take effect. In our example the user was running a query in Smart View which took longer than 5 minutes to complete. The settings were missing for the APS location handler and the Smart View query was unable to complete. Shutdown the Essbase server service or process. Backup the current modwlohs. The modwlohs. conf file can be found on the Web. Logic Managed server for your implementation of Analytic Provider Services APS at the following location On a Microsoft Windows platform C OracleMiddlewareuserprojectsepmsystemhttp. ConfigohsconfigOHSohscomponent. On a LinuxUnix platform OracleMiddlewareuserprojectsepmsystemhttp. ConfigohsconfigOHSohscomponent. Starting with EPM System 1. Shared Location for your Oracle HTTP Server configuration.