Knowledgebase: FDM
Export To Excel error "SaveAs method of Workbook class failed" in FDM 11.1.2
Posted by Priya Doyle on 04 February 2011 01:05 PM

Export To Excel error "SaveAs method of Workbook class failed" in FDM 11.1.2

 Modified 24-SEP-2010

Applies to:

Hyperion Financial Data Quality Management - Version: 11.1.1.1.00 and later   [Release: 11.1 and later ]
Information in this document applies to any platform.

Symptoms

When trying to export to Excel an error is returned:
"Error: SaveAs method of Workbook class failed"

Cause

Known issue noted in the FDM ReadMe documentation was not implemented or implemented correctly.

Solution

Follow the steps outlined for Excel 2007 and Windows 2008 as noted in the "Known Issues" section of the FDM ReadMe.pdf 

This will need to be done on the FDM application server. 


When using Windows 2008 server x64, create the following directory to enable Excel importing and exporting:
      \Windows\SysWOW64\config\systemprofile\Desktop
When using Windows 2008 server x86, create the following directory to enable Excel importing and exporting:
      \Windows\System32\config\systemprofile\Desktop


Documentation is found on Oracle Technology Network (OTN) at the following URL:
http://download.oracle.com/docs/cd/E17236_01/index.htm


(2 vote(s))
Helpful
Not helpful

Comments (0)
Post a new comment
 
 
Full Name:
Email:
Comments: