0500 - client interfaces overview.pdf

80
8/17/2019 0500 - Client Interfaces Overview.pdf http://slidepdf.com/reader/full/0500-client-interfaces-overviewpdf 1/80 SAP HANA Client and Interfaces

Upload: ferryong

Post on 06-Jul-2018

221 views

Category:

Documents


0 download

TRANSCRIPT

Page 1: 0500 - Client Interfaces Overview.pdf

8/17/2019 0500 - Client Interfaces Overview.pdf

http://slidepdf.com/reader/full/0500-client-interfaces-overviewpdf 1/80

SAP HANA

Client and Interfaces

Page 2: 0500 - Client Interfaces Overview.pdf

8/17/2019 0500 - Client Interfaces Overview.pdf

http://slidepdf.com/reader/full/0500-client-interfaces-overviewpdf 2/80

© 2012 SAP AG. All rights reserved. 2

 Agenda

HANA Clients: Reporting and Connectivity

SAP BusinessObjects BI 4.0

Microsoft Excel

SAP BusinessObjects Analysis

SAP BusinessObjects Explorer 

Semantic Layer (Universe)

SAP Crystal Reports for Enterprise, Dashboards and Web Intelligence

SAP Crystal Reports 2011

Security, Authentication, User Provisioning and Authorization

Connectivity and Landscape Considerations

Page 3: 0500 - Client Interfaces Overview.pdf

8/17/2019 0500 - Client Interfaces Overview.pdf

http://slidepdf.com/reader/full/0500-client-interfaces-overviewpdf 3/80

Page 4: 0500 - Client Interfaces Overview.pdf

8/17/2019 0500 - Client Interfaces Overview.pdf

http://slidepdf.com/reader/full/0500-client-interfaces-overviewpdf 4/80

© 2012 SAP AG. All rights reserved. 4

SAP HANA Database

Session Management

ERP

 Architecture OverviewSAP HANA Database and Surroundings

LogERP DB

SAP HANA Studio

 Administration Modeling

Load

Controller 

Replication

 Agent

Persistence Layer Page Management Logger 

Disk StorageLog VolumesData Volumes

Request Processing / Execution Control

SQL Parser  MDX

SQL Script Calc Engine

Transaction

Manager 

Relational Engines

Row Store Column Store

 Authorization

Manager 

Metadata

Manager 

Replication

Server 

Other Source Systems

SAP

NetWeaver

BW3rd Party

SAP Business Objects BI4

Data

Services

Designer 

SBO BI4

servers(program)

SBO BI4

Information

Design Tool

DataServices

Clients (planned, e.g.) BI4 Explorer 

Dashboard

Design

SAP BI4 universes

(WebI,...)

MS Excel

BI4 Analysis

- Reporting components

Page 5: 0500 - Client Interfaces Overview.pdf

8/17/2019 0500 - Client Interfaces Overview.pdf

http://slidepdf.com/reader/full/0500-client-interfaces-overviewpdf 5/80

© 2012 SAP AG. All rights reserved. 5

Reporting on HANA 1.0 with BI 4.0*Client and Connectivity Options

Web

Intelligence

(4.0SP2 Patch 5)

Dashboards

(4.0SP2 Patch 5)

   E  x  c  e

   l   2   0   0   7

CR for

Enterprise

(4.0SP2 Patch 5)

Semantic Layer (universe UNX)(4.0SP2 Patch 5)

MDX

SQL

ODBO

   A  n  a

   l  y  s   i  s   O   f   f   i  c  e

   (   1 .   2

   )

BICS

   E  x  p   l  o  r  e  r

   (   4 .   0

   S   P

   2   P  a   t  c   h   5   )

JDBC JDBC ODBC

   C   R

   2   0   1   1

   (   4 .   0

   S   P   2   P  a   t  c   h   5   )

JDBC ODBC

SQL

 Are part of SBO BI 4

SQL

Outside or as part of SBO BI 4

Outside of SBO BI 4

* 4.0 GA customers and 4.0 FP3 RTC customers; For clients supported on BW on HANA scenario, refer to SAP BW 7.3 PAM

   A  n  a

   l  y  s   i  s   O   L   A   P

BICS

SAP HANA Database

* 4.0 GA customers and 4.0 FP3 RTC customers; For clients supported on BW on HANA scenario, refer to SAP BW 7.3 PAM

Page 6: 0500 - Client Interfaces Overview.pdf

8/17/2019 0500 - Client Interfaces Overview.pdf

http://slidepdf.com/reader/full/0500-client-interfaces-overviewpdf 6/80

© 2012 SAP AG. All rights reserved. 6

Reporting on HANAOpen Interfaces

HANA 1.0 provides various interface reporting options

ODBO – OLE DB for OLAP

Microsoft-driven specification for multidimensional (cross-tab style) reporting

Requests are sent to the database via MDX (MultiDimensional eXpression language)

ODBC – Open DataBase Connectivity Microsoft-driven specification for relational reporting

Database requests are made via SQL (Structured Query Language)

Heavily adopted in industry

No longer Microsoft-centric - Unix and Linux drivers exist for ODBC

JDBC – Java DataBase Connectivity Relational reporting drivers specified by the Java community. Popular on Unix platforms

Page 7: 0500 - Client Interfaces Overview.pdf

8/17/2019 0500 - Client Interfaces Overview.pdf

http://slidepdf.com/reader/full/0500-client-interfaces-overviewpdf 7/80

© 2012 SAP AG. All rights reserved. 7

Reporting on HANAOpen Interfaces (2)

HANA 1.0 provides various interface reporting options

BICS – BI Consumer Services

SAP Proprietary interface that offers advantages for OLAP access over MDX on

multidimensional reporting objects

Common driver technology used by SAP BusinessObjects Analysis, Office Edition (v 1.2)and Semantic Layer based BOBJ BI clients for connectivity to SAP NetWeaver BW

SQLDBC is SAP native database SDK

Page 8: 0500 - Client Interfaces Overview.pdf

8/17/2019 0500 - Client Interfaces Overview.pdf

http://slidepdf.com/reader/full/0500-client-interfaces-overviewpdf 8/80

SAP BusinessObjects BI 4.0

Page 9: 0500 - Client Interfaces Overview.pdf

8/17/2019 0500 - Client Interfaces Overview.pdf

http://slidepdf.com/reader/full/0500-client-interfaces-overviewpdf 9/80

© 2012 SAP AG. All rights reserved. 9

How do I

visualize data for

better decision

making?

How do I

answer ad hoc

questions and

interact withinformation?

How do I find

immediate

answers to

businessquestions?

How do I

determine trends

from complex

historical dataand possibly

make better

forecasts?

How do I access

and transform

corporate data

into highlyformatted reports

for greater

insight?

How can IT

create centrally

from simple to

complex BIapplications for a

larger audience ?

SAP BusinessObjectsBI Client Portfolio

Page 10: 0500 - Client Interfaces Overview.pdf

8/17/2019 0500 - Client Interfaces Overview.pdf

http://slidepdf.com/reader/full/0500-client-interfaces-overviewpdf 10/80

© 2012 SAP AG. All rights reserved. 10

Dashboarding & Data VisualizationSAP BusinessObjects BI4.0 Dashboard Design (Xcelsius)

Consume attractive, personalized

dashboards online or offline

 Access to personalized, Flash-based

dashboards

Secure visualizations anywhere – portal,

reports, PDF, MS Office documents

Empower business users with

interactive information

Powerful “what-if” analysis with sliders and

other controls

 Ability to drill-down into details

Pre-built components, skins, maps, charts,

gauges, and selectors

Page 11: 0500 - Client Interfaces Overview.pdf

8/17/2019 0500 - Client Interfaces Overview.pdf

http://slidepdf.com/reader/full/0500-client-interfaces-overviewpdf 11/80

© 2012 SAP AG. All rights reserved. 11

Pixel Perfect ReportingSAP Crystal Reports

Next-Generation Report Designer

Experience:

New styling with ribbon bar look and feel

Common query design experience across

all data sources with new semantic layer 

 Automated report translation for global

deployments

Page 12: 0500 - Client Interfaces Overview.pdf

8/17/2019 0500 - Client Interfaces Overview.pdf

http://slidepdf.com/reader/full/0500-client-interfaces-overviewpdf 12/80

© 2012 SAP AG. All rights reserved. 12

 Ad Hoc Query and ReportingSAP BusinessObjects BI4.0 Web Intelligence

Empower business users with powerful,

yet easy to use reporting:

Intuitive, Web-based interface with offlinecapabilities

Start from a blank slate or use an existing

report Multi-source access

Interactivity with filtering, ranking, sorting,calculations, etc.

Data lineage

Lighten IT workload:

Self-service data access and reporting

Controlled and secure access withtight BI platform integration

Intuitive, business-centric view ofinformation with universes

Page 13: 0500 - Client Interfaces Overview.pdf

8/17/2019 0500 - Client Interfaces Overview.pdf

http://slidepdf.com/reader/full/0500-client-interfaces-overviewpdf 13/80

© 2012 SAP AG. All rights reserved. 13

Data Search and ExplorationSAP BusinessObjects BI4.0 Explorer 

Bring BI to all business users

Simplicity and speed of search

Intuitive data exploration andvisualization

Fast response across

mountains of data anywhere inthe organization

 Accelerated version with in-memory technologies

Help IT to be successful

Easy and efficient to manage

and scale More reactive to business with

faster delivery

Support for heterogeneous datasources

Page 14: 0500 - Client Interfaces Overview.pdf

8/17/2019 0500 - Client Interfaces Overview.pdf

http://slidepdf.com/reader/full/0500-client-interfaces-overviewpdf 14/80

© 2012 SAP AG. All rights reserved. 14

“ The” Business Intelligence PlaceSAP BusinessObject BI 4.0 Launch Pad

Self-Service InformationConsumption

New self-service BI access making iteasier to find all available content

Enhanced filtering and search

options reducing page scrolling Enhanced navigation for working with

multiple documents at the same time

Page 15: 0500 - Client Interfaces Overview.pdf

8/17/2019 0500 - Client Interfaces Overview.pdf

http://slidepdf.com/reader/full/0500-client-interfaces-overviewpdf 15/80

© 2012 SAP AG. All rights reserved. 15

User Personalized BI WorkspaceSAP BusinessObjects BI.40 BI Workspace

Personalized InformationConsumption:

Organizing and displaying any BIcontent with decreased IT dependency

Simple WYSIWYG authoring for

creating and modifying content Inter-portlet communication enabling

information exchange betweencomponents

BI Workspace

Repor ting , Analysis Other ContentVisual

Page 16: 0500 - Client Interfaces Overview.pdf

8/17/2019 0500 - Client Interfaces Overview.pdf

http://slidepdf.com/reader/full/0500-client-interfaces-overviewpdf 16/80

Microsoft Excel

Page 17: 0500 - Client Interfaces Overview.pdf

8/17/2019 0500 - Client Interfaces Overview.pdf

http://slidepdf.com/reader/full/0500-client-interfaces-overviewpdf 17/80

© 2012 SAP AG. All rights reserved. 17

Reporting on HANA

Native Excel Interface - Pivot Tables (ODBO)

Multidimensional reporting is available via Excel Pivot Tables

This has the advantage of „quick and dirty“ cross-tab style reporting via Excel

Pivot Tables can be initiated numerous ways but primary entry point is via the

Excel DATA menu option

It is possible to enable a client trace that is useful for support analysis

The report definition is only avalable locally

Page 18: 0500 - Client Interfaces Overview.pdf

8/17/2019 0500 - Client Interfaces Overview.pdf

http://slidepdf.com/reader/full/0500-client-interfaces-overviewpdf 18/80

© 2012 SAP AG. All rights reserved. 18

Reporting on HANANative Excel Interface via ODBO (2)

For 32-bit version of MS Excel 2007/2010 install anduse the 32-bit ODBO interface

HANA ODBO drivers is available via theOther/Advanced option of the Data ConnectionWizard

Page 19: 0500 - Client Interfaces Overview.pdf

8/17/2019 0500 - Client Interfaces Overview.pdf

http://slidepdf.com/reader/full/0500-client-interfaces-overviewpdf 19/80

© 2012 SAP AG. All rights reserved. 19

Reporting on HANANative Excel Interface via ODBO (3)

You can keep the defaults OLAP server settings

 Analytic/Calculation

views (aka “Cubes”)

are available per

your authorizations

Page 20: 0500 - Client Interfaces Overview.pdf

8/17/2019 0500 - Client Interfaces Overview.pdf

http://slidepdf.com/reader/full/0500-client-interfaces-overviewpdf 20/80

© 2012 SAP AG. All rights reserved. 20

Reporting on HANANative Excel Interface – the Pivot Table

Standard Microsoft Pivot Table

interface is presented:

Check Measures, Drag and droprows/columns

Useful information on SDN forMicrosoft Office 2007:

http://www.sdn.sap.com/irj/scn/index?rid=/library/uuid/e03fef5e-d82f-2f10-8898-859c4ed57e62

Limitations for Excel 2010 could befound in SAP note 1689028

Page 21: 0500 - Client Interfaces Overview.pdf

8/17/2019 0500 - Client Interfaces Overview.pdf

http://slidepdf.com/reader/full/0500-client-interfaces-overviewpdf 21/80

SAP BusinessObjects Analysis

Page 22: 0500 - Client Interfaces Overview.pdf

8/17/2019 0500 - Client Interfaces Overview.pdf

http://slidepdf.com/reader/full/0500-client-interfaces-overviewpdf 22/80

© 2012 SAP AG. All rights reserved. 22

 Analytical Reporting on HANA 1.0 with

 Analysis Office Version 1.2*

MS Office 2007 is a 32-bit application

Install and Use the 32-bit ODBC client

Report off Analytic Views or Calculation Views

One view per crosstab

Multiple views from different HANA systems in one

workbook or sheet

Refer to User’s Guide for supported features:

http://help.sap.com/businessobject/product_guides/AMS11/en/11_aaoffice_user_sp3_en.pdf 

*Support for HANA hierarchies and variables planned for Analysis Office v1.3; support for HANA views planned for Analysis OLAP 4.0FP3

*Support for HANA hierarchies and variables planned for Analysis Office v1.3; support for HANA views planned for Analysis OLAP 4.0FP3

Page 23: 0500 - Client Interfaces Overview.pdf

8/17/2019 0500 - Client Interfaces Overview.pdf

http://slidepdf.com/reader/full/0500-client-interfaces-overviewpdf 23/80

© 2012 SAP AG. All rights reserved. 23

SAP BusinessObjects Analysis, Office Edition

 Access Analytic and Calculation Views from Analysis Office (MS Excel or

Powerpoint) via a locally defined ODBC connection

Page 24: 0500 - Client Interfaces Overview.pdf

8/17/2019 0500 - Client Interfaces Overview.pdf

http://slidepdf.com/reader/full/0500-client-interfaces-overviewpdf 24/80

© 2012 SAP AG. All rights reserved. 24

SAP BusinessObjects Analysis, Office Edition

Page 25: 0500 - Client Interfaces Overview.pdf

8/17/2019 0500 - Client Interfaces Overview.pdf

http://slidepdf.com/reader/full/0500-client-interfaces-overviewpdf 25/80

SAP BusinessObjectsExplorer 

Page 26: 0500 - Client Interfaces Overview.pdf

8/17/2019 0500 - Client Interfaces Overview.pdf

http://slidepdf.com/reader/full/0500-client-interfaces-overviewpdf 26/80

© 2012 SAP AG. All rights reserved. 26

What is BusinessObjects Explorer on SAP HANA? It’s

Search Against BI…

Use familiar key-word search to find business

information

 Answers “on-the-fly” and investigative questions

Fast search directly on data

No previous reports or metrics need exist

Data pre-indexed when accessing via a universe to

any source

No need for data pre-aggregation or indexation

when accessing to HANA

Searches across all data sources  Any universe accessible source

 Any SAP NetWeaver BW Accelerator accessible

source

 And of course any accessible HANA system

Page 27: 0500 - Client Interfaces Overview.pdf

8/17/2019 0500 - Client Interfaces Overview.pdf

http://slidepdf.com/reader/full/0500-client-interfaces-overviewpdf 27/80

© 2012 SAP AG. All rights reserved. 27

…and Then It’s Exploration Of the Results

Intuitively explore on data

No data model or data knowledge required

 Automated relevancy of results

Most relevant information is displayed first

Best chart type auto generated

Share insights with others

Export to CSV or image

Save it locally as a browser bookmark

One-click to send a link to the results by email

Page 28: 0500 - Client Interfaces Overview.pdf

8/17/2019 0500 - Client Interfaces Overview.pdf

http://slidepdf.com/reader/full/0500-client-interfaces-overviewpdf 28/80

© 2012 SAP AG. All rights reserved. 28

Explorer for HANASetup

In SAP BusinessObjects BI4.0 Central Management Console

 Advanced configuration for Explorer Application

Enable the use of HANA connections defined from Information Design Tool

http://mybiserver:8080/BOE/CMC Applications Explorer Properties on contextual menu Advanced configuration

newdb.connections.enabled = true

Page 29: 0500 - Client Interfaces Overview.pdf

8/17/2019 0500 - Client Interfaces Overview.pdf

http://slidepdf.com/reader/full/0500-client-interfaces-overviewpdf 29/80

© 2012 SAP AG. All rights reserved. 29

 Analytical Reporting on HANA 1.0Explorer 4.0

Performing Analyse

Install the JDBC driver onto BI 4 server

One-line configuration in Explorer

application:

newdb.connections.enabled=true

Can connect to multiple HANA systems

Multilingual support : specify language at

logon or based on Preferred Viewing

Locale

Delegated calculated measures

Report off Analytic Views or Calculation

Views

One view per Information Space

Connection defined in

Information Design Tool

View created in

HANA Studio

Page 30: 0500 - Client Interfaces Overview.pdf

8/17/2019 0500 - Client Interfaces Overview.pdf

http://slidepdf.com/reader/full/0500-client-interfaces-overviewpdf 30/80

Semantic Layer (Universe)

Page 31: 0500 - Client Interfaces Overview.pdf

8/17/2019 0500 - Client Interfaces Overview.pdf

http://slidepdf.com/reader/full/0500-client-interfaces-overviewpdf 31/80

© 2012 SAP AG. All rights reserved. 31

 All data sources

SAP BW OLAP Any Relational

DatabaseWeb

ServiceFilesSAP HANA Sybase

Connect to all

data sources

SAP BusinessObjects Semantic Layer 

Best access method for each specific data source

Direct Access Universe Access

High

performance,

feature rich

secure access

Empower business users with the autonomy they need to access,

analyze, enrich, and share information freely and securely using

familiar business terms

Common user experience for all front-ends

Web Intelligence Crystal Reports Dashboards Explorer 

Empower all

people, enable

all workflows

Page 32: 0500 - Client Interfaces Overview.pdf

8/17/2019 0500 - Client Interfaces Overview.pdf

http://slidepdf.com/reader/full/0500-client-interfaces-overviewpdf 32/80

© 2012 SAP AG. All rights reserved. 32

Relational Reporting on HANA 1.0 with

Semantic Layer BI 4.0 (1 of 2)

Support of HANA by the Semantic Layer via Relational Universes*

New Universe format (UNX) via a JDBC and OBDC relational connection

 Access to : Tables (row or column store) ,SQL views, Analytic and Calculation Views

New SQL features in HANA are immediately available for universes

Universes do not store data from HANA or add any performance overhead

Universes are just like any other client tool using SQL to access HANA

The latest data from HANA is sent to the client tool on query refresh

* Support for HANA variables and parameters in the semantic layer planned for 4.0 FP3

Page 33: 0500 - Client Interfaces Overview.pdf

8/17/2019 0500 - Client Interfaces Overview.pdf

http://slidepdf.com/reader/full/0500-client-interfaces-overviewpdf 33/80

© 2012 SAP AG. All rights reserved. 33

Relational Reporting on HANA 1.0 with

Semantic Layer BI 4.0 (2 of 2)

Native support of HANA relational

universes from:

WebIntelligence

Dashboards

Crystal Report for Enterprise

Explorer on a HANA universe is

supported, however not recommended:

Universe based Info Spaces create disk

based indexes on BI 4 system

Explorer can connect directly to HANAviews and work on real-time detailed data

with good performance

Page 34: 0500 - Client Interfaces Overview.pdf

8/17/2019 0500 - Client Interfaces Overview.pdf

http://slidepdf.com/reader/full/0500-client-interfaces-overviewpdf 34/80

© 2012 SAP AG. All rights reserved. 34

Information Design ToolSteps to Create an Universe

CreateNew

Project

CreateConnection

Create DataFoundation

CreateBusiness

Layer 

Publishto BI 4.0

Page 35: 0500 - Client Interfaces Overview.pdf

8/17/2019 0500 - Client Interfaces Overview.pdf

http://slidepdf.com/reader/full/0500-client-interfaces-overviewpdf 35/80

© 2012 SAP AG. All rights reserved. 35

Project can be shared for collaborative authoring of universe

Information Design ToolCreate a Local Project

Page 36: 0500 - Client Interfaces Overview.pdf

8/17/2019 0500 - Client Interfaces Overview.pdf

http://slidepdf.com/reader/full/0500-client-interfaces-overviewpdf 36/80

© 2012 SAP AG. All rights reserved. 36

Information Design ToolCreate a Connection

 A connection defines :

Which driver to use

Connection details to SAP

HANA server (hostname and

port number)

How authentication to SAPHANA will be done

Other tuning parameters for

database connections to SAP

HANA

Page 37: 0500 - Client Interfaces Overview.pdf

8/17/2019 0500 - Client Interfaces Overview.pdf

http://slidepdf.com/reader/full/0500-client-interfaces-overviewpdf 37/80

© 2012 SAP AG. All rights reserved. 37

Information Design ToolDriver Selection

Use JDBC or ODBC Driver 

The driver must be installed on the

client machine where Information

Design Tool is running and BI 4.0

server 

JDBC driver is installed in the folder :<install_folder>\dataAccess\connectionS

erver\jdbc\drivers\newdb

Page 38: 0500 - Client Interfaces Overview.pdf

8/17/2019 0500 - Client Interfaces Overview.pdf

http://slidepdf.com/reader/full/0500-client-interfaces-overviewpdf 38/80

© 2012 SAP AG. All rights reserved. 38

Information Design ToolConnection Details

Define Parameters:

 Authentication Mode

User Name

Password

Server hostname and port

number as:

<hostname>:<port>

where <port> is the port number

(3xx15 where xx is the instance

number)

Page 39: 0500 - Client Interfaces Overview.pdf

8/17/2019 0500 - Client Interfaces Overview.pdf

http://slidepdf.com/reader/full/0500-client-interfaces-overviewpdf 39/80

© 2012 SAP AG. All rights reserved. 39

Information Design ToolConnection Details

 Additional tuning parameters can be defined for database connections to SAP

HANA

Note: recommended to select the “Disconnect after each transaction” and set array

fetch size to 1000

Page 40: 0500 - Client Interfaces Overview.pdf

8/17/2019 0500 - Client Interfaces Overview.pdf

http://slidepdf.com/reader/full/0500-client-interfaces-overviewpdf 40/80

© 2012 SAP AG. All rights reserved. 40

Information Design ToolCreate Data Foundation

 A Data Foundation

Can be single or multi source

Each source is defined by a connection (defined in previous slides)

Maps tables and views the universe will be based on

Defines joins, reporting contexts

Optionally defines level list of values and parameters based on table fields

Page 41: 0500 - Client Interfaces Overview.pdf

8/17/2019 0500 - Client Interfaces Overview.pdf

http://slidepdf.com/reader/full/0500-client-interfaces-overviewpdf 41/80

© 2012 SAP AG. All rights reserved. 41

Information Design ToolCreate Data Foundation

Select “Single Source” if HANA is the unique data source for the reporting needs

Select “Multisource-Enabled” if data from HANA must be combined with other

sources

For performance reasons, prefer the single source technology to the multi-source one

Select a connection object for each data source

Page 42: 0500 - Client Interfaces Overview.pdf

8/17/2019 0500 - Client Interfaces Overview.pdf

http://slidepdf.com/reader/full/0500-client-interfaces-overviewpdf 42/80

© 2012 SAP AG. All rights reserved. 42

Information Design ToolDesign Data Foundation

The universe allows relational reporting on HANA

 Attribute, Analytic and Calculation Views can be accessed in a relational (SQL)

manner by using Column Views from the _SYS_BIC schema

Data Foundation will list a table catalog the user has access to Tables and Views from a schema

Column Views from the _SYS_BIC schema

Page 43: 0500 - Client Interfaces Overview.pdf

8/17/2019 0500 - Client Interfaces Overview.pdf

http://slidepdf.com/reader/full/0500-client-interfaces-overviewpdf 43/80

© 2012 SAP AG. All rights reserved. 43

Information Design ToolCreate Business Layer 

Business Layer is where the semantic is defined on top of the Data Foundation:

Dimensions and measures are defined

Data Model is enriched Hierarchies, Prompts, Security, etc

Page 44: 0500 - Client Interfaces Overview.pdf

8/17/2019 0500 - Client Interfaces Overview.pdf

http://slidepdf.com/reader/full/0500-client-interfaces-overviewpdf 44/80

© 2012 SAP AG. All rights reserved. 44

Information Design ToolDefine Objects and Test Queries

Dimensions, Measures and Aggregation functions are defined

Test queries can be created to validate the objects definition

Page 45: 0500 - Client Interfaces Overview.pdf

8/17/2019 0500 - Client Interfaces Overview.pdf

http://slidepdf.com/reader/full/0500-client-interfaces-overviewpdf 45/80

© 2012 SAP AG. All rights reserved. 45

SAP BusinessObjects BI4.0Publish the Connection and Business Layer 

Publish the connection and the business layer to the BI 4.0 repository

The universe can now be consumed by client tools such WebIntelligence,

Dashboards or Crystal Report for Enterprise

Page 46: 0500 - Client Interfaces Overview.pdf

8/17/2019 0500 - Client Interfaces Overview.pdf

http://slidepdf.com/reader/full/0500-client-interfaces-overviewpdf 46/80

SAP Crystal Reports for

Enterprise, Dashboards and

Web Intelligence

Page 47: 0500 - Client Interfaces Overview.pdf

8/17/2019 0500 - Client Interfaces Overview.pdf

http://slidepdf.com/reader/full/0500-client-interfaces-overviewpdf 47/80

© 2012 SAP AG. All rights reserved. 47

Relational Universe on HANA

 A relational universe is the starting point

BI clients will build queries from the Query Panel against this universe

it will appear like any other relational universe

Page 48: 0500 - Client Interfaces Overview.pdf

8/17/2019 0500 - Client Interfaces Overview.pdf

http://slidepdf.com/reader/full/0500-client-interfaces-overviewpdf 48/80

© 2012 SAP AG. All rights reserved. 48

Dashboards 4.0

Universe Queries

Page 49: 0500 - Client Interfaces Overview.pdf

8/17/2019 0500 - Client Interfaces Overview.pdf

http://slidepdf.com/reader/full/0500-client-interfaces-overviewpdf 49/80

© 2012 SAP AG. All rights reserved. 49

Dashboards 4.0

Universe Queries

Page 50: 0500 - Client Interfaces Overview.pdf

8/17/2019 0500 - Client Interfaces Overview.pdf

http://slidepdf.com/reader/full/0500-client-interfaces-overviewpdf 50/80

© 2012 SAP AG. All rights reserved. 50

Crystal Reports for Enterprise 4.0

Page 51: 0500 - Client Interfaces Overview.pdf

8/17/2019 0500 - Client Interfaces Overview.pdf

http://slidepdf.com/reader/full/0500-client-interfaces-overviewpdf 51/80

© 2012 SAP AG. All rights reserved. 51

Web Intelligence

Page 52: 0500 - Client Interfaces Overview.pdf

8/17/2019 0500 - Client Interfaces Overview.pdf

http://slidepdf.com/reader/full/0500-client-interfaces-overviewpdf 52/80

SAP Crystal Reports 2011

Page 53: 0500 - Client Interfaces Overview.pdf

8/17/2019 0500 - Client Interfaces Overview.pdf

http://slidepdf.com/reader/full/0500-client-interfaces-overviewpdf 53/80

© 2012 SAP AG. All rights reserved. 53

Crystal Reports 2011

Crystal Reports 2011 (CR2011) can report off SAP HANA in a relational manner 

(SQL) via the ODBC or JDBC driver 

Client drivers must be installer on the machine where CR2011 is running

Requirements and steps for ODBC reporting:

CR2011 is a 32-bit application, therefore uses the 32-bit ODBC driver for SAP HANA DB  A DSN entry must be entered from the ODBC 32-bit Administrator tool

Page 54: 0500 - Client Interfaces Overview.pdf

8/17/2019 0500 - Client Interfaces Overview.pdf

http://slidepdf.com/reader/full/0500-client-interfaces-overviewpdf 54/80

© 2012 SAP AG. All rights reserved. 54

Crystal Reports 2011ODBC Reporting

Page 55: 0500 - Client Interfaces Overview.pdf

8/17/2019 0500 - Client Interfaces Overview.pdf

http://slidepdf.com/reader/full/0500-client-interfaces-overviewpdf 55/80

© 2012 SAP AG. All rights reserved. 55

Crystal Reports 2011Configuring CRConfig.xml File for JDBC

Full documentation for JDBC connections:

http://www.sdn.sap.com/irj/boc/index?rid=/library/uuid/e0d98a3c-6764-2b10-e4b7-

d55e0178eedb&overridelayout=true

Main configuration is done from CRConfig.xml

Default location is C:\Program Files (x86)\SAP BusinessObjects\SAP BusinessObjects

Enterprise XI 4.0\java

<ClassPath> must point to the ngdbc.jar file (HANA JDBC driver): default path on Windows

is C:\Program Files\sap\hdbclient\ngdbc.jar 

<JDBCURL> is:  jdbc:sap: //<SAPHANADB_host>:<SAPHANADB_port> where

SAPHANADB_port is 3xx15 and xx the instance number 

<JDBCClassName> parameter: com.sap.db.jdbc.Driver 

Page 56: 0500 - Client Interfaces Overview.pdf

8/17/2019 0500 - Client Interfaces Overview.pdf

http://slidepdf.com/reader/full/0500-client-interfaces-overviewpdf 56/80

© 2012 SAP AG. All rights reserved. 56

Crystal Reports 2011

From the Database Expert, select JDBC(JNDI) under Create New Connections

Connection parameters filled in from CRConfig.xml entries

Database field is the SID, then Username / Password

Page 57: 0500 - Client Interfaces Overview.pdf

8/17/2019 0500 - Client Interfaces Overview.pdf

http://slidepdf.com/reader/full/0500-client-interfaces-overviewpdf 57/80

© 2012 SAP AG. All rights reserved. 57

Crystal Reports 2011Database Catalog

SAP HANA appears as a Catalog like any other relational database

Tables and Views can then be selected from the Catalog for reporting*

* Support fo r HANA vi ews planned for 4.0 FP3

Page 58: 0500 - Client Interfaces Overview.pdf

8/17/2019 0500 - Client Interfaces Overview.pdf

http://slidepdf.com/reader/full/0500-client-interfaces-overviewpdf 58/80

© 2012 SAP AG. All rights reserved. 58

Crystal Reports 2011Building the Report

Begin Report Design

Page 59: 0500 - Client Interfaces Overview.pdf

8/17/2019 0500 - Client Interfaces Overview.pdf

http://slidepdf.com/reader/full/0500-client-interfaces-overviewpdf 59/80

Security, Authentication,

User Provisioning and

 Authorization

Page 60: 0500 - Client Interfaces Overview.pdf

8/17/2019 0500 - Client Interfaces Overview.pdf

http://slidepdf.com/reader/full/0500-client-interfaces-overviewpdf 60/80

© 2012 SAP AG. All rights reserved. 60

Security : Authentication

HANA 1.0 Users support two types of

authentication

Internal (direct) Authentication

User ID and Password are stored in HANA

Database

Password is checked by HANA Database

External (delegated) Authentication*

User ID is stored in HANA and mapped to an

External User ID stored in a central directory

(Windows Active Directory or LDAP)

External User ID and Password are checkedby the directory via Kerberos, then Internal

User ID is used by HANA to enforce

privileges

*Valid from BI 4.0 FP3+

Page 61: 0500 - Client Interfaces Overview.pdf

8/17/2019 0500 - Client Interfaces Overview.pdf

http://slidepdf.com/reader/full/0500-client-interfaces-overviewpdf 61/80

© 2012 SAP AG. All rights reserved. 61

Security : AuthenticationExcel and Analysis Office

 Authentication from Microsoft Excel 2007 (PivotTable) to HANA supports

both Direct and Kerberos Delegated Authentication

 Authentication f rom SAP BusinessObjects Analysis Office 1.2 supports both

Direct and Kerberos Delegated Authentication

Page 62: 0500 - Client Interfaces Overview.pdf

8/17/2019 0500 - Client Interfaces Overview.pdf

http://slidepdf.com/reader/full/0500-client-interfaces-overviewpdf 62/80

© 2012 SAP AG. All rights reserved. 62

Security : AuthenticationBI 4.0 and HANA 1.0

 Authentication from BI 4.0 supports

Direct Authentication

Credentials are defined in the

Connection object from Information

Design Tool

“Use specified username and password” if

all users share the same data access

restrictions

“Use BusinessObjects credential mapping”

if you need user-specific restrictions

Page 63: 0500 - Client Interfaces Overview.pdf

8/17/2019 0500 - Client Interfaces Overview.pdf

http://slidepdf.com/reader/full/0500-client-interfaces-overviewpdf 63/80

© 2012 SAP AG. All rights reserved. 63

Security : AuthenticationBI 4.0 and HANA 1.0

BusinessObjects Credentials Mapping:

Each individual BI 4 user is assigned

HANA database credentials

This can be done from the CMC or

programmatically with the BOE SDK

BI 4 User ID

BI User

password

HANA Database

User ID

HANA Database

User Password

DB credentials

option is

checked

(CMC -> Users and Groups -> UserID -> Properties)

S

Page 64: 0500 - Client Interfaces Overview.pdf

8/17/2019 0500 - Client Interfaces Overview.pdf

http://slidepdf.com/reader/full/0500-client-interfaces-overviewpdf 64/80

© 2012 SAP AG. All rights reserved. 64

Security : AuthenticationBI 4.0 FP3 and HANA 1.0

BI 4.0 FP3 introduces support for Kerberos delegation with HANA to perform SSO

This is available when BOE is running on Windows, and now also on Suse Linux

On Linux, in the LDAP security plugin, a new option is available on linux which will allow

user to perform LDAP authentication to BOE, pointing at an Active Directory source and

delegate the kerberos ticket to the client performing the database connection.

If Active Directory is used in the HANA + BI 4.0 FP3 environment, storing credentials is nolonger recommended, and Kerberos SSO is the preferred method.

S it U P i i i

Page 65: 0500 - Client Interfaces Overview.pdf

8/17/2019 0500 - Client Interfaces Overview.pdf

http://slidepdf.com/reader/full/0500-client-interfaces-overviewpdf 65/80

© 2012 SAP AG. All rights reserved. 65

Security : User ProvisioningHANA 1.0

Two methods for User Provisioning in HANA 1.0

Manual creation of roles and users from HANA Studio

Programmatic creation of roles and users with SQL statements

CREATE ROLE <role_name>;

GRANT SELECT ON SCHEMA _SYS_BIC TO <role_name>;

GRANT SELECT ON <schema>.<table_1> TO <role_name> WITH GRANT OPTION;

CREATE USER <user_name> IDENTIFIED BY <password>;

GRANT <role_name> TO <user_name>;

S it U P i i i

Page 66: 0500 - Client Interfaces Overview.pdf

8/17/2019 0500 - Client Interfaces Overview.pdf

http://slidepdf.com/reader/full/0500-client-interfaces-overviewpdf 66/80

© 2012 SAP AG. All rights reserved. 66

Security : User ProvisioningBI 4.0 and HANA 1.0

 All existing User and Group Provisioning methods with BOE / BI 4 remain valid.

Example: you can provision Users and Groups from Windows AD with the traditional

WinAD configuration options from the CMCThird level

Database Credentials Mapping in BI 4 can be

done from the CMC or programmatically (*).

(*) Use these methods of the BOE SDK:IUser.setProfileString(“DBUSER”, HANA_user_ID);

IUser.addSecondaryCredential(“DBPASS”,

HANA_user_pwd);

Important!

If BI 4.0 FP3 is configured with WinAD, makesure the option “Synchronization of

Credentials” is unchecked to avoid the

credentials mapping being overwritten

Ensure this option

is unchecked topreserve HANA

credentials

mapping

S it A th i ti

Page 67: 0500 - Client Interfaces Overview.pdf

8/17/2019 0500 - Client Interfaces Overview.pdf

http://slidepdf.com/reader/full/0500-client-interfaces-overviewpdf 67/80

© 2012 SAP AG. All rights reserved. 67

Security : AuthorizationWhat can you Secure Where ?

Item to securein HANA 1.0

SP04

in the Universe

(Semantic Layer)in BI 4.0

Database schema - -

Table - -

Database (SQL) view - -

 Attribute view - -

 Analytic view - -

Calculation view - -

Data in a table (column values) - -

Data in an attribute view (dimension

values) but not recommended-

Connection to HANA - -Universe, report, Dashboard, Explorer

information space, etc- -

Excel worksheet with Analysis Office - -

Excel worksheet with PivotTable - - -

Page 68: 0500 - Client Interfaces Overview.pdf

8/17/2019 0500 - Client Interfaces Overview.pdf

http://slidepdf.com/reader/full/0500-client-interfaces-overviewpdf 68/80

Connectivity and Landscape

Considerations

Page 69: 0500 - Client Interfaces Overview.pdf

8/17/2019 0500 - Client Interfaces Overview.pdf

http://slidepdf.com/reader/full/0500-client-interfaces-overviewpdf 69/80

© 2012 SAP AG. All rights reserved. 69

SAP HANA Client Installation

HDB Client package is available from Service Market Place

Two flavors : 32-bit and 64-bit

Install and use 32-bit for 32-bit applications (e.g. Office 2007, Crystal Reports 2011)

SAP HANA DB Cli t I t ll ti

Page 70: 0500 - Client Interfaces Overview.pdf

8/17/2019 0500 - Client Interfaces Overview.pdf

http://slidepdf.com/reader/full/0500-client-interfaces-overviewpdf 70/80

© 2012 SAP AG. All rights reserved. 70

SAP HANA DB Client InstallationODBC/ODBO

Can be installed at the command line from

the Studio/Modeler DVD

Command line: hdbinst –a client

Reporting on HANA

Page 71: 0500 - Client Interfaces Overview.pdf

8/17/2019 0500 - Client Interfaces Overview.pdf

http://slidepdf.com/reader/full/0500-client-interfaces-overviewpdf 71/80

© 2012 SAP AG. All rights reserved. 71

Reporting on HANAODBC Access

Standard ODBC DSNs is the foundation of reporting

Driver appears as HDBODBC or HDBODBC32

depending on your platform

On 64bit platforms the 32-bit ODBC Administrator is

accessed from C:\Windows\SysWow64\ODBCAD32.exe

Note that in early testing, Excel was *not* a good

choice for ODBC-based reporting since ODBC

reporting is based on MSQuery and MSQuery has a

limitation of 4,000 tables

Early testing was done with SAP IDES data

so >4,000 tables imported to HANA

http://support.microsoft.com/kb/115090/en-us

Reporting on HANA

Page 72: 0500 - Client Interfaces Overview.pdf

8/17/2019 0500 - Client Interfaces Overview.pdf

http://slidepdf.com/reader/full/0500-client-interfaces-overviewpdf 72/80

© 2012 SAP AG. All rights reserved. 72

Reporting on HANAODBC Access

The DSN entry should be defined as follows:

Server: <HDB_hostname>:<HDB_port> where <HDB_port> follows the pattern 3xx15 and

xx is the instance number 

Database: HDB SID

Page 73: 0500 - Client Interfaces Overview.pdf

8/17/2019 0500 - Client Interfaces Overview.pdf

http://slidepdf.com/reader/full/0500-client-interfaces-overviewpdf 73/80

© 2012 SAP AG. All rights reserved. 73

JDBC Tracing

To trace the Java connection:

Enter command Line interface (Start -> Run -> cmd.exe on most Win platforms)

Confirm java.exe is in path (run “java –version” from command line)

Change to folder containing ngdb.jar file (installed with HDB Client installer)

Type “ java –jar ngdbc.jar ” on the command line:

JDBC Tracing

Page 74: 0500 - Client Interfaces Overview.pdf

8/17/2019 0500 - Client Interfaces Overview.pdf

http://slidepdf.com/reader/full/0500-client-interfaces-overviewpdf 74/80

© 2012 SAP AG. All rights reserved. 74

JDBC TracingStart Application from Command Line

Now, start the application to be traced

From the same command line, start your application.

Tracing begins when Java interface is first activated

Example (your environment might vary slightly): C:\Program Files (x86)\SAP

BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\win32_x86\crw32.exe

NOTE: TRACING STAYS ON UNTIL YOU EXIT THE APPLICATION. The trace file may get

large

JDBC Tracing

Page 75: 0500 - Client Interfaces Overview.pdf

8/17/2019 0500 - Client Interfaces Overview.pdf

http://slidepdf.com/reader/full/0500-client-interfaces-overviewpdf 75/80

© 2012 SAP AG. All rights reserved. 75

JDBC TracingConfigure Trace File

This forces a popup to define trace file settings:

Select Trace Enabled

Change the folder to a valid path on your machine (make sure it‘s writeable to your user)

Trace file name: trace file results file

Landscape Considerations

Page 76: 0500 - Client Interfaces Overview.pdf

8/17/2019 0500 - Client Interfaces Overview.pdf

http://slidepdf.com/reader/full/0500-client-interfaces-overviewpdf 76/80

© 2012 SAP AG. All rights reserved. 76

Landscape ConsiderationsBI 4.0 and HANA 1.0

Hardware and licenses

BI 4.0 is *not* on the HANA 1.0 appliance

It requires extra hardware and extra licenses

Installation and configuration by Hardware vendors and partners

HANA 1.0 is prepared and installed by hardware vendors and partners

Installation and configuration by SAP (or other) consulting

BI 4.0 installation and configuration

HANA 1.0 configuration and data modeling

Important: the HANA JDBC driver has to be manually copied and updated onto the

BI 4.0 system

Landscape Considerations

Page 77: 0500 - Client Interfaces Overview.pdf

8/17/2019 0500 - Client Interfaces Overview.pdf

http://slidepdf.com/reader/full/0500-client-interfaces-overviewpdf 77/80

© 2012 SAP AG. All rights reserved. 77

Landscape ConsiderationsBI 4.0 and HANA 1.0

One BI 4 system can access multiple HANA 1.0 systems

Database credentials have to match

Page 78: 0500 - Client Interfaces Overview.pdf

8/17/2019 0500 - Client Interfaces Overview.pdf

http://slidepdf.com/reader/full/0500-client-interfaces-overviewpdf 78/80

© 2012 SAP AG. All rights reserved. 78

Summary

 After completing this lesson, you should be able to:

Explain connectivity options for reporting on top of Hana

Give an overview of the BusinessObjects BI4.0 platform and reporting possibilities

Set up connectivity to Hana system for reporting

Page 79: 0500 - Client Interfaces Overview.pdf

8/17/2019 0500 - Client Interfaces Overview.pdf

http://slidepdf.com/reader/full/0500-client-interfaces-overviewpdf 79/80

© 2012 SAP AG. All rights reserved. 79

 Additional Information

BOPedia Collaboration Workspace for HANA:

https://cw.sdn.sap.com/cw/community/bobjtc/hana

HANA Public Documentation:

http://help.sap.com/hana

Best practices to build a Universe on SAP HANA:

https://cw.sdn.sap.com/cw/docs/DOC-146086

Page 80: 0500 - Client Interfaces Overview.pdf

8/17/2019 0500 - Client Interfaces Overview.pdf

http://slidepdf.com/reader/full/0500-client-interfaces-overviewpdf 80/80

© 2012 SAP AG. All rights reserved.

No part of this publication may be reproduced or transmitted in any form or for any purpose

without the express permission of SAP AG. The information contained herein may be

changed without prior notice.

Some software products marketed by SAP AG and its distributors contain proprietary

software components of other software vendors.

Microsoft, Windows, Excel, Outlook, PowerPoint, Silverlight, and Visual Studio are

registered trademarks of Microsoft Corporation.

IBM, DB2, DB2 Universal Database, System i, System i5, System p, System p5, System x,

System z, System z10, z10, z/VM, z/OS, OS/390, zEnterprise, PowerVM, Power

 Architecture, Power Systems, POWER7, POWER6+, POWER6, POWER, PowerHA,

pureScale, PowerPC, BladeCenter, System Storage, Storwize, XIV, GPFS, HACMP,

RETAIN, DB2 Connect, RACF, Redbooks, OS/2, AIX, Intelligent Miner, WebSphere, Tivoli,

Informix, and Smarter Planet are trademarks or registered trademarks of IBM Corporation.

Linux is the registered trademark of Linus Torvalds in the United States and other countries.

 Adobe, the Adobe logo, Acrobat, PostScript, and Reader are trademarks or registered

trademarks of Adobe Systems Incorporated in the United States and other countries.

Oracle and Java are registered trademarks of Oracle and its affiliates.

UNIX, X/Open, OSF/1, and Motif are registered trademarks of the Open Group.

Citrix, ICA, Program Neighborhood, MetaFrame, WinFrame, VideoFrame, and MultiWin

are trademarks or registered trademarks of Citrix Systems Inc.

HTML, XML, XHTML, and W3C are trademarks or registered trademarks of W3C®,World Wide Web Consortium, Massachusetts Institute of Technology.

 Apple, App Store, iBooks, iPad, iPhone, iPhoto, iPod, iTunes, Multi-Touch, Objective-C,

Retina, Safari, Siri, and Xcode are trademarks or registered trademarks of Apple Inc.

IOS is a registered trademark of Cisco Systems Inc.

RIM, BlackBerry, BBM, BlackBerry Curve, BlackBerry Bold, BlackBerry Pearl, BlackBerry

Torch, BlackBerry Storm, BlackBerry Storm2, BlackBerry PlayBook, and BlackBerry App

World are trademarks or registered trademarks of Research in Motion Limited.

Google App Engine, Google Apps, Google Checkout, Google Data API, Google Maps,

Google Mobile Ads, Google Mobile Updater, Google Mobile, Google Store, Google Sync,

Google Updater, Google Voice, Google Mail, Gmail, YouTube, Dalvik and Android are

trademarks or registered trademarks of Google Inc.

INTERMEC is a registered trademark of Intermec Technologies Corporation.

Wi-Fi is a registered trademark of Wi-Fi Alliance.

Bluetooth is a registered trademark of Bluetooth SIG Inc.

Motorola is a registered trademark of Motorola Trademark Holdings LLC.

Computop is a registered trademark of Computop Wirtschaftsinformatik GmbH.

SAP, R/3, SAP NetWeaver, Duet, PartnerEdge, ByDesign, SAP BusinessObjects Explorer,StreamWork, SAP HANA, and other SAP products and services mentioned herein as well

as their respective logos are trademarks or registered trademarks of SAP AG in Germany

and other countries.

Business Objects and the Business Objects logo, BusinessObjects, Crystal Reports, Crystal

Decisions, Web Intelligence, Xcelsius, and other Business Objects products and services

mentioned herein as well as their respective logos are trademarks or registered trademarks

of Business Objects Software Ltd. Business Objects is an SAP company.

Sybase and Adaptive Server, iAnywhere, Sybase 365, SQL Anywhere, and other Sybase

products and services mentioned herein as well as their respective logos are trademarks or

registered trademarks of Sybase Inc. Sybase is an SAP company.

Crossgate, m@gic EDDY, B2B 360° , and B2B 360° Services are registered trademarksof Crossgate AG in Germany and other countries. Crossgate is an SAP company.

 All other product and service names mentioned are the trademarks of their respective

companies. Data contained in this document serves informational purposes only. National

product specifications may vary.

The information in this document is proprietary to SAP. No part of this document may be

reproduced, copied, or transmitted in any form or for any purpose without the express prior

written permission of SAP AG.