HA100 - Introduction 1.6 Time to Rebuild the Platform

SAP HANA is a platform built on modern software.

This platform provides 4 key components :-
- Application Services -  Provide full development environment(design time and run time) with productivity tools. 2-tiers model application is possible as SAP HANA can process business logic and database together, no application server is needed.

- Processing Services - Able to process new types of data like text, spatial, graph. SAP HANA provides native processing engine for these new data types that can process them in real-time.

- Integration Services - Able to analyze continual streaming data, read data remotely(any data source), read Big Data(eg Hadoop with DB & devices - IoT),   ETL

- Database services - Column and Row stored databases that support OLAP & OLTP application, store data optimally with automatic compression, different storage tiers to support data ageing strategies, High Availability and Disaster Recovery functions .

Above is the summarized of my study and understanding for C_HANAIMP_12 certification preparation.
For more info, please refer to course material HA100 from SAP.

HA100 - Introduction 1.5 Managing the New Bottleneck

With multi-leveled CPU caches, data can be fetched to processor for processing faster.
eg
L1 Cache - 0.5 Nanoseconds
L2 Cache - 7.0 Nanoseconds
L3 Cache - 15.0 Nanoseconds

Comparing to the speed of 
Main memory - 100 Nanoseconds
Disk - SSD 150K Nanoseconds / HD 10M Nanoseconds

Traditional disk will be used as backups / logging  purposes and could eventually replaced by SSD.

Above is the summarized of my study and understanding for C_HANAIMP_12 certification preparation.
For more info, please refer to course material HA100 from SAP.

HA100 - Introduction 1.4 Advances in Technology

With advances in technology, 
- large and cheaper memory is available
- multi-core processors
- on-board cache (keep most useful data)
- modern blade server enable high scalability

SAP HANA fully utilizes advantages above and deliver a high processing power and real-time platform by redesign of business software.

Above is the summarized of my study and understanding for C_HANAIMP_12 certification preparation.
For more info, please refer to course material HA100 from SAP.

HA100 - Introduction 1.3 One platform for all applications

To solve IT complexity issue and to adapt today fast growing of digital world, SAP HANA provides
a platform to store single copy of data available to all application, regardless of type and architecture and there will be no data management is needed. SAP HANA is also supporting OLAP and OLTP applications and can be implemented on-premise or in the cloud.

In summary now
- Unified application workloads brings holistic / complete business view
- Unified / single copy of data enable ability to react in real-time
- Real-time processes enable ability to innovate

Above is the summarized of my study and understanding for C_HANAIMP_12 certification preparation.
For more info, please refer to course material HA100 from SAP.

HA300 2.5 Currency Conversion

SAP HANA provided currency conversion tools as it is very often that user might to convert the currencies in report. Considering transactions might be made using different currency and currency conversion is needed to consolidate report from different region or to use global reporting currency in corporate reporting.

We can achieve this by creating a measure attribute with semantic type Amount with Currency in calculation view.

This can be done in graphical interface as well as script based views.
Graphical interface for currency conversion is preferable method to use because script based calculation views is using CONVERT_CURRENCY from SQL Script function, which is based on deprecated Column Engine Plan Operators / CE function.

There are 4 steps to create and enable currency conversion in graphical calculation view  :
1) Create a measure with semantic type Amount with Currency
2) Tick to enable for conversion
3) Define Target currency (fixed / refer to another column / input by user)
    Define Source currency fixed / refer to another column )
For input by user, define a input parameter with VARCHAR length 5 and assign as target currency.

4) Define conversion date (fixed / refer to another column / input by user)
Due to fluctuation of currency rate, date is important to be taking into consideration while performing currency conversion. Date can be defined by referring to another column ; or to be input by user.

One important thing to check is we must make sure TCUR schema is available and replicated for currency conversion use. The purposes of these TCUR* table is to define currency, rate type, rate. TCURX will be used for decimal shift places purposes.

Upon any currency conversion error , we can default the value to failed / NULL / ignore.

HA100 - Introduction 1.2 IT Complexity is Stifling Growth

 Typical IT landscape over years can be complicated due to
- Multiple application developed / purchased / acquired under different platform
- Different development languages / hardware / databases / server & OS from multiple vendor

To adapt new technology and adding complexity in IT landscape causing
- Huge effort from IT team to integrate among application / system
- Move data, harmonizing, cleaning, resulting duplicate of data
- Huge demand on system a lot processing power to do data consolidation, can be slow
- Not useful and fragmented views of data due to duplicate copies of data
- High maintenance cost due to multiple skills needed
- Lack of innovation and agility to adapt today growth of digital world 

In summary
- Data in different application silos is causing no holistic view / partial business view
- Multiple copies of data is causing no real time insight to user
- Batch processing lead to limited ability to innovative

Above is the summarized of my study and understanding for C_HANAIMP_12 certification preparation.
For more info, please refer to course material HA100 from SAP.

HA100 - Introduction 1.1 The World is Changing

SAP introduced a new platform SAP HANA.to adapt with new digital world and growing a company business, considering

- More devices moving online and valuable data generated
- User demands for real-time, new and innovative application enable deep insight information
- Adding complexity to existing IT landscape to keep pace with the trends not a good solution
- Process new types of data such as spatial data
- Faster data processing power, acquire real time data enable real-time decision making

Above is the summarized of my study and understanding for C_HANAIMP_12 certification preparation.
For more info, please refer to course material HA100 from SAP.