Skip to Content

what is the best practice to consume hana views in microsoft excel

Dec 19, 2017 at 06:18 AM


avatar image

Hi Experts

In my new project my client wants to consume all calculation views created in HANA in MS excel directly to create report. They do not want to use any intermediary tools like design studio or WEBI.

I google it and found these two ways of doing it. Such as..

1. Using HANA MDX Provider

2. Using Analysis for Office add on for MS Excel

Now I have two questions

1. What is the best way of achieving my goal

2. Can I use the SQL statement of a particular calculation/analytic view from _SYS_BIC folder to create report directly in MS Excel? If yes then how to do it.

Thanks in advanced.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
Thorsten Watzke
Dec 19, 2017 at 08:10 AM

Hi Indrajit,

for me it's the best way to use the AfO-Add On, this is working fine. You can directly connect to Hana via SAP GUI. You only have to create your Hana Connection in SAP GUI -> Analysis -> Insert Data Source -> Skip -> right mouse click -> create new Hana Connection..

I think it is not possible to create a report directly in Excel, in any case, I have not heard that yet ...

Best regards


afo2.png (58.8 kB)
Show 2 Share
10 |10000 characters needed characters left characters exceeded

Thanks Thorsten Watzke. Can you give me some inputs on my second question.


Hi Indrajit,

I do not know any way how this can work. If you find a solution for this, please post it here, I would be interested too..... ;-)

Best regards