S4 HANA, BI Analytics, EIM, BIBO, BI Consultant @YASH Technologies
Take a Leap from Big Data to Big Value with SAP HANA 2.0Last updated on June 30, 2017
SAP HANA is a game changer when it comes to data processing and analytics.
Data Modeling is the core of HANA application development. Primarily , Data Modeling is a fusion of both ETL ( extract , transform, load ) technology and business processes. It helps the transformation of disparate and normalized data into an organized structure suitable for reporting and decision-making. The main function of Data Modeling task is to deliver quality and consistent access to data. This exercise results in building a data mart or data warehouse.
Without these processes, Business Intelligence for organizations will be anything but intelligent. Failing to implement a strong data foundation will fail to deliver meaningful analytics.
SAP HANA modeling helps to create rich views and multi-dimensional analytics of data. It has the ability to aggregate, analyze, calculate, compare and forecast enormous volumes of data at speeds unlike any currently available database in the market. Here is a peek into HANA 2.0 Modeling features:
- New modeling environment: SAP Web IDE for SAP HANA (Web IDE*)
- New Calculation View modeling features
- New CDS graphical modeling features
- CDS views vs. Calculation Views: Which one to choose in which scenario
- Data Masking
- Set Operations
- Multiple Selection Handling
Data modeling views are created on top of database tables along with implementing business logic to generate meaningful reports. By using Java, HTML based application or even SAP HANA native applications the modeling views can be consumed. Third party tools like MS Excel can also be used to link with HANA to create reports.
Enhanced performance at runtime by modeling views is achieved by implicit use of optimized SAP HANA In-Memory calculation engines. To get the most out of SAP HANA the SAP views need to be modeled. The views are categorized into:
It represents master data and can be used to join to a dimension or other attribute view. These are highly reused and shared in the other two views.
Designed specifically to execute star schema queries this view leverage the computing power of SAP HANA to calculate aggregate data.
Used on top of the above two views, the calculation views are composite views. It can perform complex calculations.
- Enable load balance read-intensive operations between a primary and secondary instance of SAP HANA with the active / active-read.
- Automate orchestration of HA/DR processes with enhanced SAP Landscape Management integration.
- Optimize workload for 3rd party backup tools by consolidating SAP HANA log backups.
- Manage one instance, multiple tenants or 1000’s of SAP HANA instances within the SAP HANA Cockpit administration and monitoring tool.
- Prevent run-away queries and manage system thresholds with enhanced workload management.
- Reduce time and cost when implementing change by capturing, comparing and analyzing multiple workload replays.
Improved searching and filtering on dates. Dynamic search rules help to detect duplicate data. Batch mode search run can check a large number of records in a single call.
Easily embed natural language processing into company’s products with a new native SQL interface. Text analysis is possible for all languages including ones using space between words. Manage domain-specific custom dictionaries and rules within the Web IDE for SAP HANA.
Graphic Data Processing:
New visualization enables more efficient and faster graph data analysis. Leverage existing Cypher query language skills for Cypher for pattern matching.
Predictive Analytics and Machine Learning:
More pre-packaged algorithms helps to create richer predictive applications. Parallel processing across large-scale partitioned data can run-scoring functions faster.
Suresh Suravarapu S4 HANA, BI Analytics, EIM, BIBO, BI Consultant @YASH Technologies
For More Information Download SAP HANA Services Brochure
VarshaApr , 2018
Hello Suresh Suravarapu, THANKS SO MUCH for sharing this! I would love to buy you a coffee since I now won’t be up all night that has been driving me crazy (until now!!). I just wish I knew what was going wrong but so glad it’s in the right place now! Thanks again:) I have created one ADSO through SAP BWMT 1.18 version on SAP HANA edition 1. sps11 with SAP HANA Studio version been 2.3.32 and then created calculation view on top of the hana view table for my ADSO. The view is active without any error, Checked SYS_BIC column views. but when i do Data preview i get error "View not found. Either the view is inactive or the selected attribute is not present in the active view." I went through few discussion and it was noted that latest version of the HANA studio solved the issue but they did not precise what was their version and Environment details. Could you please help me out on what could be the reason for such error? Below is the link i referred before. https://archive.sap.com/discussions/thread/3940017 By the way do you have any YouTube videos, would love to watch it. I would like to connect you on LinkedIn, great to have experts like you in my connection (In case, if you don’t have any issues). Please keep providing such valuable information. Thank you, Varsha
RahulMar , 2018
Hi Resma, Thanks for the post. Very good details. Worked like a charm. Good directions. I create in HANA custom Package and Calculation View. If I use users superuser I can see my custom calculation view. If i use users not superuser I can't see it. Is not an authorization problem because I set "full autorization" and I have the same problem I have the same issue also if I log on with "SAP Business One Excel Report and Interactive Analysis" : I can't see my model in "new pivot table". Excellent tutorials - very easy to understand with all the details. I hope you will continue to provide more such tutorials. Thank you, Rahul
resma biswalJan , 2018
Really I like your post.thank you for sharing.