Skip to Content
avatar image
Former Member

HANA views invisible in Excel thru SAP HANA MDX Provider

Mar 16, 2017 at 10:40 AM | 74 Views

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,

Tim

untitled.jpg (34.5 kB)
untitled1.jpg (86.3 kB)
SAP HANA studio
excel
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Roberto Vacca
    Mar 16, 2017 at 10:51 AM

    Hi.

    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

    Bye

    Add comment
    10|10000 characters needed characters exceeded