Skip to Content
Dec 04, 2012 at 09:16 PM

Problem using MDX connection to HANA via Excel 2010


Hi folks,

I'm trying to use MDX connection to pull data from a HANA view into Excel 2010. I have setup my MDX data connection in excel using SAP NewDb MDX Provider. When I attempt to connect I successfully see a list of my packages and available views. However when I choose a view to open I get a long delay followed by this error: 'Excel was unable to get necessary information about this cube. The cube might have been reorganized or changed on the server. Contact the OLAP cube administrator and, if necessary, set up a new datasource to connect to the cube.'

Any suggestions?