Export Datasphere Views Data in CSV Format

[kartheekkkota]

Out of many few of us think Datasphere itself is a Database because datasphere itself has local Tables but how many of us know there will be Hana database behind Datasphere screen   

Many of us faced this situation during our test process we need data to  export  that are in Graphical views into CSV format and we can't do it until we create Analytical model and frame it by connecting with AO, Here I wanted to show how to export data from a View in CSV .

#2 Click on Database Access à Click on Database Analysis Users 

Check with your Admin to create DB Access Users and its not Space specific 

Open Database Explorer

Here I considered Graphical View with text semantics for my example ( You can export or run Analytical model as well) 

You can see the definition of view in Hana Database

You can see the definition of view in Hana Database

Click on SQL if you want to write any custom SQL 

Then Run

Click on Download icon

Your Dataset is in your Downloads folder 🍾

I know the blog is simple but would like to share my knowledge for some one who is looking for this grey area.

Incase if you are struggling to export more than 1000 rows then you can change max number of row from the below setting 

Regards,

Kartheek

I should thank to @somenpodder who gave me this opportunity to explore many more opportunities behind the datasphere.