In SAP HANA system, there are three basic engines used to processes queries in SAP HANA. Following engines are used −Join EngineOLAP EngineCalculation EngineJoin EngineUsed when querying an Attribute View in SAP HANAOLAP EngineAnalytic Views (without derived columns) use the OLAP EngineCalculation EngineCalculation Views or Analytic Views with derived columns use this engine

Once HANA Modeling view is activated, you can use Data Preview option to analyze the data in HANA Modeling view. To see Data Preview, you can right-click on View name → Data PreviewYou can also click on the icon as shown in below snapshot:

This can be done in 2 waysYou can directly click on round circle in front of the column name in Details PaneYou can add a column to output by right click on the column and select → Add to OutputWhen you add a column to output pane, it is added in Output pane on the right side under columns list.

When you enter the Attribute name, Type, and Subtype and click on Finish, it will open three work panesScenario pane that has Data Foundation and Semantic Layer.Details Pane shows attribute of all tables added to Data Foundation and joining them.Output pane where we can add attributes from Detail pane to filter in the report.You can add Objects to Data Foundation, by clicking on ‘+’ sign written next to Data Foundation. You can add multiple Dimension tables and Attribute Views in the Scenario Pane and join them using a Primary Key.

Note that there are 2 types of Permanente license key types in HANA. If you are using unenforced license key, your system will be locked out in this case.Unenforced: If the unenforced license key is installed and consumption of HANA system exceeds the license amount of memory, the operation of SAP HANA is not affected in this case.Enforced: If the Enforced license key is installed and consumption of HANA system exceeds the license amount of memory, HANA system gets locked. If this situation occurs, HANA system has to be restarted or a new license key should be requested and installed. ... Read More

Temporary License keys are automatically installed when you install the HANA database. These keys are valid only for 90 days and you should request permanent license keys from SAP market place before expiry of this 90 days period after installation.In below snapshot, you can see validity of Temp license key as 90 days

There are various tutorials that you can follow and you can get a fair idea about SAP HANA Concepts. We have various text and video tutorials published free on our website which is developed by experts. You can easily follow them as they provide step by step documentation for all key functions in HANA.https://www.tutorialspoint.com/sap_hana_administration/index.htmhttps://www.tutorialspoint.com/sap_hana/index.htmThere are various sites which provide HANA demo system access with nominal payment. Happy Learning…!!

In SAP HANA, packages are used to store design time repository objects under the Content folder in HANA Studio. You have two types of the package in HANA system:Structural This package only contains sub-packages and doesn’t store repository objects.Non-Structural This package stores both repository objects and sub-packages.

This can be checked under Configuration tab in HANA Administration. You need to scroll down and there you can check details under xsengine.ini

Both the schema are system defined schemas. _SYS_BI schema is used to store all the metadata of created column Views.It is different from _SYS_BIC and _SYS_REPO schema and you can understand this from below −SYS_BI − This schema stores all the metadata of created column Views._SYS_BIC − Whenever you activate any HANA Modeling view, it is stored under _SYS_BIC System defined schema._SYS_REPO − Whatever the objects are there in the system is available in repository. This is used to create required run time objects.