SAP Basis Articles - Page 24 of 60

In a general scenario, it is advisable to store the table as Column store when you have to run complex OLAP queries. OLAP queries include complex calculations and different SQL aggregation functions are used in the query.Select Sum(Sales) from table_name where Column1=’ABC’; Aggregate Functions include −Sum() - returns the sum of the numeric values in a given columnMax() - returns the maximum of the numeric values in a given columnMin() - returns the minimum of the numeric values in a given columnAverage() - returns the average of the numeric values in a given columnPercent() - returns the percentage of the numeric ... Read More

In SAP HANA Studio, you can check the table type from table symbol under Schema. In below snapshot you can see the different symbol for row table and a column table.TEST_Row − Row store table.SHOPFACT − Column store tableTo change the table type, you can use alter table command.Alter table column table_name;

From the below table you can match SAP HANA Revision/Version with Release details −

Other option to check the version of SAP HANA database-Select * from "SYS"."M_DATABASE";Go to SQL editor and run the above command.Go to Result tab and you can see the version of your SAP HANA system.

In SAP HANA Studio, select HANA system and right click. Select last option Properties from the list as below −In Properties window, navigate to Version history and you can see the version of your SAP HANA system.

You can define this under Configure → Configure Check Thresholds. You have an option to define Low, Medium and High values for these parameters.

You can configure SMTP in Alerts tab under SAP HANA Administration. Click on Configure button and you need to enter the below information −Sender EmailSMTP serverSMTP PortRecipient email

This can be checked in Alerts tab under SAP HANA Administration. From drop down, you need to select “All Alerts” as shown below −You can also check occurrence of each alert raised in HANA by double click on Alert description. It shows you date and time when alert was previously raised.

SAP HANA appliance, SAP has partnered with top IT hardware vendors to provide SAP HANA appliance and licensed is provides by SAP.  To provide installation and configuration of SAP HANA platform, there are total 11 vendors for HANA appliance manufacturing.IBMDellHPLenovoCiscoFujitsuNECHuaweiUnisysHitachiSGI

SAP S/4 HANA is based on installation options which are provided by HANA and it includes on premise deployment, cloud based deployment or Hybrid deployment model.Following are the advantages of using SAP S/4 HANA −Multi tenancySAP S/4 HANA takes advantages of HANA's multi tenancy feature, with this option we can run ECC and CRM or any other satellite system on one box. A typical ECC - CRM data transfer accounts for 60% of overall system load, with this multi tenancy option this data transfer load will go away.Simplified Data modelsSAP removed the redundant tables required for aggregates and indices. This ... Read More