Wednesday, December 14, 2016

BO explorer/Universe

BO Explorer (BEx)

SAP Business Explorer is the traditional and native frontend for SAP BW-based reporting, analysis, and business planning in maintenance mode. For all SAP Business Explorer customers interested in the future of BEx, here is what you need to know.


  • -ad hoc analysis tool that is browser-based and provides zero footprints 
  • -Data is embedded into Microsoft Excel workbooks providing users with drag-and-drop capabilities to drill down and filter the data using SAP BI OLAP functions. 
  • -BEx suite provide solutions for enterprise reporting, ad hoc OLAP analysis, and dashboarding.



SAP Bex Query Designer (Component of SAP BI) can access SAP HANA View as info provider and display data in Bex.

Questions(here and on bottom of page for Universe)


Qs:17 Which of the following must you do in order to use SAP BusinessObjects Explorer on SAP HANA data? (Choose two)

A. Create a delivery unit. 
B. Create a business layer. 
C. Create an information model. 
D. Create an information space.

Once the data is loaded into BWA, it has to be made available for Explorer, this process is called to Manage Spaces.

Qs:32 A customer wants to report on large amounts of SAP HANA data. The users want to drill from the top aggregation level to the lowest granularity and try different types of graphical representations of the data on the fly. Which SAP BusinessObjects reporting tool would you recommend?


A. SAP BusinessObjects Dashboards 
B. SAP BusinessObjects Web Intelligence 
C. SAP BusinessObjects Explorer 
D. SAP BusinessObjects Crystal Reports for Enterprise

#Which BO tool good for visualization: BO Explorer

   BO Explorer = Search relevant information and direct exploration of data


G)  BI-4.0 :
i.   BI Platform
        ii.  BO Explorer
       iii.  BO Web Application Server

       iv.  BO Repository


Is Explorer preferred?  No, (max 3 KPIS/ variable/hierarchy)

KPI(Key performance indicator)  a business metric used to evaluate factors that are crucial to the success of an organization. 


---------------------------------------------------------------------------------------------------------------------

Qs:16 Which of the following does an SAP BusinessObjects universe use to communicate with SAP HANA?

A. ABAP 
B. SQL 
C. MDX 

D. BICS


14. Business Layer steps/ Semantic Layer
Ans --> create Package --> Create Relational Connection --> Create Data Foundation --> Publish Data Foundation to Repository --> Create Business Layer ( universe) --> Publish Business Layer to Repository.



17.  Which universe is used for Semantic Business Layer?    Relational Universe (BO)

Information Designer Tool


Which tool is used to create Universe for reporting in dashboard ?    Information Design Tool (IDT)

71)Pre-requisite to execute Crystal reports enterprise?
·          JDBC / ODBC Interfaces
·         Relational Universe


Why universes are used : additional security or filed names uniform ..etc 

SAP HANA Modeling is based on SBO Information Designer (“Universe”)


use of the universe, where do you use it?



requirement for the analytic view: table, attribute view



sys_repo ->

tzhana => security, authentication, authorization
back up and recovery => Param's Arani consulting document
non-sap erp data extration to HANA is done by BODS.
extraction of data from

S1) Project name/ Local Projects

               A) Relational Connection B) OLAP CONNECTION
S2) Relational Connection 
           
               A)JDBC Drivers Option under SAP HANA DB 1.0
                      i)authentication mode   ii)UN  iii)PW  iv) Single Server in data source section v) instance number
                      vi)  Test Connection Button to verify the connectio

S3)  Consume Universe by Web Intelligence, Dashboards or Crystal Report for Enterprise, publish connection for SAP HANA.cnx
               
               A) SAP HANA.cnx under Project "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

               1) Select BZN IDT
S4)  Create Universe (Bzn representation of your data warehouse or transaction database. )
             use BZN Layer: 

SAP HANA Business Layer automatically creates a data foundation and business layer based on selected SAP HANA Views.
SAP HANA Business Layer automatically detects the input parameter and variables.
                               1) Project Created "WEBI_DHK_HANA  2) R.click project and select a new option
                                3)  select optioin "SAP HANA BZN layer"
             SAP HANA BZN Layer:  1) BZN Layer Name, 2) Data Foundation NAME, 3) Description 4)Next
Click analytic view

S5) i)Under Project- all Relational Connection, Business Layer, and Data Foundation will be displayed.
     ii)Repository rsc section, object stored in the repository will be displayed
     iii)  BZN layer shows BZN view of Analytic view
     iv) Data foundation shows table and column name.

S6) Drag field under analytic view (AN_PURCHASE_ORDER)
S7)  Save all
S8)  Create a query and view output



=====


Create Universe using Information Design Tool


Step 1) In this step, we will create a universe Using Information Design Tool (IDT).

HANA can be accessed via ODBC and JDBC drivers, and its tables can be defined and queried with SQL language. Tables are managed with a tool called HANA Studio.

  1. Launch IDT by navigating to
Start Menu -> SAP Business Intelligence -> SAP Business Objects BI platform 4 Client Tools -> Information Design Tool

Information Design tool screen will appear. To create a universe we need a project in IDT.
  1. Navigate to Project Option as below-
    1. Click On File.
    2. Click on New option.
    3. Select Project option.

A pop-up for New Project will appear- In this pop-up, enter following details:

1. Enter name of project

2. Click on finish button.

A project is a local workspace where you store the resources used to build one or more universes.

There are two connections available, detail of each is as below –
  1. Relational Connection – To access data from a table and access regular RDBMS use Relational Connection.
  2. OLAP Connection – To access data from the application (SAP, Oracle, Microsoft, SAP BO) and data stored in Cube / Information View use OLAP connection.
Step 2) Now we create a Relational connection.
So go to Project - > New -> Relational Connection.
A Pop-Up for New Relation Connection source name appear-
  1. Enter Resource Name.
  2. Click on Next Button.

A Pop-Up for Database Middleware Driver Selection will appear-

  1. Select JDBC Drivers option under SAP HANA Database 1.0.
  2. Click on Next Button.

A pop-up for New Relational Connection parameter will be displayed, enter following details into it.
  1. Authentication Mode will be selected as "Use Specified User Name and Password".
  2. Enter HANA User Name.
  3. Enter Password.
  4. Select Single server in DATA Source section. Enter Host Name (here best: 30015).
  5. Enter Instance Number.
  6. Click on Test Connection button to verify the connection.
After successful Connection, a connection with name SAP HANA.cnx will be created.
Step 3) To consume Universe by Web Intelligence, Dashboards or Crystal Report for Enterprise, we need to publish the connection. So, now we publish connection for SAP HANA.cnx.
  1. Select SAP HANA.cnx connection under Project "WEBI_DHK_HANA" and right click.
  2. Select Publish Connection to a repository.
  3. A Publish connection with name SAPHANA.cns will be created after successful publish in the repository.
A pop-up for publishing connection to repository appears –
  1. Select Business IDT.
  2. Click on finish button.
Now we create Universe by using SAP HANA Business Layer.
Step 4) Create Universe (Universe is a business representation of your data warehouse or transactional database. Universe allow the user to interact with data without knowledge of complexities of the database).
To create universe, we use SAP HANA Business Layer as below -
SAP HANA Business Layer
From SAP BOBI 4.1, SAP provides a new option "SAP HANA Business Layer" while creating the universe using Information Design tool.
Before SAP BOBI 4.1 version, we need to create a derived table while building data foundation and map the variable and input parameters.
SAP HANA Business Layer automatically creates a data foundation and business layer based on selected SAP HANA Views.
SAP HANA Business Layer automatically detects the input parameter and variables.
We Create Universe through SAP HANA Business Layer as below-
  1. Select Project Created "WEBI_DHK_HANA".
  2. Right click the project and select a new option.
  3. Select option "SAP HANA Business Layer".

A Pop-up for SAP HANA Business Layer appears-

  1. Enter Business Layer Name.
  2. Enter Data Foundation Name.
  3. Enter Description.
  4. Click On Next Button.
A Pop-up for Select SAP HANA Connection displayed-
  1. Tick on Connection "SAPHANA.cnx".
  2. Click on Next Button.
A Pop-up for selecting SAP HANA Information Model will be displayed.

  1. Now Select Analytic View (AN_PURCHASE_ORDERS) Created under HANAUSER Package.
  2. Click on Finish Button.
The analytic view will open in Information Design tool.
Step 5) Detail of Information Design tool will be as below-
  1. Under Project- all Relational Connection, Business Layer, and Data Foundation will be displayed.
  2. In repository resource section, object (Connection, Business Layer, etc.) stored in the repository will be displayed.
  3. Business Layer shows Business view of Analytic view. It is for Functional Person.
  4. Data Foundation shows table and column name. It is for Technical Person.


Step 6) In this step,
Select Business layer section, go to the folder with the name of Analytic View.
Now follow points as below-

  1. Select data foundation section.
  2. Drag and drop column to Analytic View
  3. It will display objects under Analytic View
  4. Dragged field will be displayed under Analytic View (AN_PURCHASE_ORDER).


Step 7) In this step, save all object.

Go to file and click on "Save All" option to save all objects.



After that, follow the step below.
Step 8) Create a Query and view output.

  1. Go to Queries option.
  2. A Query panel will be displayed, Select the field to which you want to include in Query.
  3. Drag and drop them to "Result object for Query #1 "section.
  4. Click on Refresh Button on Result set section.
  5. Result will be displayed.
====





Questions(Universe):

1) Which of the following does an SAP BusinessObjects universe use to communicate with SAP HANA?

A. ABAP 
B. SQL 
C. MDX 

D. BICS


2) Business Layer steps/ Semantic Layer (UNIVERSE)
Ans --> 1) create Package --> 2) Create Relational Connection --> 3) Create Data Foundation --> 4) Publish Data Foundation to Repository --> 5) Create Business Layer ( universe) --> 6) Publish Business Layer to Repository.

A) What are automatically created in steps 4?

 Business Layer and Data Foundation


1)Create Project --> 2) Create Relational Connection(Server, instance number) -->  3) Publish Connection to repository --> 4) Create Universe: DW or trans. DB( Automat. Creates Data Foundation and Business Layer) --> 5) Detail of IDT -->  6) Publish Bzn Layer Section 

B) What are the characteristics of BZN layer, objects, and data foundation in steps 5?

 ii)Repository rsc section, object stored in the repository will be displayed
     iii)  BZN layer shows BZN view of Analytic view
     iv) Data foundation shows table and column name.



17.  Which universe is used for Semantic Business Layer?    Relational Universe (BO)

Information Designer Tool

What is IDT used for?   
       
             -For HANA Connection











http://searchsap.techtarget.com/SAP-Business-Explorer-BEx-and-SAP-BI-reporting-basics http://dba1admin.blogspot.com/search/label/Universe%20Designer
http://www.guru99.com/sap-hana-reporting.html#3

No comments:

Post a Comment