Semantic Layers in SAP Hana

Blog Author


Published Date

22nd September, 2020




  • Share this blog :


Semantic Layers 

1. Consumption of HANA views /Tables/NUDT to Prepare BO Semantic buyer;-

UDT is a (universe designer tool) to prepare structure based on report requirement by using Table structure in HANA DB.  


House we can bring only table structure from the database instead of disturbing data in DB

  • We can design structure joining tables band business, so we need to concentrate on cardinality (1-1, many to 1, 1 to many, many to many)
  • While property structure will get some complex scenario like loop & traps
  • Loops it brings less amount of data rather than actual data in attributes So, we can solve the loops by shortcut, alias, context
  • Traps bring more data them actual date so, we can slow this problem by using context and we can add features like hierarchies, disturb values, cascading disturb values, cascaded objects based on requirements.

Procedure to create a semantic layer (UDT) Create an ODBC connection

Go to start   Untitled   settings  Untitled   content panel    Untitled     administrator tools    Untitled   Data source (ODBC)

Select system ADM (tab)  Untitled   click on sys adm (tab)   Untitled  click on add   Untitled  select HDBODBC32 connection

Provide ODBC connection name: __________

Port NO   :___________ Click on connect   Untitled   provide usr name : _________ & Password:_________ and       OK

Log on to universe design tool create universe click on new connection select connection type is secured   Untitled    provide connection name (universe connection Untitled  Select ODBL connection type (SAP  Untitled  SAP – In __ memory)  Untitled  ODBC  provide universe parameters and   OK

  • Insert the required table & view and prepare the structure and follow above mention methodologies create classes & objects
  • Cheek the integrity
  • Save and export to the system repository
  • We can create web1, crystal, explore and dashboard

2)Consumption of HANA views | Tables in IDT To prepare BO semantic layer

  It is a semantic layer which contains a business layer to provide data to the reports


Log on IDT

  • Create a new project
  • Create a new connection

NOTE: Connection should be secured & ROLAP type

  • Select our HANA ODBC connection
  • So will get a connection in the form of.CNS
  • After we need to export the connection into the system repository
  • Create a Data foundation by selecting our shared connection
  • Select the required tables and views and prepare the structure
  • We need to join the tables and views with the coordinates based on business report requirement
  • We need to follow rules to designs the structure
  • Create a business layer
  • Select our data foundation, save, & export into the system repository
  • After exporting our business layer we can create reports like web 1, explorer, crystal reports

NOTE:- For both UDT & IDT we can create views from ‘ – sys – bic’ for catalog only For tables we can bring form any catalogs  

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.


website reports:- It is a web paged report which provides refreshed values

  • We can create web-I reports from UDT & IDT
  • We can create web-I reports in launchpad 


Create ODBC connection

create the universe from UDT

Or  Export into system Repository Business layer from IDT

Log on to launchpad

create a query from universe select our universe

Design Query

Based on report requirement, we can use measures, attributes, hierarchies, files, based on report requirement

execute query will get a report

so, based on requirement we can add features like alerts, ranking, variables, filters, build-up drill down, chaas, tables & relative positions ………………. Etc

Save reports & publish into public folders

We can use web reports for Xceleries & live office


It is which contains tables, charts, & other components


create ODBC connection

create IDT

use OLAP connections (BICS)

Create SAP dashboard

Select BW connection   Untitled   we can take connection from BICS & cube & views (calculated & analytic)

Select the component to model data

prepared dashboards by using alerts like extra ranking.

3) Crystal reports:

  • It mainly depends on Xcel, they are mainly cal based report
  • We can create crystal reports from views & tables by using HODBC & TDBC connections directly
  • Here no, need to create JDBC & ODBC


Create ODBC connection for SAP HANA

Create crystal reports Untitledselect HANA ODBL connection as a source

Select tables & prepare the schema

In a field explorer  select the required column from the table

Apply the cosmetics prompt, alerts, calculated columns, variables, filters, links …… etc

Based on Requirements we need to creates sub-queries | reports

Save export into the B.O Enterprise


It is a web-based dashboard


  • Create ODBC connection
  • log on to IDT
  • create a project
  • Create relational connection (secured) (.CNS)
  • Export into system repository will get in the form of CNX
  • Create data foundation by selecting connection Insert required tables & views and the prepare the structure based on the reels
  • create a business layer
  • select our data foundation, & save our Business layer and export into the system repository
  • so, will get in the form of UNX
  • Log on to the explorer by providing URL http://sysname:8080/explorer
  • log on & click on manage spaces
  • click on new query
  • select out business layer
  • prepare query
  • and save it

NOTE:-The query must have at least one attribute measure

  • create an index for our query
  • we can drill on the report
  • based upon the reporting requirement we can apply cosmetics like scenery order, charts alerts tables, and publish into the public folders.

Appendix procedure:

Procedure:- To maintain consistency with SQL standard, functions will be called procedures The following example shows the procedure implemented is SQL script based on the new syntax.  To better illustrate the high – level concept, we omitted details. CREATE PROCEDURE get output (in-out integer, in currency varchar (3), Out output – pubs tt – publishers, Out output – year tt – years, LANGUAGE SQL SCRIPT READS SQL DATA as BEGIN Big – pub – ids = SELECT publisher FROM (query1) books Group by publisher HAVING COUNT (brr) .: cnt: Big – pub – books = SELECT title, price ---- Query 2 FROM big – pub –Ids, publishers, books HERE pub – ID = fid and pub = id = publisher AND crcy = currency; Out put-puts = SELECT SUM (Query 3)(price) FROM big – pub – books GROUP by publisher: Output – year + SELECT SUM (price) FROM big – put – books GROUP by year; END; The SQL script above defines read-only procedure which have 2 scalar input parameters and 2 output parameters or type table.  As different languages are supported in the body of the procedure, the Implementation language is supported in the body of the procedure, the Implementation language is defined to be SQL script. Moreover, the procedure is a read-only procedure. Here it is free of side effects and can be called by other reads – only procedures. The first line contains a SQL query Q1 which identifies big published  (using the input parameter count). Afterward, detailed information about these publishers along with their corresponding books is determined in Query Q2. Finally. This information is aggregated in two different ways queries W3 (aggregated per publisher ) and Q4 (aggregated per year) respectively. The resulting tables constitute the output of the functions.   Screenshot_1   

A procedure is a SQL script that only uses declarative constructs that can be completely translated into an acyclic data flows graph where each node represents a data transformation. The example above could be represented as a data flows graph In the picture similar to SQL queries the graph is analyzed and optimized before execution For optimization the subgraph of the called functions is merged with the graph of the calling function and the resulting graph is the optimized The optimization applies security rules as SQL optimizer use’s for its logical optimization then the plan is translated into a  physical plan which consists of physical database operations.

Get In-Depth Knowledge:

Predictive Analysis in SAP Hana

Assumptions in SAP Hana


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