Skip to Content

HANA views invisible in Excel thru SAP HANA MDX Provider

Mar 16, 2017 at 10:40 AM


avatar image
Former Member

Dear all,

I have set up the MDX connection successfully in Excel to access HANA views.

Now the problem is, I could not see all HANA views in Excel.

In HANA studio, I am able to see 18 calculation views under one package:

But in Excel, I could only see 1:

Can anyone suggest why some views are invisible?

Thanks and best regards,


untitled.jpg (34.5 kB)
untitled1.jpg (86.3 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Roberto Vacca Mar 16, 2017 at 10:51 AM


It's only an idea that could help me too in the future.

Did you check out the schema? Probably you're connecting with a particular filter on the list.

_SYS_BIC is the right schema? For example we found our data under SAPABAP1 schema,,,

Hope to help


10 |10000 characters needed characters left characters exceeded