1 / 25

Reporting & Analysis

SAP University Alliances Version 4 Author Lorraine R. Gardiner, California State University, Chico. Reporting & Analysis. This module provides an introduction to reporting and analysis on SAP HANA. Agenda. Reporting and analysis overview Analytics on HANA.

kirk
Download Presentation

Reporting & Analysis

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. SAP University Alliances Version 4 Author Lorraine R. Gardiner, California State University, Chico Reporting & Analysis This module provides an introduction to reporting and analysis on SAP HANA.

  2. Agenda • Reporting and analysis overview • Analytics on HANA

  3. SAP BusinessObjects BI Solutions Source: Kramer, R. (September 2011). SAP Business Intelligence. Retrieved from http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/00d0a3e8-911a-2e10-468c-e88d2e58c05b?QuickLink=index&overridelayout=true&52531745110345

  4. SAP BusinessObjects BI Solution Capabilities Source: Hilgeford, I. (2011). Selecting the Right SAP BusinessObjects BI Client Product. Retrieved from http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/2046e5d7-2894-2e10-c6a0-ca59dbd72b0a?QuickLink=index&overridelayout=true

  5. Matching Solutions with Information Needs Source: Hilgeford, I. (2011). Selecting the Right SAP BusinessObjects BI Client Product. Retrieved from http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/2046e5d7-2894-2e10-c6a0-ca59dbd72b0a?QuickLink=index&overridelayout=true

  6. SAP Crystal Reports • Professionally formatted reports • Guided interactivity Source: Hilgeford, I. (2011). Selecting the Right SAP BusinessObjects BI Client Product. Retrieved from http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/2046e5d7-2894-2e10-c6a0-ca59dbd72b0a?QuickLink=index&overridelayout=true

  7. SAP Crystal Dashboards • Data visualization with interactive dashboards • Perform “what if” analysis with interactive controls Source: Hilgeford, I. (2011). Selecting the Right SAP BusinessObjects BI Client Product. Retrieved from http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/2046e5d7-2894-2e10-c6a0-ca59dbd72b0a?QuickLink=index&overridelayout=true

  8. SAP BusinessObjects Web Intelligence (WebI) • Ad hoc interactive reporting • Easy to create queries Source: Hilgeford, I. (2011). Selecting the Right SAP BusinessObjects BI Client Product. Retrieved from http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/2046e5d7-2894-2e10-c6a0-ca59dbd72b0a?QuickLink=index&overridelayout=true

  9. SAP BusinessObjects Analysis • Two versions: • Microsoft Office Excel • OLAP (web-based) • Multidimensional data analysis Source: Hilgeford, I. (2011). Selecting the Right SAP BusinessObjects BI Client Product. Retrieved from http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/2046e5d7-2894-2e10-c6a0-ca59dbd72b0a?QuickLink=index&overridelayout=true

  10. SAP BusinessObjects Explorer • Easy, self-service data exploration • Auto-generated data visualizations Source: Hilgeford, I. (2011). Selecting the Right SAP BusinessObjects BI Client Product. Retrieved from http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/2046e5d7-2894-2e10-c6a0-ca59dbd72b0a?QuickLink=index&overridelayout=true

  11. Agenda • Reporting and analysis overview • Analytics on HANA

  12. Analytic Application Options • Analytic Applications against • SAP NetWeaver BW InfoProviders • SAP BusinessObjects Universes • SAP HANA Views SAP HANA Course 1

  13. SAP HANA Data Modeling Overview Front-End Administration & Data Modeling SAP Hana Studio Reporting & Analysis SAP BusinessObjects Explorer, Crystal Dashboard Design, .Crystal Reports, etc. SAP HANA Database Views Tables Data Provisioning Trigger-Based Replication SAP LT Replication Server ETL-Based Replication SAP BusinessObjectsDataServices Source Systems ERP SCM Flatfile DWH 3rd Party

  14. SAP HANA Views for Analytic Applications • Attribute views • Represent master data (attributes,texts, hierarchies) • Provide reusable dimensions for analytic and calculation views • Analytic views • Join facts with relevant attribute dimensions • Calculation views • Address more complexrequirements than analytic views • Can include both tables and views

  15. Reporting & Analysis on SAP HANA Source: Mitra, S. (July 5, 2012). SAP HANA Appliance. DWBI Concepts. Retrieved from http://www.dwbiconcepts.com/database/28-hana/129-sap-hana-appliance.html

  16. SAP BusinessObjects Explorer on SAP HANA Source: Mitra, S. (July 5, 2012). SAP HANA Appliance. DWBI Concepts. Retrieved from http://www.dwbiconcepts.com/database/28-hana/129-sap-hana-appliance.html

  17. SAP BusinessObjects Explorer Information Space Analytic View on SAP HANA

  18. Initial Visualization (Entire Page)

  19. Initial Visualization (Left Side)

  20. Initial Visualization (Right Side)

  21. Initial Visualization (Entire Page)

  22. Subsequent Exploration (Entire Page)

  23. Subsequent Exploration (Left Side)

  24. Subsequent Exploration (Right Side)

  25. Subsequent Exploration (Entire Page)

More Related