BI4 and SAP Hana – ASUG Webcast
Patrice Le Bihan and Pierpaolo VEZZOSI of SAP provided this webcast to ASUG yesterday. Patrice did the presentation while Pierpaolo answered most of the 50 questions, which is amazing since the webcast was only 60 minutes yesterday.
Patrice provided these pre-requisites for this webcast if this is the first time you have heard of BI4 on Hana:
SAP BI on Hana tutorial – a short animation
BI Clients on HANA
Selecting the Right BI Client
Intention is to give you what you need to know before you start a project today.
Which BI clients connect to Hana? How do you select the right BI client on Hana?
BI Clients on Hana
Figure 1: Source: SAP
Figure 1 is a familiar slide. Each BI client has a purpose. SAP likes to categorize in three groups.
There is no change in the positioning in tools for #SAP Hana. Hana is a datasource for these clients. Some support multi-sources such as Web Intelligence – so you can mix data from Hana and another data source.
Hana is a fast data source, large volume of data and calculating it on the fly.
It doesn’t change the purpose or design or target of the audience.
You can calculate on the fly real-time data with those KPI’s using SAP Hana
Figure 2: Source: SAP
Figure 2 shows connectivity.
If you have these tools you can connect to Hana today; how they connect to Hana varies.
Discovery & Analysis tools connect to Hana views via JDBC or ODBC
With Dashboards & Applications, Design Studio can connect to view or tables
Dashboards can connect via a universe as well.
During the presentation Patrice had demonstrations of Analysis OLAP and Design Studio against SAP Hana.
Select the Right BI Client
How to select the right BI client – does not change
Hana makes it faster in terms of access to day
Why and how does not change.
Several questions you should ask yourself and your users before you standardize on a BI client.
Figure 3: Source: SAP
Where is the content consumed?
On the left of Figure 3 you see desktop applications, in the middle of the left you see the web browser and on the bottom left you have mobile.
If you are targeting mobile audience the options are at the bottom
If you are targeting desktop business analyst, you look at the first row as options.
Figure 4: Source: SAP
Figure 4 shows that you cannot create content from the mobile device as the mobile device doesn’t offer the experience to create a dashboard; it is more about consuming content
Figure 5: Source: SAP
Figure 5 shows product capabilities. Each of the tools is designed for a specific audience.
Highly formatted reports are for Crystal Reports. You can achieve same output with Web Intelligence but it will take longer.
Hierarchical capabilities – many tools support but will not reach true OLAP support such as Analysis or Design Studio.
Explorer and Visual Intelligence are about search and discovery.
Only Visual Intelligence can upload data to Hana. This is more of a back end function but Visual Intelligence allows the business user to upload data.
Patrice said to spend time on this slide.
Figure 6: Source: SAP
Figure 6 shows something SAP gets a lot of questions. Analysis tools are the best for hierarchy reports on the front end. Note that with Hana, Crystal, Web Intelligence and Dashboards do not support hierarchies.
Most tools support variables
Figure 7: Source: SAP
BI4 supports all revisions of Hana 1.0 as shown in Figure 7
Patrice said you will benefit from the latest as it has more capabilities.
BI4 embeds Hana JDBC so you do not need to manually install JDBC client.
Figure 8: Source: SAP
Hana SP5 offers have 3 options for authentication with #BI4 – Kerberos, SSL, direct authentication (Hana passwords are stored in Hana)
BI4 does not support SAML currently; this is being worked on
Kerberos is the only option for single sign on and external authentication; works for some tools but not all as shown in Figure 8.
Secured Connections via SSL via ODBC JDBC is supported for most but not all the tools.
For more information on Security (provided by Patrice):
More BI4 links, provided by Patrice:
Getting Started with SAP BusinessObjects BI Solutions: scn.sap.com/docs/DOC-27193
BI4 Upgrade Resources: scn.sap.com/docs/DOC-25474
How to Select the Right BI Tool for Your Environment: bit.ly/QdTP7C
SBOP BI 4.0 eLearning product tutorials: www.sap.com/LearnBI
Road Maps on SAP Service Marketplace: service.sap.com/roadmap
SAP BusinessObjects BI 4.0 Documentation: help.sap.com/bobi
Hana 1.0 Information:
SAP HANA Documentation : help.sap.com/hana
System tables and SQL reference for HANA: help.sap.com/hana/html/index.html
SAP HANA Developer Guide: help.sap.com/hana/hana_dev_en.pdf
HANA Academy Implementation Resources: www.saphana.com/community/implement
BI4 with SAP Hana (links provided by Patrice):
Best Practices for Optimal Data Models in SAP HANA and Analytics in SBO BI 4.0: bit.ly/xIKK1Y
About Web Intelligence on SAP HANA
Frequently Asked Questions: bit.ly/NQg9Tr
Best Practices document: scn.sap.com/docs/DOC-30614
About relational universes on SAP HANA
Best Practices for Relational Universes: scn.sap.com/docs/DOC-23256
Best Practices for Universe creation on SAP HANA: scn.sap.com/docs/DOC-20569
Using SAP HANA Variables with SBO BI 4.0: www.saphana.com/docs/DOC-1688
Tutorials on how to use Crystal Reports on HANA:
Using an SQL command to find Top N values: www.saphana.com/docs/DOC-2708
Using a SQL Expression: www.saphana.com/docs/DOC-2709
Creating Crystal Reports using HANA tables: www.saphana.com/docs/DOC-2430
Creating Crystal Reports using HANA views: www.saphana.com/docs/DOC-2431
Creating Crystal Reports using data generated within a Stored Procedure: www.saphana.com/docs/DOC-2432
Using Crystal Reports with SAP HANA Analytics Foundation: www.saphana.com/docs/DOC-2962
Subset of Question & Answer:
There were 50+ questions in this webcast – only a subset are shown below:
Q: How does XS development for custom front ends play with this?
A: At this moment XS is not relevant for BI4.0 tools
Q: Is there a performance difference from using BI 3.1 Universe & Webi versus BI4 UNV & Webi 4?
A: There should not be a difference but UNX in BI4.0 are evolving to encompass HANA functionality which will not be availble in XI3 UNV (e.g. automatic support of variables)
Q: Is there a place from where we could get big data files like FLIGHT DATA you have demoed etc?
The data set used during this demo is accessible to everyone from http://www.transtats.bts.gov
Direct link to download data by year/month:
Q: Is there a performance difference using a recommended client for e.g. BOBJ versus another custom JDBC
A: Performance depends on how the clients queries HANA. If the client pushes complexity down to the HANA engine, if the client retrieves the smallest quantity of data. The BOBJ tools are being optimized to take into account all these functionalities on HANA
Q: Could you speak about working with non-SAP sources which may add pieces of the data household to be regarded
A: Non-SAP data was demonstrated today – the airline – downloaded from the web – .CSV loaded to Hana
Q: UNV vs UNX usage
A: UNVs are maintained but not improved. UNX is the technology to use going forward
Link to Tweetdoc