Presentation Transcript

1. Session ID: Expert 114BOBJ on HANA

   Dr. Bjarne Berg
2. SAP BusinessObjects Dashboards Dashboards can be built using the SAP BusinessObjects Dashboards tool (formerly known as Xcelsius) SAP BusinessObjects Dashboards was launched in March 2010, and is the flagship product for data visualization and dashboards
3. SAP BusinessObjects Dashboards – Mobile Example Make sure layout, buttons, and colors are consistently used and that the location of the objects aligns perfectly with each other. Dashboards are most useful when compared to something This dashboard is relative to a business plan Notice that all graphs can be displayed many ways and that color coding is consistent across dashboards
4. SAP BusinessObjects Dashboard — Display and Colors Don't cram too much into single dashboards. Plan on multiple dashboards for each business area. This dashboard groups six different categories and over 30 lines into an easily readable table using a few lines and mostly colors Too many lines and incorrect use of “bold” makes dashboards very hard to read
5. Formatted Number based Dashboard Example Not all dashboards have a high degree of navigation and imaged. For finance dashboards, presenting the numbers in a meaningful way may be more important. Dashboards can also be highly formatted and static with little user interactive In this dashboard we included some KPIs and only the balance sheet for an organization, instead of using Crystal reports for this sort of work.
6. Linked to Web Services Dashboards are most useful when shared with others Power users can create great departmental dashboards that can be shared inside smaller organizational units In this dashboard, the data is merged with Google maps and external news feeds. This makes the dashboard much more interactive and interesting.
7. BI Workspaces and Modules BI Workspaces allows you to link many SAP BI tools in the same area, without the need to jump between them. In this workspace, we have 3 Dashboards, 1 WebI report, 1 Analysis report and 1 Crystal report running at the same time.
8. SAP HANA — Sources and Target Interfaces A great benefit is the real-time loading of SAP HANA from ERP. This can provide real-time analytics to end-users. SAP BusinessObjects 4.0 Semantic Layer Dashboards SQL (JDBC / ODBC) Crystal WebIntelligence HANA Appliance SQL (JDBC / ODBC) Crystal BICS Analysis - Office Sybase Replication Server In Memory Computing Engine Real-time ERP DBSQL Database Explorer Others Sybase Unwired 3rd Party Applications SQL (JDBC / ODBC) Custom Web Development 3rd Party Applications MDX (ODBO) MS-Excel (certified) BusinessObjects Data Services SAP BW 3rd Party Currently, HANA currently does not use the complete MDX set, it supports EXCEL 2010 standard MDX
9. Live SAP BI 4.0 Demo with SAP HANA
10. BI Workspaces and Modules This alleviates some of the task of opening and running the workspace every day. We can also link the objects in a workspace together and pass variables and navigation between some of them
11. Modules We can also use Modules to make the objects more interesting by adding comments to them. There are two types of Modules Text modules Compound modules You can access Modules from the ‘my application area.
12. The Text Module Using the Text Module we can add our comments and update them whenever we like. There are two options: Regular text HTML (this allows you to use HTML tags to format you text
13. The Compound Module with a Text Module Using the Compound Module we display many modules together, this include text, dashboards, WebI reports, Crystal reports, and Analysis for OLAP. Creating a compound modules are so simple, that anyone with Microsoft Word or PowerPoint skills can learn it in less than 5 minutes!!
14. What Tool to Select All SAP tools have strength and weaknesses This is a subjective summary of each of the major tools
15. Questions and Answers Join me at the free SAP HANA Event in San Fransisco on November 14th Dr. Berg Bberg@Comerit.com