Advanced Analysis with SAP HANA Tables and Views

Steps in HANA

Select database use has two types of databases SAP & NON SAP Based on databases and loading performances we need to select replication methods We have three types of replication methods in Hana

1. Data Services (ETL Tool)
2. Lt trigger-based
3. log-based

Or we can bring the data from different data sources. Using data provisioning

NOTE: we can use data provisioning for less amount of data & initial load, not for delta Loads. And after finishing loading data from different sources into tables we need to model the views. Here we have two types of views

1. Relational view
2. OLAP view

Based on the reporting requirement we will create the above views to increase the performance Creating relational views Right-click on the table and create a new view If you want we can add multiple tables & join multiple tables ( with inner/outer (left, Right, full)) Select required columns And activate Create column view (OLAP)  

1) Analytical view

Right-click on the package to create a new analytic view Select the required tables and attribute views If you take multiple tables to join multiple tables (with inner/outer (left, Right, full)) Select the required column from the table and classified as attribute & measures And create customs calculated Attributes, calculated measures, Restricted measures & custom variables & activate

2) Calculated view

Right-click on the package Create new calculated view We can create two types of calculated views.

1. Graphical
2. Script Script

In the script pane provide script and right side create the output structure and provide column Names & types In the output pane classify objects that have attributes measures & calculated measures & variables and activate Graphical Select required tables & views (attribute, analytic and calculated views) Connect they by using projection, union, join (inner/outer(lefty, righty, full)) In output pane classify objects as an attribute, measures and create custom Measures based on report requirements &k activate  

Steps in business object advanced analysis: Logon to business objects Start programs SAP Business objects à analysis for Microsoft Excel. We will get Excel with analysis (tab) Click on the insert data source and select log on to Business Object BI platform. So you will get a dialog box. Provide URL Like “http//<application server>; <port>/dswsbobje/services/session. So that you will get the dialog box for data sources Select our system (HANA system) Provide username password and port number and click on connect Select catalogs, select the required catalog & select tables/views and Ok So you will get a separate screen for advanced analysis as bellow.       

Step’s for Query Design

Activates for Designing analysis reporting for Excel

Inserting a cross tab

Select the Insert data source

Select source system & drag object hurt Rows columns & filters

If you want to refresh the value in the cross tab we should select display on advanced analysis options and we can pass the refresh

Formatting Data: We can format data in two ways for attributes

By right-clicking the value of characteristics and selecting member display ------- text/key

Inertly click on member display ---- and select text /key

For numbers right-click on measure value select number format and we will get a dialog box for member format select scaling factor and decimals

Sorting & Filtering: Right-click on any column and select ascending/deceiving and we can sort culture reports based on attribute values or measure values We can filter data by members or measures. For members select operators like b/u outside, greater than, less than, greater than or equal to, less than or equal to, equal to and not equal to and not equal to W can comb me multiple lilting by using and /or

Charting: For charting, we must have at least ova measure and select our cons tab Click on chart select chart type and ok

Conditional Formatting

Right-click on the measure column and select filter by member menu we will get a dialog box for conditional formatting so provide the name

1. provide the name
2. Based on ----- (Measure)
3. Format ------ (Background, value, status symbol tend ascending, trend descending trend grey)
4. In definition (tab) a) Select color b)Select operator like (=,       >, <,)
5. in selection (tab):- We will get all attribute values and restrict the values
6. in the display (tab) Select options for conditional formatting like Data cells Row Headers Column Headers

Publishing reports: After design reports, we can publish reports into business object entries.

For in-depth knowledge of SAP HANA, click on below

• Performance Tuning in SAP HANA
• Security in SAP HANA
• Analytical Privileges in SAP HANA
• Organizing system Landscapes in SAP Hana
• Security in SAP HANA
• SAP HANA Views