Hyperion 11.1.1.2 - Fail to import .xls file from FDM web client

Symptom:

1. FDM->Tool->Import XLS

2. Choose an xls file and click B) Import

3. Failed with the error message: "

Error: An error occurred importing the file .
Detail: Object variable or With block variable not set

"

4. Checked the err file in outbox of server: error code->429,description->ActiveX component can't create object

Cause:

The DCOM object can't create file object.

Solution:

Install Microsoft Office 2007 on the server.