Online Tutorials & Training Materials | STechies.com
Register Login

Business Objects and HANA Overview

|| || 0 Download

Business Objects and HANA Overview
Stechies

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

HANA Architecture Overview

SAP HANA Database and Surroundings


Reporting on HANA 1.0 SPS04 with BI 4.0*

Client and Connectivity Options - Today


 

Reporting on HANA

Open Interfaces

HANA 1.0 provides various interface reporting options

ODBO – OLE DB for OLAP
1 Microsoft-driven specification for multidimensional (cross-tab style) reporting
2 Requests are sent to the database via MDX (MultiDimensional eXpression language)

ODBC – Open DataBase Connectivity
1 Microsoft-driven specification for relational reporting
2 Database requests are made via SQL (Structured Query Language)
3 Heavily adopted in industry
4 No longer Microsoft-centric - Unix and Linux drivers exist for ODBC

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

Reporting on HANA

Open Interfaces (2)

HANA 1.0 provides various interface reporting options

BICS – BI Consumer Services
1 SAP Proprietary interface that offers advantages for OLAP access over MDX on
multidimensional reporting objects
2 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
1 Relational reporting drivers specified by the Java community. Popular on Unix platforms


 Download attached file.

You must be Logged in to download this file

Related Articles

0.0129 seconds.