22nd September, 2020
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
Procedure to create a semantic layer (UDT) Create an ODBC connection
Go to start settings content panel administrator tools Data source (ODBC)
Select system ADM (tab) click on sys adm (tab) click on add select HDBODBC32 connection
Provide ODBC connection name: __________
Port NO :___________ Click on connect provide usr name : _________ & Password:_________ and OK
Log on to universe design tool create universe click on new connection select connection type is secured provide connection name (universe connection Select ODBL connection type (SAP SAP – In __ memory) ODBC provide universe parameters and OK
It is a semantic layer which contains a business layer to provide data to the reports
Log on IDT
NOTE: Connection should be secured & ROLAP type
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
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
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
use OLAP connections (BICS)
Create SAP dashboard
Select BW connection 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:
Create ODBC connection for SAP HANA
Create crystal reports select 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
NOTE:-The query must have at least one attribute measure
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.
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.
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 .
Write For Us