• USA : +1 973 910 5725
  • INDIA: +91 905 291 3388
  • info@tekslate.com
  • Login

Advanced Analysis with SAP HANA Tables and Views

Steps in HANA

Select database use  have  two types of data bases SAP & NONSAP

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 report requirement we will create above views to increase the performance

Creating relational views

Right click on table create new view

If you want we can add multiple table & join multiple table ( 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 required column from table and classified as attribute & measures

And create customs calculated Attributes, calculated measures, Restricted measures & custom variables & activate

Desired to gain proficiency on SAP HANA? Explore the blog post on SAP HANA Training to become a pro in SAP HANA.

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 script pane provide script and right side create output structure and provide column Names & types

In output pane classify objects has 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(left, righty, full))

In output pane classify objects as 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 insert data source and select log on to Business Object BI plat form. So you will get 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 separate screen for advanced analysis as bellow

 

Screenshot_1

 

 

Step’s for Query design

Activates for Designing analysis reporting for Excel

Inserting cross tab

a) Select Insert data source

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

c) If you want to refresh value in 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 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 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, grater than, less than, grater 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 measure column select filter by member menu we will get dialog box for conditional formatting so provide name

1)   provide name

2)   Based on —– (Measure)

3)   Format —— (Background, value, status symbol tend ascending, trend  descending trend grey)

4)   In definition (tab)

a) Select colour

b)Select operator like (=,       >, <,)

5)   in selection (tab)  :-

We will get all attribute values and restrict the values

6)   in 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 an Indepth knowledge on SAP HANA, click on below

Summary
Review Date
Reviewed Item
Advanced Analysis with SAP HANA Tables and Views
Author Rating
5

“At TekSlate, we are trying to create high quality tutorials and articles, if you think any information is incorrect or want to add anything to the article, please feel free to get in touch with us at info@tekslate.com, we will update the article in 24 hours.”

0 Responses on Advanced Analysis with SAP HANA Tables and Views"

    Leave a Message

    Your email address will not be published. Required fields are marked *

    Site Disclaimer, Copyright © 2016 - All Rights Reserved.

    Support


    Please leave a message and we'll get back to you soon.

    I agree to be contacted via e-mail.