Business Objects - EDDIE - Report Download - Excel - Import - Export

I am trying to download a report created in EDDIE. It shows up on my workstation as a *.wid type file. How can I download the report as another file type?

There are four options for downloading and saving a Business Objects report:

Option 1: File > Save > .wid This is the Business Objects default. This saves the document to your hard drive. The location is under: My Documents > My SAP Business Objects Documents > User Docs

  • Click file
  • Select Save As
  • Select a Save in: (e.g. Desktop)
  • Save As Files of Type, select Web Intelligence Document

Option 2: File > Save As > Excel This allows you to choose the location to save the document and change the "Files of Type" to Excel (.xls or .xlsx). This location could be on your hard drive, on a CD or USB drive or on a network share, for example. Saving document as .xlsx may cause formatting issues after opening in Excel.

  • Click file
  • Select Save As
  • Select a Save in: (e.g. Desktop)
  • Save As Files of Type, select Excel (.xls) or Excel 2007 (.xlsx)

Option 3: File > Save As > Text File This allows you to choose the location to save the document and change the "Files of Type" to Text (.txt). This location could be on your hard drive, on a CD or USB drive or on a network share, for example. Saving the document as .txt will remove any formatting to the report once it has been opened via Excel using the File Format Wizard.

  • Click file
  • Select Save As
  • Select a Save in: (e.g. Desktop)
  • Save As Files of Type, select Text File (.txt)
  • Click Save
  • Launch MS Excel
  • Click File > Open
  • In the Open pop-up go to the location of the saved Text file (.txt)
  • Change File Type to ALL FILES
  • Select the saved .txt file
  • Click Open, At Text Import Wizard, Step 1
  • Click Delimited
  • Click Next, At Text Import Wizard, Step 2
  • Select Tab
  • Click Next, At Text Import Wizard, Step 3
  • Select Text
  • Click Finish The .txt document is not in an Excel (.xls) format
  • Click File
  • Select Save As
  • Save as Excel  Excel (.xls) or Excel 2007 (.xlsx)

Option 4: File > Save As > Save to EDDIE This sends the document to be stored on the Decision Support server. You can then retrieve the document from any location or computer. This option is very useful when you have created the document at a workstation that is not your own and you want to be able to retrieve it back at your desk or you create the document at your desk and want to be able to retrieve it in a lab setting.

  • Select File
  • Select Save As
  • Select chiboeserv* (* denotes the server number - could be 2, 3, or 4)
  • Select the folder found in EDDIE
  • Save

To open a file from EDDIE Repository

  • Select File
  • Select Open from...
  • Select chiboeserv* (*denotes the server number - could be 2, 3, or 4)
  • Select the folder found in EDDIE
  • Open

For other questions and problems concerning downloading to the various file types, please email AITS Service Desk at servicedeskaits@uillinois.edu or call them at (217) 333-3102 or (312) 996-4806 and they will send a ticket to the group for you.




Keywords:AITS, report, EDDIE, save, save as, Files of Type   Doc ID:35740
Owner:Stephanie A.Group:University of Illinois Administration
Created:2013-12-10 14:20 CSTUpdated:2016-09-26 10:50 CST
Sites:University of Illinois Administration
Feedback:  0   1