Tuesday, December 13, 2016

Connection Technologies from BO to HANA IDT

http://www.guru99.com/sap-hana-reporting.html

SAP BI (Business Intelligence):  data warehousing and reporting tool

3 tier architecthure: 1)Database server, 2)Application server, 3) Presentation Server

1) Database Server:  data is physically stored in PSA, ODS, Infocube
2) Application server:  It is used to access data from Database server and process data for presentation in server
3)Presentation Server - it displays the data to the user

SAP Business Objects Platoform:  BO tool use the JDBC/ODBC to connect to the source system


  • Webi is adhoc reporting tool
  • Webi is used for detail level reports



IDT(Information Design Tool):


  1. Create Universe by IDT
  2. Create Relational Connection Parameter
  3. To consume Universe by Webi, Dashboard or Crystaql reports for Enterprise, publish the connection
  4. Create universe (business rep. of your data warehouse or transactional db.  Allows users to interact with db without knowing the complexities
  5. Details of IDT


5 Steps of creating Universe by IDT:

Step 1: Create Universe using IDT

A) Launch IDT

  1. Start Menu 
  2. SAP BZN Intelligence
  3. SAP BO BI Platform client tools
  4. Information Design Tool
B) Navigate to Project Option
  1. Click on File
  2. Click on new option
  3. Select Project Option
or 
  1. New file icon
  2. project

C)  New Project
  1. Enter name of project
  2. Finish
2 Connections available for Webi: 1) Relational Connection 2) OLAP Connection
  1. Relational Connection: access data from a table and access regular RDBMS use relational connection
  2. OLAP Connection:  Access data from the application (SAP, Oracle, Microsoft, SAP BO) and data stored in Cube view use OLAP connection
Step 2: Create Relational Connection: 

Project ==>  New ==> Relation Connection Source Name

*POP UP*  
Resource name (SAP HANA) ==> Next

*POP UP*  
A)JDBC Drivers under SAP HANA DB 1.0 ==>  Next

*POP UP*  
          New Relational Connection parameter
A)Authentication Model  
B)Enter HANA UN  
C) Enter Password 
D) Single Server or Multi Server in Source Section 
E) Host name
F)  Instance number
G)  Test Connection


Step 3)  To Consume Universe by Webi, Dashboards, or Crystal Reports for Enterprise, publish the connection

A)  Select SAP HANA.cnx under "WEBI_DHK_HANA
B) Publish connection to a repository
C)  Publish connection with name SAPHANA.cns will be created after successful publish in the repository

*popup*  Select Bzn IDT ==>  Finish
*popup*  Connection published successfully


Step 4)  Create universe (business representation of your data warehouse or transaction db.  allows user to interact with db without knowing the complexity)

SAP business Layer:

Before SAP BOBI 4.1 version, we need to create a derived table while building data foundation and map the variable and input parameters.

A) Automatically create data foundation and business layer on selected SAP HANA Views
B)  Automatically detects the input parameters and variables

Select Project from step 1 ==>  New ==>
SAP HANA Business Layer:
A) Business layer name, B) Data foundation name, C) Descriptions

popup (connection for SAP HANA) ==> a)tick for SAPA HANA.cnx
popup (SAP HANA information models) ==>  a) select analytic view(AN_PURCHASE_ORDERS) B)FINISH



Step 5)  Detail of IDT

1)  under project -all relational connection, business layer, and data foundation will be displayed
2)  Repository resource section, object (Connection, Business layer, etc.) stored in the repository will be displayed
3) Business layer shows business view of Analytic view (functional person)
4)  Data foundation shows column name and table names (technical person)


Step 6) Business Layer Section (Analytic View)

1)  Select Data Foundation
2)  Drag and Drop column to foundation view
3)  Displayed under analytic view
4) Dragged field will be displayed under analytic view

Step 7)  Save All

Step 8)  Create Query and View output

  1. Queries
  2. Query Panel (select field to include in query)
  3. Drag/drop/refresh
  4. Results displayed



No comments:

Post a Comment