9 Replies Latest reply: Jun 16, 2014 11:41 PM by Rajesh Valluri RSS

    Exporting FR to excel

    Taylor Made

      We recently migrated to Hyperion 11.1.2.3, when we export financial reports from Planning to excel It spreads the data over several worksheets.  We received this as explanation:

      Hyperion FR Reports Exported to Excel Are Generated in Multiple Sheets in Release 11.1.2.3 (Doc ID 1563951.1)

      Modified: 11-Sep-2013 In this Document

      Goal Solution References

      APPLIES TO:

      Type: HOWTO

      Hyperion BI+ - Version 11.1.2.3.000 and later Information in this document applies to any platform.

      GOAL

      Is it possible to export a multi-page Financial Reporting report in release 11.1.2.3 into one Excel sheet? Such Export was possible in version 11.1.2.0

      SOLUTION

      This is an expected behavior for "Fully Formatted" export under 11.1.2.3. There are no settings can be done to change the behavior similar to export under 11.1.2.x.

      Workaround:

      Import the reports to SmartView using "Fully Formatted' option.

      REFERENCES

       

      This is a big problem for end users does anyone have any ideas on how to fix this?