1 / 60

Choosing the Right BI Tools for Management Cockpits

Learn how to evaluate and choose the best BI tools for building user-friendly management cockpits. Discover the pros and cons of SAP SEM CPM, Web Application Designer, and Visual Composer, as well as tips for maximizing usability and data analytics.

portism
Download Presentation

Choosing the Right BI Tools for Management Cockpits

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. Evaluate, choose, and use the right BI tools to build management cockpits your users will adopt Bjarne Berg MyITgroup Ltd. Deepu Sashideran MyITgroup Ltd.

  2. What We’ll Cover … Get expert advice for how to evaluate the many options SAP offers for building Web-delivered management cockpits. This session advises you how to choose the right option based on usability considerations. Determine if, when, and how you should leverage SAP SEM Corporate Performance Monitor (CPM) prebuilt Web templates to accelerate cockpit development and delivery. Identify the drawbacks of this approach, such as rigid navigation paths, and evaluate whether they could potentially hamper user adoption. Get expert advice for how to feed your CPM cockpit with disbursed data from multiple sources for more meaningful analytics. Examine the option of using custom iViews to build cockpits directly in SAP NetWeaver Portal. Find out why this may be the right choice for displaying static information, and why running interactive SAP BW reports and analytics directly from the portal may cause performance problems that frustrate users and decrease adoption of the cockpit. Discern when it makes sense to build your own management cockpits from scratch with SAP BW Web Application Designer. Obtain guidelines to maximize the usability of your cockpit — e.g., why you should not include more than seven items in one pane, and why drill-down data should never be more than two clicks away. Get a glimpse into how SAP Visual Composer can be used to create management Take home a comprehensive decision matrix for how to choose the right cockpit development method, as well as detailed examples of good and bad management cockpits

  3. What We’ll Cover … • Background and terminology • Tool options – pros and cons • SEM Corporate Performance Monitor – CPM (old name) • Web Application Designer • Visual Composer & demo • Publishing to the portal • Custom cockpits (JSP/BSP) • 3rd Party Cockpits What makes a good cockpit? • Which tool is right for me? • Wrap up

  4. What We’ll Cover … • Background and terminology • Tool options – pros and cons • SEM Corporate Performance Monitor – CPM (old name) • Web Application Designer • Visual Composer & demo • Publishing to the portal • Custom cockpits (JSP/BSP) • 3rd Party Cockpits What makes a good cockpit? • Which tool is right for me? • Wrap up

  5. What We’ll Cover … • Background and terminology • Tool options – pros and cons • SEM Corporate Performance Monitor – CPM (old name) • Web Application Designer • Visual Composer & demo • Publishing to the portal • Custom cockpits (JSP/BSP) • 3rd Party Cockpits What makes a good cockpit? • Which tool is right for me? • Wrap up

  6. Web Application Designer • Web Application Designer can be used for creating web based applications using BW query data.

  7. BW 3.X Web Application Designer • BW 3.X based Web Application Designer (WAD) provides drag and drop functionalities for creating BW Web templates. • WAD can be used for creating BW Web Applications integrating data from multiple BW queries.

  8. BW 3.X Web Application Designer • Standard Web Items are available for creating BW Web Templates with minimal coding. • Charts • Tables • Dropdown boxes • Navigation Block • Check box

  9. BW 3.X Web Application Designer • To enhance standard functionalities WAD provides ability to write custom JavaScript functions, customer specific style sheets (CSS), ABAP Classes for Table Interface and use of BSP applications. • JavaScript functions can be written in the template or can be stored in Mime Repository (SE80) and shared within multiple templates. • For example JavaScript and BSP can be used in BW Web templates to provide functionality for saving BW bookmarks to user favorites. • External HTML Editor (Dreamweaver, Home Studio etc.) can be used for formatting BW Web templates. WAD provides functionalities for downloading and uploading BW Web Templates.

  10. BW 3.X Web Application Designer • BW Web Applications can be directly published to Portal Content Catalog from WAD “Publish” menu. Portal and BI system connection should be set up for direct publishing of BW Web Applications. Please refer appendix for more information on setting up Portal connection

  11. NW 2004s Web Application Designer • New tool in BI NW 2004s for designing BI Web Applications. • Reduces the amount of custom coding required with the help of Command wizards, Auto complete and support for HTML tags.

  12. NW 2004s Web Application Designer • New features includes the following. • Web Items - Tab Pages, Button, Script Item (NW 2004s SPS7) • Drag and Drop using Analysis item • New Chart Types (Heat Map, GANTT & Milestone Trend Analysis) • Export BI Web Applications in PDF format • Command Wizard for generating Web API Commands • Integration with NW 2004s BEx Report Designer for formatted reports.

  13. NW 2004s Web Application Designer • BI Web API commands can be used for carrying out certain actions in BI Web Applications. • Export to Excel, PDF etc. • OLAP functions: Apply Filter values, remove Drilldowns. • Command Wizards guides you through the steps for creating a BI Web API command. • Commands are grouped together for easy access. • Data Provider • Web Items • Web Templates

  14. NW 2004s Web Application Designer • Command Wizard can be used for generating JavaScript code for the Script Item to use in custom dashboard applications.

  15. NW 2004s Web Application Designer • Provides the options for Personalizing BI query variables. • Ability to Bookmark the navigational state of the BI Web application. • Multidimensional analysis of BI query data. • Ability for user to create Exceptions and Conditions on BI Query data.

  16. NW 2004s Web Application Designer • BI Web Applications can be directly published to Portal Content Catalog using the “Publish” option from Web Application Designer. Portal and BI system connection should be set up as per OSS note 917950.

  17. NW 2004s Web Application Designer • Information Broadcaster can be used to Broadcast the BI Web Applications to Enterprise Portal KM folders and via Email in various format (PDF,MHTML,HTML etc.). • Information Broadcaster/Reporting Agent (BI 3.X) can be used for pre-calculating BI Web Applications for enhancing performance.

  18. What We’ll Cover … • Background and terminology • Tool options – pros and cons • SEM Corporate Performance Monitor – CPM (old name) • Web Application Designer • Visual Composer & demo • Publishing to the portal • Custom cockpits (JSP/BSP) • 3rd Party Cockpits What makes a good cockpit? • Which tool is right for me? • Wrap up

  19. NW 2004s Visual Composer • Visual Composer is a Web based modeling tool. • Visual Composer can be used for SAP EP Content development with no coding. • Can be used for integrated view of OLTP and OLAP data sources.

  20. NW 2004s Visual Composer • No coding required for creating great looking analytical applications. • Pre-built Analytic Business Packages.

  21. NW 2004s Visual Composer • Delivered as part of NW 2004s EP Usage Type (SPS8 and above). • Different options available for rendering VC output • Flash • WebDynpro (HTML) • Flash provides high-end visualization of Visual Composer Models.

  22. NW 2004s Visual Composer • Can be used for integrating data from multiple data sources, including SAP and non-SAP systems into one single model. Different options available for data access include. • BI KIT • RFC • Web Services • BI Kit allows access to the following Data Sources • SAP BI NW 2004 (3.5 SP14) and NW 2004s • JDBC • XMLA

  23. NW 2004s Visual Composer • BI Queries and Views can be used as data providers for Visual Composer models. • BI Query functionalities for Exceptions, Variables etc. can be used along with Visual Composer models. • Visual Composer design time allows access to BI history, favorites and roles.

  24. NW 2004s Visual Composer • Allows integration with BW Web Application Designer based application using the Portal Eventing Framework. • For example a filter value can be passed from the BEx Web Application using BW Web API to the Visual Composer and vice-versa.

  25. NW 2004s Visual Composer • Visual Composer Design time allows direct deployment of Visual Composer Models as iViews to Portal Content Catalog. • Visual Composer iViews can be then used in Portal Pages, Roles etc.

  26. NW 2004s Visual Composer

  27. What We’ll Cover … • Background and terminology • Tool options – pros and cons • SEM Corporate Performance Monitor – CPM (old name) • Web Application Designer • Visual Composer & demo • Publishing to the portal • Custom cockpits (JSP/BSP) • 3rd Party Cockpits What makes a good cockpit? • Which tool is right for me? • Wrap up

  28. What We’ll Cover … • Background and terminology • Tool options – pros and cons • SEM Corporate Performance Monitor – CPM (old name) • Web Application Designer • Visual Composer & demo • Publishing to the portal • Custom cockpits (JSP/BSP) • 3rd Party Cockpits What makes a good cockpit? • Which tool is right for me? • Wrap up

More Related