Excel - This data source contains no visible tables

[Former Member]

After upgrading to SPS5 (HANA Onge on Amazon Web Services) all attempts to connect to HANA analytic and attribute views using Excel and MDX results in the Excel message "This data source contains no visible tables".  This was generally successful in SPS4.

This is a very simple model with one attribute view and one analytic view.  Both appear to save, validate and activate.  The column views (attribute, hierarchy and analytic) can be queried via the Data Preview tool and SQL. All attributes have Drill Down and Hierarchy Active = True.   The analytic view has Multi Dimensional Reporting = True.

Thanks.

[lbreddemann]

Hi William,

this sounds as if the BIMC_ALL_CUBES table is not filled correctly.

Did you try to re-activate your analytic views?

Could you check, whether the following select statement returns any tuples?

select * from "_SYS_BI"."BIMC_ALL_CUBES"

- Lars

[Former Member]

Thank you for the reply.  BIMC_ALL_CUBES contains a single row.  While I don't know exactly what the data should look like, this looks reasonable given my model.  Likewise for BIMC_MEASURES (I see two measures, which is what I expect).  The model validates and activates without errors.  No change after reactivation/redeployment.

2;sales;_SYS_BIC;SALES_100M;CUBE;?;2013-03-09 13:33:33.526;2013-03-09 13:33:33.526;OLAP_PERF;2013-03-09 13:33:33.526;OLAP_PERF;SALES_100M;?;"_SYS_BIC"."sales/SALES_100M";_SYS_BIC

[lbreddemann]

Ok, in that case, I'd check the HANA client software version and recommend to update it to the most current release if it isn't already installed.

To check the version, open a command line window and navigate to the folder where you installed the HANA client software to.

In there run

> odbcreg hdbodbc

You should get back something similar to this:

DriverName=hdbodbc

Driver=C:\Program Files\sap\hdbclient\libodbcHDB.dll

Setup=C:\Program Files\sap\hdbclient\libodbcHDB.dll

Version=1.0.50.46111

- Lars

[lbreddemann]

Sorry, I was a bit too quick with my last reply.

What I described is the way to check for the version of the ODBC driver, not for the MDX provider.

To figure out the version of the MDX provider, just select the "SAP HANA MDX Provider" in the Excel Data link Properties and display the "Connection" tab.

You'll find the version number right there.

- Lars

[Former Member]

Lars,

Thanks for the quick reply.

I checked versions.  I have 1.48.xx which comes with HANA One on AWS.  While that didn't match 1.50.xx as you said to look for, it did get me to think about connections rather than the model.  I turns out that when I upgraded and re-implemented my model in SPS5/Rev48, I named the package "Sales" rather than "Demo".  The data connection (.odc) file embedded references to Demo and thus couldn't fine tables within that package.  Rather than Excel complaining that it couldn't find the Demo catalog, which would have been easy to figure out, its' message was more generic and thus more difficult to figure out.

So, while the version wasn't the issue you did get me thinking in the right direction.  Thanks for your help.