Note that you can create Graphical Calculation Views using SMART Data access tables and you can also push aggregations to remote database.For more details, you can refer this blog to Smart Data Access: The power of Smart Data Access (SDA) with SAP HANA SP08http://www.saphanacentral.com/2015/03/the-power-of-smart-data-access-sda-with.html

With the use of column based storage in HANA, data is available vertically and hence operations on different columns can be easily performed. When there is a requirement to process to process more than one column, it is processed by the different processor.

BO can connect to HANA in either of the following ways:OLAP SAP BICS ClientSAP BAPIOLAP SAP HANA ClientRelation DB Connectivity (JDBC/ODBC)OLAP SAP BICS (Business Intelligence Consumer Service) Client: This connection can be established either with the help of Information design tool or by using BI Server console. Naming BEx query is optional in this case. Therefore, solitaire BICS connectivity can be used to create reports on multiple BW cubes.SAP BAPI: This is the most prevalent way to connect BO server to BEx queries. For each BEx query one BAPI Connection is created. Therefore, if you have multiple BEx queries then ... Read More

It is always recommended to back up your critical systems.ExampleFollowing SQL command can be used to export schema in HANA:EXPORT "SOURCE_SCHEMA_NAME".* AS BINARY INTO '/tmp/DESTINATION SCHEMA NAME' WITH    REPLACE;This can also be directly zipped to Linux as below:tar -czf SOURCE_SCHEMA.tgz /tmp/DESTINATION_SCHEMA/

To consume HANA view, you need to start by creating an ODBC connection to SAP HANA system through odbcad32.exe.Next step is open SAP Design Studio and add a data source by connecting to HANA system and open view as below:This way you can view your SAP HANA view in Design Studio, now to analyze code coverage results, you can refer this SAP blog for step by step process:SAP blog

You haven’t provided complete details what you are trying to achieve. Refer SAP OSS note 1993033 Wrong result for query on analytic viewDuring activation of an analytic view, column view is generated. However, there are some artifacts that cannot be calculated in this column view. In this case, one additional calculation view is generated on top of it. The generation of the calculation view has to be performed if the following elements are defined in the analytic view:Input parametersCalculated attributesUnit or currency conversionsIf at least one of these elements is defined in the analytic view, the activation creates one OLAP ... Read More

You can refer this SAP blog how to use SAP NetWeaver library with Python.SAP Link

I think there is a typo error. Try correcting your code like classPath="Z:/SAP/hdbclient/ngdbc.jar

As you know SAP was not providing any db for ECC and it had to be purchased separately. When you call your database in ABAP program, you need to write a SQL. As R/3 from SAP works with most relational databases, a common set of features had to be used, with some SAP specific extensions which are translated by the ABAP kernel to be understood by the actual DB. This language is known as Open SQL language.When you develop only for one database, it uses native instructions. IT is developed in Native SQL. Now when you use SAP HANA as ... Read More

The SQL UNION clause/operator is used to combine the results of two or more SELECT statements without returning any duplicate rows.To use this UNION clause, each SELECT statement must haveThe same number of columns selectedThe same number of column expressionsThe same data type andHave them in the same orderWhile performing UNION you need to note that what data it will bring. To perform UNION ALL you need to ensure that views should be fully materialized.To know more about SAP HANA Modeling, you can refer SAP Guide:SAP HANA Guide