Not able to see "SAP HANA MDX Provider" IN EXCEL 2010
I've installed HANA Client/Studio (both 64 bit) on my machine Windows 7 which also 64 bit and Excel 2010 is 32 bit.
I was able to create SYSTEM DSN successfully using "ODBC Data Sources (64-bit)" from Administrative tools but not able to see "SAP HANA MDX Provider" IN EXCEL 2010 in the data connection wizard-->Other/Advanced-->Data Link Properties.
Could you please let me know the cornerstone causing the issue and provide workarounds for the same.
FYI.. I tried "ODBC Data Sources (32-bit)" option as well but there its not showing up HANA Driver to create a DSN for the same.
Thanks in Advance.
Install the 32 bit client and check. That should work.