Databases Reference
In-Depth Information
And now the moment of truth! Activate the calculation view, open a data preview, and you
should be able, using the
Analysis
function, to obtain the following output:
And our simulator is done! With only two tables, and using the standard building blocks available
in SAP HANA, we have built a sales simulator, allowing our user to enter a projected sales
increase percentage, and showing the projected data (which is created on-the-fly by SAP HANA)
alongside the real data stored in the database.
SAP HANA integration with Microsoft Excel
Now that our application is finished inside SAP HANA, and we can see that it performs as
expected inside the Studio, we need to be able to deploy it to our users. Asking them to use the
Studio is not really practical, and we don't necessarily want to put the modeling software in the
hands of all our users.
Reporting in SAP HANA can be done in most of SAP's BusinessObjects suite of applications, or in
tools that can create and consume MDX queries and data.
The simplest of these tools to start with is probably Microsoft Excel. Excel can connect to SAP
HANA using the MDX language (a kind of multidimensional SQL) in the form of pivot tables.
These in turn allow users to "slice and dice" data as they require, to extract the metrics that
they need.
