2 Replies Latest reply on Mar 30, 2020 5:18 PM by 2819644

    Open in Smart View fails to open data grid

    IGM

      Hi,

       

      the Open in Smart View option fails to load a data grid in Microsoft Excel. When I open a data grid (this is in HFM 11.1.2.4 on-premise), click Open in Smart View from within Internet Explorer (see version info below) I get A webstie wants to open web content using this program on your computer dialog window. When I click Allow in the dialog window, Microsoft Excel is opened with the backstage view but nothing else happens (no data is ever loaded). I also tried clicking the option having first opened Microsoft Excel but this does not seem to make any difference - a new instance of Excel is opened, but no data is loaded.

      Has anyone else experienced this issue?

       

         

      Oracle Smart View for Office 11.1.2.5.910 Build 172
      FileNameVersionPath
      SmartView Files :
      HsAddin.dll11.1.2.9319C:\Oracle\SmartView\bin\
      HsSpread.dll11.1.7258.21546C:\Oracle\SmartView\bin\
      HsTbar.xlaC:\Oracle\SmartView\bin\
      HyperionSmartTag.dll7.2.7258.21548C:\Oracle\SmartView\bin\
      BIPlusConnector.dll11.1.2.3C:\Oracle\SmartView\bin\
      Oracle.SmartView.Interop.SVRC.dll1.0.0.0C:\Oracle\SmartView\bin\
      msxml6.msiC:\Oracle\SmartView\bin\
      HVE Files :
      HVE not Installed
      Office Files :
      Excel.exe16.0.12624.20296C:\Program Files\Microsoft Office\root\Office16\
      winword.exe16.0.12624.20296C:\Program Files\Microsoft Office\root\Office16\
      powerpnt.exe16.0.12624.20296C:\Program Files\Microsoft Office\root\Office16\
      Outlook.exe16.0.12624.20296C:\Program Files\Microsoft Office\root\Office16\
      System Files :
      Msxml6.dll6.30.18362.418C:\Windows\system32\
      Msxml4.dllFile not found
      Msxml3.dll8.110.18362.239C:\Windows\system32\
      Msxml.dllFile not found
      vbscript.dll5.812.10240.16384C:\Windows\system32\
      KERNEL32.dll10.0.18362.329 (WinBuild.160101.0800)C:\Windows\system32\
      USER32.dll10.0.18362.1 (WinBuild.160101.0800)C:\Windows\system32\
      ole32.dll10.0.18362.1 (WinBuild.160101.0800)C:\Windows\system32\
      IExplore.exe11.00.18362.1 (WinBuild.160101.0800)C:\Program Files\internet explorer\
        • 1. Re: Open in Smart View fails to open data grid
          CBarbieri

          I don't know the answer to this specific issue, but I will say there are two ways to open HFM grids in Smart View. The first which you are using, I would call a "push" approach. That is, you are in the HFM web client and you ask HFM to generate an HTML file with an XLS extension and launch Excel to open the html file. I could imagine issues with Excel not wanting to open a non-Excel file that simply has *.XLS" or *.XLSM" for its file name. Maybe the browser can't pass the file along or maybe Excel doesn't like what it sees. If you want Smart View to use this as the basis for an ad hoc grid, you have to then apply an HFM connection even if you can get Excel top open the file.

           

          The more reliable approach I would call the "pull" approach. First go into Excel with Smart View running, and then select the HFM documents from the Smart View connection panel, locate the grid you'd like to open, and let Smart View open the grid in Excel and display the data. Because Smart View already has the context of the application, you can immediately use this for ad hoc analysis. It is much more reliable and does not require the use of an intermediary html file like the "push " approach does.

           

          - Chris

          • 2. Re: Open in Smart View fails to open data grid
            2819644

            We have had similar problems with trying to open grids from workspace to Excel.

            As Chris mentioned we go to Excel (Smart View) and open the grids from there. It is much more reliable.