By Mark Walker
Every thing you must recognize for you to construct your first SAP HANA standalone application!
Overview
Understand key ideas in the back of SAP HANA
Discover the most positive factors of the SAP HANA Studio for program design
Create a reporting software at the SAP HANA platform
Visualize your reporting facts in Microsoft Excel
In Detail
SAP HANA is SAP's in-memory database know-how, and the point of interest in their subsequent iteration procedure. utilizing column-based garage to supply hugely compressed and quickly accessed info, a SAP HANA program could be numerous hundred occasions swifter than an analogous software on past new release database technology.
SAP HANA Starter is a hands-on booklet, taking you step by step in the course of the construction of your first SAP HANA program. you can find the construction blocks that SAP HANA presents, and use them to create a powerful reporting program. extra complex positive factors are proven, permitting you to remodel your reporting program right into a each year revenues elevate simulator. ultimately, you'll the best way to entry your SAP HANA program from Microsoft Excel.
Using effortless to appreciate examples and logical development, you are going to construct your first SAP HANA software – a revenues volume simulator, from scratch.
Starting with the production of tables within the database, and utilizing the modeling construction blocks supplied by means of the SAP HANA Studio, you'll first see how one can construct a reporting program on those tables, after which expand this program to permit revenues elevate simulation, eventually making the knowledge on hand to others in Microsoft Excel.
What you are going to study from this book
Understanding the options at the back of the SAP HANA method – what makes it different
Installation and configuration of the SAP HANA Studio
Creation of database tables and characteristic and analytic perspectives – the development blocks of any SAP HANA application
Development of graphical calculation perspectives for extra complex reporting needs
Use of calculated attributes and measures in reporting perspectives to govern facts at the fly
Addition of filters and consumer activates on your program for extra dynamic output
Integration with reporting instruments reminiscent of Microsoft Excel utilizing MDX
Discover the most beneficial web pages and blogs documenting SAP HANA
Approach
Written as a pragmatic consultant, SAP Hana Starter will convey you all you must understand to construct your first reporting software using SAP's new in-memory database technology.
Who this publication is written for
SAP HANA Starter is geared toward SAP specialists and clients of competing database applied sciences, in addition to a person curious as to what all of the fuss referring to SAP HANA is set. No prior SAP ERP, BW, or database programming adventure is important, although notions of the way SQL and desk joins paintings can be valuable. entry to a SAP HANA field is important to stick to the examples in the community.
Read Online or Download SAP HANA Starter PDF
Best databases books
This booklet brings the entire parts of database layout jointly in one quantity, saving the reader the time and fee of creating a number of purchases. It consolidates either introductory and complex themes, thereby masking the gamut of database layout method ? from ER and UML suggestions, to conceptual facts modeling and desk transformation, to storing XML and querying relocating items databases.
Oracle Call Interface. Programmer's Guide
The Oracle name Interface (OCI) is an software programming interface (API) that enables functions written in С or C++ to have interaction with a number of Oracle database servers. OCI supplies your courses the potential to accomplish the whole diversity of database operations which are attainable with an Oracle database server, together with SQL assertion processing and item manipulation.
Oracle Warehouse Builder 11g: Getting Started
This easy-to-understand educational covers Oracle Warehouse Builder from the floor up, and faucets into the author's huge adventure as a software program and database engineer. Written in a peaceful type with step by step motives, plenty of screenshots are supplied through the publication. there are many assistance and worthy tricks all through that aren't present in the unique documentation.
Extra info for SAP HANA Starter
Sample text
In Tools Palette at the top of the graphical designer, we can see the types of building blocks available for calculation views; in our example, we'll be using two Projection blocks and a Union block. The Projection blocks allow us to select only certain fields from the analytic view to use in our calculation view—once more following the principle of "filter the data as soon as possible and work with as little of it as is necessary" in order to speed up calculations. The Projection block also allows us to add calculated columns—these are the same as calculated attributes or measures in the analytic view; however, they are visible only in this calculation view, not everywhere the analytic view is present.
Calculated Measures Now that we have a variable, which the user can fill in, we can use this to create our projected sales total. To store this amount, we need a new column in our view, and this column will be a measure, just like ORDER_AMOUNT. However, because this information is not present in any underlying table, it is called a calculated measure. Every time we ask SAP HANA for the contents of our view, this column will be recalculated. 36 SAP HANA Starter Creation of a calculated measure is done in exactly the same way as a calculated attribute— right-click on Calculated Measures in the Output pane of the view, and select New.
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.