5 Replies Latest reply on Jun 3, 2008 9:59 AM by 639685

    SmartView for Excel

    639685
      After the change from SmartView Version 9.2. to SmartView Version 9.3.1.1.2.004 and the change form Hyperion HFM 9.2 to Hyperion HFM 9.3.1 a short while ago, we have some problems with Worksheets in Excel that are created with functions in SmartView (with function builder). If an Excel-Sheet would be opened directly in the Explorer, before the connection in Connecting Manager is done, the Excel crashes after to try to connect. Additional the Excel crashes to try to save the worksheet. Also refreshes takes much longer. The Excel is still the same - Office Excel 2003. Do you have any ideas?
        • 1. Re: SmartView for Excel
          621263
          Hey,

          I had a similar issue with excel crashing with Hyperion 9.3.1. But it was related to two different versions of SmartView installed in the same machine and obvious after clearing the registry and reinstalling, it worked.

          I dont know if we can see any error log file for the same. Mayb u shud try the windows event viewer for any errors that occured.

          Hope this helps
          :)
          • 2. Re: SmartView for Excel
            635389
            Hi,

            Try to find the patch for Smart View.
            The version 9.3.1.1.2.004 is instaled by default.

            regards
            Karolus
            • 3. Re: SmartView for Excel
              639685
              Hi Karol

              We have searched that patch in Hyperion Download Center but we didn't find anything. Could you tell us the name of this patch and where we could find it, please.
              • 4. Re: SmartView for Excel
                Erich Ranz
                Here is Oracle's Smart View page:
                http://www.oracle.com/technology/products/bi/foundation-services/smart-view-for-office.html

                To download the newest version of Smart View you will need to go to the e-delivery site:
                http://edelivery.oracle.com/

                1) Coose your language and continue
                2) For the product pack select Hyperion Performance Management and BI
                3) For platform choose Windows 32 bit
                4) Select go and click on Hyperion Performance Management and BI (9.3.1) Media Pack for Microsoft Windows (32-bit)
                5) Scroll down and download Hyperion Smart View for Office Release 9.3.1.2 Microsoft Windows x86 Installer
                6) This will give you a zip file with the latest Smart View exe file
                • 5. Re: SmartView for Excel
                  639685
                  Hi, thank you for your answer.

                  On the e-delivery site we found the version 9.3.1.2, but after the download we checked the version.xml and there is the minor version 1.1.2.0 so for me the actual version on the e-delilvery is 9.3.1.1.2 .
                  On the old download site of Hyperion (hyperion.subscribenet.com) we found the version 9.3.1.1.4. Do you know it this one resolves the Excel problem? We always couldn’t find the version 9.3.1.1.2.004

                  Thanks in advance