Note: Slow internet connection may throw connection error. Once the connection established you will be able to see the package and there views built through the HANA Studio.Ĭhoose the object which is required for your analysis and use chart or any other excel features to represent your data. Note: Make sure the checkbox multi database and user database is ticked. Then, click on Next>.Įnter connection parameters specific to SAP HANA user account like Host name, Instance number, User name, Password, and Preferred language. You can instantly test a connection from this dialog by clicking on the Test Connection option.Ī message will prompt confirming a successful connection that says, “Test Connection Succeeded”. Select the data provider as SAP HANA MDX Provider from the given list. Select Other/Advanced option from the Data Connection Wizard dialog and click Next. From the drop-down list, select From Data Connection Wizard. Step 2: Select the connection type in MS-Excel.
#Get data analysis excel install
Step 1: Download and install the MDX Provider from SAP Support Portal.īefore downloading confirm your version of the Excel 32 bit/64 bit. We will be using MDX Provider to bridge the connection between HANA Database and Excel. Here in this post we are going to discuss how we can utilize the capabilities of MS Excel with HANA. We can extend the capabilities of Excel’s by connecting it to SAP HANA which provides real-time data access. On the other hand, MS Excel is one of the most widely used data representation, analysis and reporting software of all time and still it is one of the most important software used throughout the world.
We all know that the HANA is a database technology which provides data to the users very fast. SAP HANA is a high-performance in-memory database that accelerates data-driven, real-time decision-making and actions and supports all workloads with the broadest advanced analytics on multi-model data, on premise and in the cloud.
0 kommentar(er)
