Top features you'll want to know about - SAP HANA Starter - page 44

There are (at the time of writing) limitations to the integration with SAP HANA and external
reporting tools. These limitations are due to the relative youth of the HANA product, and are
being addressed with each successive update to the software. Those listed here are valid for SAP
HANA SP04; they may or may not be valid for your version.
Hierarchies (not covered in this topic) can only be visualized in Microsoft Excel, not in
BusinessObjects.
Prompts can only be used in BusinessObjects BI4. Views that use variables can be used in
other tools, but only if the variable has a default value (if you don't have a default value on the
variable, then Excel, notably, will complain that the view has been changed on the server—if
your SALES_INCREASE_PERCENT prompt doesn't have a default value and if we didn't
initially give it one—you might like to edit it now, and enter one if you wish to visualize your
simulator in Excel).
In order to make MDX connections to SAP HANA, the SAP HANA client software is needed. This
is separate from the Studio, and must be installed on the client workstation.
Like the Studio itself, it can be found on the SAP HANA DVD set, or in the SWDC (see the
Installation section for full details). Additionally, like the Studio, SAP provides a developer
download of the client software on SDN, at the following link:
http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/webcontent/
uuid/402aa158-6a7a-2f10-0195-f43595f6fe5f .
Just download the appropriate version for your Microsoft Office installation.
Even if your computer has a 64-bit installation of Windows, you most likely
have a 32-bit installation of Office, and you'll need the 32-bit version of the
SAP HANA client software. If you're not sure, you can find the information
by going to Help | About dialog box. In Excel 2010, for example, click on
the File tab, then the Help menu entry.