Advanced Analysis with SAP HANA Tables and Views

Blog Author


Published Date

22nd September, 2020




  • Share this blog :


Steps in HANA

Select database use has two types of databases SAP & NON SAP Based on databases and loading performances we need to select have 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’s 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 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 package create new analytic view Select 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 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 output structure and provide column Names & types In the output pane classify objects 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 required catalog & select tables/views and Ok So you will get a separate screen for advanced analysis as bellow.   Screenshot_1    

Step’s for Query design

Activates for Designing analysis reporting for Excel

Inserting a cross tab

a) Select the Insert data source

b) Select source system & drag object hurt Rows columns & filters

c) 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

1)  By right-clicking the value of characteristics and select member display ------- text/key

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

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

Sorting & Filtering: Right-click on any column select ascending/deceiving and we can sort culture report based on attribute value 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

If you want to enrich your career and become a professional in SAP Hana, then visit Tekslate - a global online training platform: "SAP Hana Administration Training"   This course will help you to achieve excellence in this domain.

Conditional Formatting

Right-click on the measure column 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 objects entries.

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

About Author


Author Bio

TekSlate is the best online training provider in delivering world-class IT skills to individuals and corporates from all parts of the globe. We are proven experts in accumulating every need of an IT skills upgrade aspirant and have delivered excellent services. We aim to bring you all the essentials to learn and master new technologies in the market with our articles, blogs, and videos. Build your career success with us, enhancing most in-demand skills .

Related Blogs

Write For Us