Downloading Data in Data Warehouse
This article covers how users can download/export information from Data Warehouse/OBIEE to their computer.
This article assumes that you are familiar with accessing the Data Warehouse and have run a report where you want to download data.
1. Click on the Export link below the table.
![Export link](https://media.screensteps.com/image_assets/assets/001/702/931/original/1a50dad0-3736-4c40-9733-c1a85d62e8af.png)
2. Select the format you would like to export to.
![Export options](https://media.screensteps.com/image_assets/assets/001/702/927/original/69576c4c-3a10-44cc-a324-22dbc4cf18e6.png)
Choose the format you want to export to.
- PDF (Adobe Acrobat PDF)
- Excel 2007+ (Microsoft Excel 2007 or above)
- Powerpoint 2007+ (Microsoft PowerPoint 2007 or above)
- Web Archive (.mht)
- Data
- CSV Format (Comma Separated Value; can be opened with Microsoft Excel)
- Tab delimited Format (columns of data are separated by tabs instead of commas; can be opened with Microsoft Excel)
- XML Format
3. Click Open to open the data in Excel. Or click Save to save a copy to your computer. Then click OK.
![Open file dialog box](https://media.screensteps.com/image_assets/assets/001/702/929/original/0d1dca83-efbb-42dd-835e-8ec6b5e35386.png)
- Choose Open With Microsoft Excel to open the file now. Choose Save File to save the file to your computer now.
- Then click OK.
4. The file opens in the program for that file type. You can now save the file to your desktop and/or modify the appearance of the data.
![Sample downloaded file](https://media.screensteps.com/image_assets/assets/001/702/933/original/3c883250-8729-467e-94cb-d231f6838ec9.png)
The file may open in read-only mode. Save a copy of the file to your computer in order to modify the file.
Need More Help?
For technical assistance with the Data Warehouse, please contact the IT Help Desk at [email protected] or 657-278-7777.
For questions about getting access to the Data Warehouse or how to use the reports, please contact IT Training at [email protected] or 657-278-5647.