How to download data from InfoCube to Excel

You can directly download the data of infocube to excel.

Display the data of the infocube. ON the menu bar click on LIST - - > EXPORT -- > LOCAL FILE . Choose spreadsheet. Specify the path and name of the file and click on generate. This would load the data from cube to excel on to your machine.

 Alternatively you can download the contents of your Cube into a CSV file using Open Hub destination.

 For OHD see the below steps.

1. Select Open Hub Destination from RSA1.

2. Right Click on the info area Select Create Open Hub Destination.

3. provide Name, Description for the Open Hub.

4. In template, Select Object type as "Infocube" and give the name in Name field. Press Enter.

5. In Destination tab, Select Destination type as File. Give all other details like Filename, Directory etc. select type as FILE and give SEPARATOR as comma(,)

6. In Field Def tab, you will see all the Fields that can be transferred from Source infocube to File. Click Save.

7. Right click on created open hub, Create transformation. Give Source as the infocube. Make transformation as needed.

8. Now similarly Create DTP. Then Save and Activate the DTP.

9. you can schedule your extract.