0500 - client interfaces overview.pdf

Post on 06-Jul-2018

221 Views

Category:

Documents

0 Downloads

Preview:

Click to see full reader

TRANSCRIPT

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

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

SAP HANA

Client and Interfaces

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

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

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

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

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

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

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

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

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

SAP BusinessObjects BI 4.0

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

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

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

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

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

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

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

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

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

Microsoft Excel

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

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

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

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

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

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

SAP BusinessObjects Analysis

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

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

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

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

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

SAP BusinessObjectsExplorer 

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

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

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

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

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

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

Semantic Layer (Universe)

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

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

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

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

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

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

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

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)

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

SAP Crystal Reports 2011

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

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

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 

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

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

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

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

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+

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

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

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

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

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

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

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 - - -

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

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

Connectivity and Landscape

Considerations

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

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

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

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

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

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

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

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

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

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

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

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.

top related