SAP HANALearn about applications running on the SAP HANA Platform and tools of data provisioning and data transformation for SAP HANA. Become HANA Consultant.
- 90% Started a new career
BUY THIS COURSE (
USD 17 USD 41)
- 82% Got a pay increase and promotion
Students also bought -
- SAP HANA Admin
- 10 Hours
- USD 17
- 15 Learners
- SAP HANA Installation
- 2 Hours
- USD 17
- 887 Learners
- Bundle Multi (2-in-1) - SAP HANA Admin
- 50 Hours
- USD 23
- 208 Learners
SAP HANA (high-performance analytic appliance) is an application that is designed process structured data from relational databases, both SAP and non-SAP, and applications and other systems rapidly.
SAP HANA is an in-memory, column-oriented, relational database management system developed and marketed by SAP SE. HANA stands for "High-Performance Analytic Appliance." It is designed to handle high volumes of data and to perform advanced analytics and real-time processing.
One of the main benefits of SAP HANA is its speed. By storing data in-memory rather than on disk, it can process large amounts of data much more quickly than traditional databases. This makes it an ideal platform for data-intensive applications such as business intelligence, data warehousing, and real-time analytics.
SAP HANA also includes built-in analytics capabilities, such as predictive analytics, text analytics, and spatial analytics, which can be used to derive insights from data in real-time. It supports multiple programming languages, including SQL, R, Python, and Java, which allows developers to build custom applications and extensions on top of the platform. SAP HANA is a powerful tool for businesses that need to process large amounts of data quickly and perform advanced analytics in real-time.
It has the ability of using three styles of data replication depending on the source of the data – log-based, ETL-based and trigger-based. The relocated structured data is stored directly in memory. Due of this, data can be accessed quickly in real time by the applications that use HANA.
SAP HANA is an in-memory, column-oriented, relational database management system developed and marketed by SAP SE. Its primary function as a database server is to store and retrieve data as requested by the applications.
Uplatz offers this comprehensive SAP HANA course to take you through the concepts, features, and application of SAP HANA in industry scenarios.
In this SAP HANA training, you will learn the following:
1) Recognize the key concepts of SAP HANA and in-memory computing,
2) Core capabilities of SAP HANA for modeling including Graphical modeling,
3) SQL-based modeling, management of modeling content in the SAP Web IDE for SAP HANA,
4) Key principles of object and data access security in a modeling context,
5) Generate a Data Model with SAP HANA Native Modeling Tools,
6) Establish data into SAP HANA,
7) Consume SAP HANA Info Models and run applications on SAP HANA,
8) Administering SAP HANA, opening and ending, altering the configuration, troubleshooting and promising the high availability of an SAP HANA system,
9) How to develop software applications running on the SAP HANA Platform, essential techniques and tools of data provisioning and data transformation for SAP HANA.
The demand for SAP HANA consultants is growing, particularly in industries such as finance, healthcare, and retail. Companies are increasingly relying on SAP HANA to help them manage and analyze large volumes of data in real-time, and skilled consultants are needed to implement and maintain these systems. To be a successful SAP HANA consultant, it's important to have a strong background in database management, programming, and business analysis, as well as experience working with SAP HANA specifically.
Course/Topic - SAP HANA - all lectures
In this first session of the SAP HANA tutorial, you will get a brief introduction to what exactly is SAP HANA, along with a pictorial representation of SAP HANA Architecture, HANA Software Editions, terminologies used in SAP HANA, the hardware innovations involved in SAP HAHAN, understanding the Columnar Data Storage, HANA Appliance and lastly the SAP HANA Editions.
In this video, you will learn about the Architecture of SAP HANA, starting with the approach for data transfer, components of SAP HANA, the Database Engine view, SAP HANA Appliance, the different views of SAP HANA like the Data Loading View, Reporting View and the Administrative View. Furthermore, you will also be learning about the SAP HANA System Landscaping.
This video is a complete practical session on the Data Services involved in the SAP HANA System Landscaping. The trainer will be guiding you with a step-by-step implementation of the whole process.
This video is a continuation of the SAP BODS Data Services session where you will learn some more configuration steps involved in the SAP Data Services of the SAP HANA System.
In this video, you will get a brief overview of LT Replication Server, learning concepts on SLT Environment Flow, setup of LT Replication Server like Installation Aspects, Configuration Steps, and the Setup Data Replication in SAP HANA. Furthermore, you will be learning about the key benefits of LT Replication Server, the architecture of TDMS Technology, SLT Replication Key Building Blocks, Technical Requirements, and System Set-up Information, SLT Replicator Configuration, details on Transformation Capabilities, Data Processing and Transformation Steps, Parameter based rules and many more.
This video will teach you about the concept of Replication in the SAP HANA system where you will be learning about the 4 different ways of loading data into the SAP HANA database. You will also be learning about the HANA Appliance Server Configurations which are the Scale Up and Scale Out configuration. Furthermore, you will be learning about the SAP HANA System Sizing Guidelines and the complete work process of these will be shown by the trainer in the SAP system.
In this SAP HANA video, you will learn about the different HANA Studio-Features like Modeling, Data Preview, Import/Export, and others. You will also learn about the HANA Studio Terminologies like Data Views and procedures. Further, you will learn the practical steps involved in creating an Attribute View which will be shown in the SAP system along with the Customer Attribute View.
In this video, you will learn how to create package in Product or Material View along with getting the knowledge on Analytical View, Set Parameters, Table Selection, and creating Location Attribute View. You will also learn to create and maintain Operating Concern, its characteristics, database structures in CO-PA, and others.
This video is a completely practical tutorial on how to create Location View in the SAP HANA System. You will be shown by the trainer a complete step-by-step process of how to do the work process in the SAP system.
In this HANA tutorial, you will learn the whole work process of SLT Based Table Data Provisioning with every step being shown in the system. You will also learn Actual_AView and the Plan_AView and the concepts involved in both in the system.
In this video, you will get a brief overview on the Analytics on HANA with the Scale Up Configuration, the client and connectivity options, HANA Analytics Supported Interface, the Reporting & Dashboard Overview, and under it the Semantic Layer Overview, Information Design Tool, the Universe Design Steps and these will be shown by the trainer in the SAP HANA system.
In this video, you will be learning about the Analytical Reporting in the SAP HANA, and under it, you will learn about the BOBJ Explorer Set-up with an overview of what is BOBJ Explorer, which will be shown in the system by the trainer. Further, you will get the knowledge on the BOBJ Analysis for Office. You will also get recommendations on Configuration, Information Design Tool, BusinessObjects Explorer 4.0, and Web Intelligence 4.0.
In this video, you will learn about the complete SAP HANA System Administration, starting with the In-Memory Database (IMDB) Installation and the steps involved in it. This will be shown in the SAP system by the trainer. Along with this, you will also learn about the Enterprise Server Configuration, Scale Up configuration, Distributed System Handling, Distributed System Landscape, Monitoring the Landscape, and a pictorial representation of the Disaster Tolerance Hardware along with showing it in the SAP HANA System.
This is a continuation video to the previous session where you will be learning about the SAP HANA Database with monitoring the landscape, Multi Version Concurrency Control (MVCC), Persistence Layer, the concept of power failure deleting in-memory data and the backup process, disk failure, User Management and Security, HANA Customer Support and SAP Connection, a picturesque view of Creating Users, Managing Users and Assigning Security. You will also be learning about the User and Role concept which will be shown in the SAP system along with the User Provisioning and User Management, assigning Privileges to Roles, creating Role to User, types of Privileges in HANA, and the concept of Analytic Privileges.
In this video you will be learning about the Migration of Database in the SAP HANA system, starting with the concept of In-Memory optimized InfoCube which will be shown in the SAP system, a diagrammatic explanation of the In-Memory optimized InfoCube Design in SAP BW, and the overview of Inventory Management with the Conversion Steps and Log Overview.
In this video, you will get an introduction to SAP BOBJ Data Services, starting with the Enterprise Information Management (EIM), Business Objects Data Integrator, Data Services Usage, and Architecture. You will also learn about the Data Services Repository and its types, the Object Hierarchy, a brief overview of Work Flow shown, and the complete process in the SAP system.
In this HANA tutorial, you will be learning about the ERM, its entities and their relations, the OLAP Database design, and the 4 schemas of MDM. You will get a brief training on the Star Schema as well.
In this last session of the SAP HANA training, you will be learning about the LT Replication Server, showing its details in the SAP system, the new update in the SAP BO Data Services 4.0. Along with this, you will also learn about the SLT Environment Flow, the set-up of LT Replication Server with its configuration steps, what are the key benefits of LT Replication Server for SAP HANA, the Architecture of SAP TDMS Technology, SLT Replication Key Building Blocks, the Technical Requirements, and System Set-Up Information, the configuration steps for SLT Replicator. Furthermore, you will be learning about the Events based Rules, the Extension of Tablestructures and many more.
• Acquire Comprehensive knowledge of SAP HANA and its role in today's business
• Gain Knowledge on implementation of SAP HANA Solution
• Get acquainted with the best practices for SAP HANA modeling and implementation of SAP HANA Project
• Learn Extensively about SAP BI, SAP BO, and Data Provisioning tools
• Understand the various components of SAP such as ECC, S/4 HANA
• The report, Monitor, Configure Dashboard creation using SAP HANA
• Write SAP HANA Queries and Tuning HANA Performance
• Gain knowledge about Administration Activities like managing users, storage, and security
Lesson 1: SAP HANA Foundation
Lesson 2: Deployment Strategies
Lesson 3: Architecture of SAP HANA
Lesson 4: Replicating Data to SAP HANA
• Business Objects Data Services (BODS)
• SAP Landscape Transformation (SLT)
Lesson 5: SAP HANA Studio Interface
• Attribute View
• Analytic View
• Calculation View
• Catalog - Schemas, HANA Live Package
• SAP HANA - SQL Overview
• SAP HANA Transports Options
• SAP ABAP - HANASAP HANA CDS Views
Lesson 6: SAP HANA Reporting Overview (BOBJ)
• BO WEBi
• BO Crystal Reports Enterprise
• BO IDT (BO UNX)
• BO CMC (Admin-SSO)
• BO AO (Analysis Office)
• BO Design Studio
• SAP Lumira & Smart Business Client
• SAP Fiori& SAP NetWeaver Business Client7
Lesson 7: SAP HANA System Monitoring & Administration
• DBA Cockpit
• Database Migration Option (DMO)
Lesson 8: SAP HANA Security & Authorization
• User Management
• Role Management
Lesson 9: Advanced Features Overview
• SAP HANA Web IDE
• SAP Predictive Analytics on HANA
• SAP BW-BPC embedded on HANA
• SAP S/4HANA
• Rapid Deployment Solutions (RDS) for HANA
• SAP Activate Solution Manager for SAP HANA
This SAP HANA training course is designed for helping you clear the SAP Certified Development Associate - SAP HANA 2.0 (SPS03) exam.
The SAP HANA Course module the participants learn about in-memory relational database system. In the SAP HANA course, the participants will learn about the HANA application with an in-memory database technology to process large amount of data. This seems to be an essential learning for all SAP HANA module users.
SAP HANA Certification is an important benchmark in becoming a SAP HANA Consultant as the exam topiccovers business use-case for HANA platform, load data in HANA database, user privilege and management, create reports using varied SAP tools, and data access. SAP HANA tutorial helps the participants to learn about HANA application contribution in an organization and thus attaining a unique SAP certification. SAP HANA course offers complete information about the compliance program thus making the participant a skilled SAP HANA Consultant.
Uplatz online training helps the participants to successfully apply for the SAP HANA certification provided by SAP. Uplatz provides appropriate teaching and expertise training to equip the participants with skills for implementing the learnt concepts in an organization.
Course Completion Certificate will be awarded by Uplatz upon the completion of the SAP HANA course.
The SAP HANA certification exam verifies that the participants possess basic knowledge and can prove their skills in the area of SAP HANA Application. This SAP HANA certification exam validates that the participant has an overall understanding about this consultant profile, and able to implement the knowledge practically in projects.
Below given are the certification details of SAP Certified Development Associate - SAP HANA 2.0 (SPS03) exam:
• Certification Level: Associate
• Exam Name: SAP Certified Development Associate- SAP HANA 2.0 (SPS03)
• Exam Code: C_HANAIMP_15
• Exam Mode: Online
• Total Number of Questions: 80
• Pass Score: 64%
• Time Duration: 180 Minutes
• Exam Price: $550
The SAP HANA Consultant draws an average salary of $135,750 per year depending on the knowledge and hands-on experience. The SAP HANA Consultant job roles are in high demand and make a rewarding career.
The SAP HANA Consultants are recognized across the globe. The increased usage of the SAP HANA application and in-memory database technology in many companieshelp the participants to find a job opportunity easily.
The leading companies hire SAP HANA Consultant considering the skill of building functional and technical knowledge for team members in an organization. The learners earn most beneficial SAP HANAcertification through our expert training and course curriculum. Being SAP HANAcertified is definitely valuable credential and adds value to every organization.
The SAP HANA certification is targeted to those participants who wish to excel as SAP HANA consultant.
The following are the job titles in SAP HANA field:
• SAP HANA Consultant
• SAP HANA Implementation Analyst
• SAP HANA Expert
• SAP HANA Modeler
• SAP HANA Developer
The SAP HANA certification program helps the participants to get placed in reputed MNCs and organizations.
1. What is SAP HANA?
SAP HANA is an in-memory database.
· It is a combination of hardware and software made to process massive real-time data using in-memory computing.
· It combines row-based and column-based database technologies.
· Data now resides in the main memory (RAM) and no longer on a hard disk.
· It is best suited for performing real-time analytics and developing and deploying real-time applications.
2. Compare SAP HANA with Oracle.
Customization, customer service, and functionality
Ease of use, quick deployment, and flexibility
Compatibility to work with other databases
Comparison based on costs
Higher for internal resources and training
Much lesser on both fronts
3. Why choose SAP HANA?
SAP HANA is one of the fastest growing products in SAP history and is viewed by the industry as a breakthrough solution for in-memory databases. SAP HANA claims that it accelerates analytics and applications on a single, in-memory platform, as well as combining databases, data processing, and application platform capabilities.
SAP HANA is the next-generation business platform that brings together:
· Business transactions
· Advanced analytics
· Social media
· Mobile experience
· Collaborative business
· Design connections
4. What is SAP HANA Studio?
· SAP HANA Studio is an Eclipse-based development and administration tool for working with HANA.
· It enables technical users to manage the SAP HANA database, create and manage user authorizations, create new or modify the existing models of data, etc.
· It is a client tool, which can be used to access the local or remote HANA system.
5. What are the supported platforms for HANA Studio?
SAP HANA Studio runs on the Eclipse platform 3.6. We can use SAP HANA Studio on the following platforms:
· Microsoft Windows x32 and x64 versions of: Windows XP, Windows Vista, and Windows 7
· SUSE Linux Enterprise Server SLES 11: x86 64-bit version
Note: For Mac OS, HANA Studio is available, but there is no HANA client for that.
6. What is SAP HANA 1.5, 1.2, and 1.0 SP03?
They are all the same, and 1.0 SP03 is touted to be the final name that should go into Ramp Up (beta) in Q4 2011. This allows any SAP NetWeaver BW 7.3 Data Warehouse to be migrated into a HANA appliance. HANA 1.0 SP03 specifically accelerates BW calculations and planning, which means that even more performance results can be attained.
7. What is a restricted user in SAP HANA system?
Restricted users are those users who access the HANA system with some applications, but they don’t have SQL privileges on the HANA system. When these users are created, they don’t have the access initially.
If we compare restricted users with standard users:
· Restricted users can’t create objects in the HANA database or their own schemas.
· They don’t have access to view any data in the database as they don’t have the generic public role added to their profiles as for standard users.
· They can connect to the HANA database only using HTTP/HTTPS.
8. What is Schema in SAP HANA?
A database schema is a way to logically group objects such as tables, views, stored procedures, etc. There are three types of schemas.
· User-defined Schema: These are created by a user (DBA or System Administrator).
· System-defined Schema: These schemas are delivered with the SAP HANA database and contain the HANA system information. There are system schemas like _SYS_BIC, _SYS_BI, _SYS_REPO,_SYS_STATISTICS, etc.
· SLT-derived Schema: When SLT is configured, it creates a schema in the HANA system. All tables replicated into the HANA system are contained in this schema.
9. What is the maximum number of tables in a Schema in SAP HANA?
The maximum number of tables in a schema in SAP HANA is 131,072.
10. What is the maximum number of columns in a table in SAP HANA?
The maximum number of columns in a HANA Table is 1,000.
11. What is Schema Mapping in SAP HANA?
Schema mapping is done when the physical schema in the target system is not the same as the physical schema in the source system.
Suppose, we are moving components from the development system (DEV) to the production system (PROD). The tables in DEV reside in DEV_SCHEMA and the same tables should reside in the PROD system in PROD_SCHEMA. If an Attribute View is transported from DEV to PROD, it will not work because the schema name is referenced in the definition of the Attribute View. In order for the promoted objects to work in PROD, schema mapping needs to be set-up in the target system.
Note: Schema mapping only applies to references from repository objects to catalog objects. It is not intended to be used for repository-to-repository references.
12. What are the system requirements for SAP HANA?
· Java JRE 1.6 or 1.7 must be installed to run SAP HANA Studio.
· Java runtime must be specified in the PATH variable.
· We should make sure to choose the correct Java variant for the installation of SAP HANA Studio:
o For 32-bit installation, choose a 32-bit Java variant
o For 64-bit installation, choose a 64-bit Java variant
13. Explain Meta Data, Master Data, and Transaction Data.
· Meta Data: Metadata is data about the data. It tells us about the structure of data or Metaobjects.
· Master Data: This is the key business information such as information regarding customers, employees, materials, etc. This is more like a reference data. For example, suppose, a customer orders 10 units of our product. Instead of asking the customer for the shipping address 10 times, the same can be referenced from the Customer Master Data.
· Transaction Data: This is data related to day-to-day transactions.
14. What is a Delivery Unit in SAP HANA?
Delivery Unit (DU) is a container used by the Life Cycle Manager (LCM) to transport repository objects between the SAP HANA systems. The name of the Delivery Unit must contain only capital letters (A–Z), digits (0–9), and underscore (_).
15. Why do we configure Import Server in SAP HANA?
In order to load data from external sources to SAP HANA, we need to establish a connection with the server. To connect, we need to provide the details of the BusinessObjects Data Services repository and ODBC drivers. Once the connection is established, we can import the table definition and then load data into the table definition.
16. What is SAP HANA Appliance 1.0?
SAP HANA 1.0 is an analytics appliance that consists of certified hardware, an in-memory database (IMDB), an analytics engine, and some tooling for getting data in and out of HANA. The logic and structures are built by the user and a tool is used, e.g., SAP Business Objects, to visualize or analyze data.
17. What is the prerequisite for Unit of Measure in SAP HANA?
We need to import the tables T006 and T006A for Unit of Measures.
18. Explain Column stores and Row stores in HANA.
HANA supports both types of data stores in the database. A row store is used when we need to use the Select statement and no aggregations are performed.
A column store is used to perform aggregations, and HANA Modeling is supported only on column-based tables.
19. Which operating system is supported by the HANA system?
The only operating system that is supported by HANA is Suse Linux Enterprise Server SP1/SP2 (SLES SP1/2).
20. What are the different license key types in the HANA system? Mention their validity.
· Temporary License Key: Temporary license keys are automatically installed when we install the HANA database. These keys are valid only for 90 days, and we should request for permanent license keys from SAP before they expire.
· Permanent License Key: Permanent License keys are valid till the predefined expiration date. License keys specify the amount of memory licensed to the target HANA installation.
21. What is the difference between a Catalog tab and a Content tab?
· Catalog: This contains RDBMS objects like schemas, tables, views, procedures, etc. We can open the SQL editor and design the database objects.
· Content: This is used to maintain and design time repository. We can create new packages and design Information views in the HANA system. Various views can be created under the content tab to meet business requirements and create analytical reports on top of the Modeling views.
22. What are the different perspectives available in HANA?
· Modeler: Used for creating various types of views and analytical privileges
· Administration: Used to monitor the system and change settings
23. What are the supported object types in Modeler perspective?
The supported object types in Modeler perspective are Attribute Views, Analytic Views, Calculation Views, Analytical Privileges, Procedures, Decision Tables, and Process Visibility Scenario.
24. What is the main SAP HANA database component?
The main SAP HANA database component is Index Server that consists of actual data engines for data processing, including input SQL and MDX statements, and performs authentic transactions.
25. Explain Parallel Processing in SAP HANA.
Using the columnar data storage approach, the workload in SAP HANA is divided vertically. The columnar approach allows linear searching and aggregation of data unlike the two-dimensional data structure. If more than one column is to be processed, then each task is assigned to a separate processor. Operations on one column are then collimated by column divisions processed by different processors.
26. Can the table size in SAP HANA database and in the source system be the same?
No, because a HANA database supports compression.
27. What is SQL Script?
It is a set of SQL extensions for SAP HANA database that allows developers to push data-intensive logic into the database.
28. When should the SQL Script be used?
SQL Script should be used in cases where other modeling constructs of HANA, such as Attribute Views or Analytic Views, are not sufficient.
29. What is Label Mapping?
We can choose to associate an attribute with another attribute description. Label mapping is also called Description mapping. For example, if A1 has a label column B1, then we can rename B1 to A1.description. The related columns appear side by side during data preview.
30. What are the different types of Joins?
A Join clause combines records from two or more tables/views in a database.
SAP HANA supports the following types of Joins.
· Inner Join: It selects the set of records that matches in both tables. Inner join should be used if referential integrity is ensured. It is much faster than Outer Join.
o In Attribute Views, Inner Join can be used to join different Master Data tables into a joint dimension.
o In Analytic Views, it can be used if referential integrity cannot be ensured.
· Left Outer Join: It selects the complete set of records from the first table (say, CUSTOMER), with the matching records (if available) from the second table (say, SALES_ORDER). If there is no match, the right side will contain ‘null.’
· Right Outer Join: It selects the complete set of records from the second table (SALES_ORDER), with the matching records (if available) from the first table (CUSTOMER). If there is no match, the left side will contain ‘null.’
· Full Outer Join: It selects all rows from the left table (CUSTOMER) and from the right table (SALES_ORDER). The FULL OUTER JOIN keyword combines the results of both LEFT OUTER and RIGHT OUTER joins.
· Referential Join: It is semantically an Inner Join that assumes that referential integrity is given (referential integrity is the property of a database which ensures that each foreign key value in a table exists as a primary key in the referenced table). Referential Join is, performance-wise, better than Inner Join, but should only be used when we are sure that referential integrity is maintained.
· Text Join: Text Join is used in order to get language-specific data. Suppose, we have a PRODUCT table that contains product IDs without descriptions and a TEXT table that contains language-specific descriptions for each product. We can deploy a Text Join between the two tables to get the language-specific details of each product, along with its ID. In Text Join, the right table should be the TEXT table, and it is mandatory to specify the Language Column.
31. What are Analytic Privileges?
Analytic Privileges restrict users to view data for which they authorize. SAP HANA Analytic Privileges are used for security purposes. They are used to provide authorization on Attribute Views, Analytic Views, and Calculation Views.
Although SQL Privileges provide authorization at the object level, they do not provide authorization at the record level, so to provide both record-level and object-level authorizations SAP HANA Analytic Privileges can be used.
32. What is an Attribute?
An attribute represents the descriptive data used in modeling, e.g., city, country, etc.
33. What is an Attribute View?
An Attribute View is used to model an entity based on the relationship between the attribute data that resides in multiple source tables. We can model columns, calculated columns, and hierarchies.
34. What are the advantages of an Attribute View?
· An Attribute View acts as a Master Data context, which provides text or description for a key/non-key field.
· It can be reused in an Analytic View or in a Calculation View.
· An Attribute View is used to select a subset of columns and rows from a database table.
· Attributes (fields) can be calculated from multiple table fields.
· There is no measure and aggregation option.
35. What are the types of Attribute Views?
· Standard Attribute View: It is an Attribute View that is created by table fields.
· Time Attribute View: It is an Attribute View, which is based on the default time table
· Derived Attribute View: It is an Attribute View, which is derived from another existing Attribute View. Derived Attribute View will be opened in the read-only mode. The only editable field is its description.
36. Explain each part of the Information View editor.
· Scenario Pane: In this pane, the following nodes exist:
o Semantics: This node represents the output structure of the view. Here, it is Dimension
o Data Foundation: This node represents the table that we use for defining the Attribute View. Within this node, we drop the table for creating the Attribute View
· Details Pane: In this pane, we have three tabs, Columns, View Properties, and Hierarchies. Inside Columns, there are ‘Local’ and ‘Show’ tabs
o Local: Here, all local attribute details will be displayed
o Show: Here, we can filter for the local attributes
37. Which engine is used to create an Attribute View?
Join Engine is used to create an Attribute View.
· This engine is used when we execute any Attribute View in HANA or run native SQL on more than one table with a join condition.
· If there are any calculations involved either in the Attribute View or in native SQL, then Join Engine will use Calculation Engine for calculations and for fetching the result.
38. What is a Calculated Attribute?
Calculated attributes are derived from one or more existing attributes or constants, e.g., deriving the full name of a customer (both first name and last name). It is a read-only field, the value of which is calculated based on a specified formula.
39. What is a Calculation View?
SAP HANA Calculation View is a powerful information view.
SAP HANA Analytic View measure can be selected from only one fact table. When there is a need for more fact tables in the information view, then Calculation View comes into the picture.
40. What are the characteristic of SAP HANA Calculation View?
· Unlike other View, Calculation Views support complex calculations.
· They are used to consume Analytic Views, Attribute Views, and other Calculation Views.
· They support OLTP and OLAP models.
· Joins, Union, Projection, Aggregation, and Rank are supported.
· They support client handling, language, currency conversion, etc.
41. What are the types of Calculation Views?
· SAP HANA Graphical Calculation Views (Created by SAP HANA Studio Graphical Editor)
· SAP HANA SQL Script-based Calculation Views (Created by SAP HANA Studio using SQL Script)
42. What are the different types of nodes in a Calculation View?
The different types of nodes in a Calculation View are:
· Join: This node is used to join two source objects and pass the result to the next node. A Join can be Inner Join, Left Outer Join, Right Outer Join, or Text Join. We can only add two source objects to a Join node.
· Union: This is used to perform the union of all operations between multiple sources. The source can be n number of objects.
· Projection: This is used to select columns, filter data, and create additional columns before we use it in the next nodes like Union, Aggregation, and Rank.
· Aggregation: This is used to perform aggregation on the specific columns based on the selected attributes.
· Rank: This is the exact replacement for the RANK function in SQL. We can define the partition and order by clause based on the requirement.
43. What is Calculation View with Star Join?
Calculation View with Star Join does not allow base Column tables, Attribute Views, or Analytic views to get added at Data Foundation. All Dimension tables must be changed to Dimension Calculation Views to be used in Star Join. All Fact tables can be added and they can use default nodes in Calculation View.
44. Can we call an Analytic View or a Calculation View inside another Calculation View in SAP HANA?
Yes. We can call all views (Attribute Views, Analytic Views, and other Calculation Views, as well as tables) inside a Calculation View. Calculation Views are composite views that can be used to combine other views.
45. Which engine is used to create a Calculation View?
SQL Engine is used to create a Calculation View.
· SQL Engine, which is also known as SQL Parser/Interface, is used for all sorts of SQL statements generated by the frontend application via different clients and also for native SQL run at the database level.
· From SAP HANA SP7 version, we have an option for Calculation Views in the ‘Properties’ section, where we can choose a Calculation View to run in SQL Engine. The advantage of this option is that instead of moving data between multiple engines, HANA executes the entire script in SQL Engine to get the final result.
46. What is an Analytic View?
Analytic View is in the form of a star schema, wherein we join one Fact table to multiple Dimension tables. Analytic Views use the real power of SAP HANA to perform complex calculations and aggregate functions by joining tables in the form of a star schema and by executing star schema queries.
47. What are the properties of an Analytic View?
Following are the properties of SAP HANA Analytic Views:
· Analytic Views are used to perform complex calculations and aggregate functions like Sum, Count, Min, Max, etc.
· They are designed to run star schema queries.
· Each Analytic View has one Fact table surrounded by multiple Dimension tables. The Fact table contains the primary key for each Dimension table.
· Analytic Views are similar to InfoObjects and InfoSets of SAP BW.
48. What is Star Join in an Analytic View?
Star Join in an Analytic View joins the Attribute View to the Fact table to create a star schema structure, i.e., one central Transaction Data table being surrounded by multiple Master Data tables. It consumes the Fact table forwarded to it from the Data Foundation node and accepts Attribute Views in it. The output columns chosen after creating the Join are forwarded to the Semantics layer. The output table is then made available to the end-user for data analysis.
49. Which engine is used to create an Analytic View?
OLAP Engine is used to create an Analytic View.
· This engine will be called in the backend whenever we run any queries on Analytic Views in SAP HANA.
· If there are no additional calculations performed, such as calculated columns and restricted measures and counters, then everything will be processed in OLAP Engine.
· OLAP Engine acts as Join Engine for those Attribute Views used in Analytic Views, without any calculated columns. All Join Engine works will be converted into ‘BwPopJoin’, which is part of OLAP Engine.
· If there are any calculations present to be performed, then Calculation Engine will be used along with OLAP Engine.