Databases Reference
In-Depth Information
Next, select
Other/Advanced
, then select
SAP HANA MDX Provider
, and then click
Next
.
The SAP HANA Login dialog will appear, so enter your host, instance, and login information (the
information you needed to connect to SAP HANA with the Studio, back in the
Installation
section).
Click on
Test Connection
to validate the connection. If the test succeeds, click on
OK
to choose the
cube to which you want to connect. In Excel, all our analytic and calculation views are considered
to the cubes. Choose
SIMULATOR
and click
Next
, shown in the following screenshot:
On this screen there's a
Save password in file
checkbox—this will avoid having to enter the SAP
HANA password every time the Excel file is opened, but the password is stored in the Excel file,
which is a little less secure.
Click on the
Finish
button to create the connection to SAP HANA, and our
SIMULATOR
view.