Rapid dashboard development with SAP NetWeaver Visual Composer

1. Rapid dashboard development with SAP NetWeaver Visual Composer Dr. Berg Comerit

2. In This Session ... You will learn all the essentials on how to build and deploy SAP NetWeaver® Visual Composer models as non-composite environment (CE) models. We will take a quick overview of the 7.0 environment followed by a step-by-step model build example We will see a detailed demo of simple techniques and good design principles for building reports with SAP NetWeaver Visual Composer We will peak and new 7.3 features and upgrade alternatives. Finally, we will look at performance tuning options and the future of SAP NetWeaver Visual Composer in the new SAP BusinessObjects landscape

3. What We’ll Cover … • SAP NetWeaver Visual Composer overview • Building an SAP NetWeaver Visual Composer model • Demo – A complete cockpit from scratch • Improving performance tuning • Upgrading SAP NetWeaver Visual Composer 7.0 to version 7.3 Looking at other options • Wrap-up

4. The SAP NetWeaver BI Traditional Toolset SAP BI is an enterprise-wide comprehensive decision support system (DSS) for the analytical needs of an enterprise BI can also support some degree of operational reporting The SAP BI tool set has many traditional presentation tools and options for companies to leverage. We are not looking at BOBJ tools at this stage.

5. There are Two 'versions' of Visual Composer (VC) Visual Composer 7.0 is for SAP BI Development, 7.1 and higher is for the Composite Environment (CE). We now have version 7.3 There are different SDN forums and blogs for each - This can be confusing! 4

6. Visual Composer for Dashboards A Visual Composer is a tool to visualize the data. It is a browser-based modeling and design tool for rapid application development & prototyping in a code-free development environment.

7. Visual Composer for Complex Dashboards Modeling of BI applications using Visual Composer allows users to create analytical content. It integrates with infoproviders, views, BEx web applications, Xelsisus, PDF, APIs, and access to OLAP and relational data sources

8. Visual Composer is Easy to Learn Visual Composer is a power user tool that is simple to learn for someone with a little bit of technical background i.e. controllers, report writers and analysts. No coding is required to create good-looking Web-based cockpits Image source: SAP designguild

9. Visual Composer Some Graphic Examples

10. For SAP BW - It All Starts with a Query The BEx Query Designer The query is the core method for accessing BI data. You can use existing queries in your SAP NetWeaver Visual Composer models

11. SAP NetWeaver Visual Composer Data Methods Can integrate data from multiple data sources, including SAP and non-SAP systems, into one model Different options available for data access include: BI Extension Kit Remote Function Call (RFC) Web services BI Extension Kit allows access to the following DataSources SAP NetWeaver BW 7.0 and 7.3 SAP NetWeaver BI 2004 (SAP BW 3.5 Support Package 14) JDBC XMLA

12. Visual Composer Data Providers You can use BI queries and views as Data Providers for SAP NetWeaver Visual Composer models You also can use BI query functionalities for exceptions and variables along with SAP NetWeaver Visual Composer models • SAP NetWeaver Visual Composer allows access to BI history, favorites, and roles

13. SAP NetWeaver Visual Composer 7.0 & 7.3 - Portal Publishing SAP NetWeaver Visual Composer 7.0 design-time deploys models directly as iViews to the Portal Content Catalog. You can then use the iViews in portal pages, roles, etc. In VC 7.3 you can either use portal modeling as a tool, or publish to the Generic Portal Application Layer (GPAL). Any iViews, pages and portal objects are created using the GPAL which exposes applications and portlets deployed to AS Java.

14. SAP NetWeaver Visual Composer 7.0 Using BOBJ Xcelsius SAP NetWeaver Visual Composer 7.01 (or 7.02) SP5 or higher allows you to use existing Xcelsius UI controls and use them inside Visual Composer. You can also use any Flex component made by Adobe Flex Builder (Flex 2 SDK). You can download flash objects & 'how-to' on sdn.sap.com (by Sap's Amir Mimran) 13

15. Details about Visual Composer Cockpits • Delivered as part of SAP NetWeaver Portal in SAP NetWeaver BW 7.0 Usage Type (SP8 and higher) • Different options available for rendering SAP NetWeaver VC output • Flash – primarily used in version 7.0 • Web DynPro (HTML) – primarily used in version 7.3 • Flash provides high-end visualization of SAP NetWeaver VC models You can pick your own rendering method in the menu: Tools  Options

16. There Are Many Resources at the SDN Community This is a great site for quickly getting started with SAP NetWeaver Visual Composer and for down loading a free demo-version

17. SAP NetWeaver Visual Composer — And the SAP Community Network Many of the beginner questions have already been answered in the expert forums on the SAP Community Network

18. SAP NetWeaver Visual Composer — SDN Community Blogs You can also learn from others’ experiences by getting “plugged-in” to the community network blogs dedicated to SAP NetWeaver Visual Composer

19. What We’ll Cover … • SAP NetWeaver Visual Composer overview • Building an SAP NetWeaver Visual Composer model • Demo – A complete cockpit from scratch • Improving performance tuning • Upgrading SAP NetWeaver Visual Composer 7.0 to version 7.3 • Looking at other options • Wrap-up

20. Downloading and Getting Started — The Trial Version You can download a CE trial version on the SAP Community Network However, to put it into production you must work with your SAP account executive for a license. It is normally not covered by a general SAP license.

21. Creating a Model The first task is to create an overall model to store all your pages and iViews The name cannot have blanks or special characters You can organize your model in standard folder structures Remember that this is a power user task, so providing the group with some formal training (4-6 hrs) would be beneficial. Also, teach them your naming conventions.

22. The SAP NetWeaver Visual Composer Add-Ons The models are actually graphics rendered with Adobe SVG (vector graphics) If you don’t have Adobe SVG installed, you must go to their Web site and download it. It is a small file and it is free.

23. The Work Environment — Getting Connected First you must make sure that your SAP NetWeaver VC environment is set up with connection back to your SAP environment(s). You can also work with your technical team to set up connections to other non-SAP environments.

24. The SAP NetWeaver Visual Composer Configure Toolbar We can add items and see then from the highest level, or you can “drill down” on each item and configure them individually Navigation is provided as a toolbar and you can also zoom in on each item This tool bar allows you to zoom, access layers, insert grid lines for layout, and move objects.

25. The Magnifying Glass SAP NetWeaver Visual Composer has many tools that power users can play with The fastest way to proficiency is to try the many features Very few things can break, and the undo button is always available The magnifying glass is helpful when the model is very complex and zooming in and out is cumbersome.

26. The Annotation Tool When you are developing very complex models, it is very helpful to add annotations (comments) to document your work. Consider proposing standards within your company (i.e., dates, initials, and what needs to be documented).

27. Getting an Overview Over Complex Models Very large SAP NetWeaver Visual Composer cockpits can be hard to read The Browse feature allows you to see the cockpit in a tree format that makes it easier to navigate Graphical model displays can get hard to read once very complex dashboards are created.

28. Development Methodology Plan on spending serious time with users working on layout and Web page organization P.S.! You can use the SAP delivered calendar for display, or for users to interact with your data set The best way to create cockpits is to prototype it first, then ask for feedback. Since this is a discovery-oriented process, it is not a best practice to use functional specifications to create Web cockpits. Rapid Application Development (RAD) is the preferred methodology.

29. The Back-End GML Code SAP NetWeaver Visual Composeruses the standard GUI Modeling Language (GML). If you are familiar with this language, you can see the code page under the Source tab.

30. Our Target Dashboard • We will build a dashboard based on 2 queries called country and customer view, and present this with tables and graphs as well as navigational links between them (passing variables between the queries)

31. Step 1 — Find the Data You Want to Model You can look at existing queries developed by others. In this example we will create a Web Cockpit based on two SAP NetWeaver BI queries. More advanced developers can also call Business Application Programming Interfaces (BAPIs) that are delivered with SAP NetWeaver BI to build complex applications.

32. Step 2 — Selecting the Queries and Defining a Starting Point • After the query is selected, the metadata is transferred to the model. • We select one query as the starting point and can require users to use a prompt (in this example we will leave this blank).

33. Step 3 — Adding a Table View Based on Query Data • We add a table view and select the fields we want from the query. • We give the table view a meaningful business name.

34. Step 4 – Adding a Chart view based on Query data • We add a chart view based on the query data. • We decide to make it a column chart. • The fields that we want to graph are selected. • We add animation to the column chart.

35. Step 5 — Defining Graph and Assigning Meaningful Names • We select the fields we want to graph as different data series (columns). • We give each column a meaningful business name (this is what the users will see).

36. Step 6 — Suppressing Zero Values from the Query We can suppress the sum rows from the query, so that the graphs are more meaningful and the tables are less cluttered.

37. Step 7 — Adding Navigation: Linking Tablesto Other Queries • When a user selects a row in the country table, we want to show all the customers in that country and their sales. • We link the output from the country table view to the customer query and map the country-key value between the two objects.

38. Step 8 — Adding Navigation: Linking Graphsto Other Queries • We also want to give the users the option to click on a country in the graph and see all the customer’s sales. • Again, we link the output from the country graph to the customer query and map the country-key value between the objects.

39. Step 9 — Adding a Table View for Customer Sales Data Previously we added a table and a graph of country sales. Now we want to add similar views for customer sales. • First we add a table view. • We select the fields to be displayed from the query. • We give the table a meaningful name.

40. Step 9 — Adding a Table View for Customer Sales Data (cont.) Now we add a pie chart. • First we add a graph view. • We select the pie chart type and the fields to be graphed. • We give the field a meaningful business name.

41. Step 10 — Suppressing Zero Values from the Query Again, we suppress the sum rows from the query, so that the graphs are more meaningful and the tables are less cluttered.

42. Step 11 — Layout and Compiling of Dashboard In the layout section we arrange the objects and resize them so that they look good. We also compile the model and can now view it in the Portal

43. The Result: The Web Cockpit in SAP NetWeaver Portal All country sales are displayed based on the first query

44. The Result: Navigation Between the Graphs By clicking on the country in either of the top views, the bottom views display sales for those customers

45. What We’ll Cover … • SAP NetWeaver Visual Composer overview • Building an SAP NetWeaver Visual Composer model • Demo – A complete cockpit from scratch • Improving performance tuning • Upgrading SAP NetWeaver Visual Composer 7.0 to version 7.3 • Looking at other options • Wrap-up

46. Demo – A complete cockpit from scratch

47. External Web Services External Web services such as email, stock quotes, news services, and weather maps can also be integrated into your SAP NetWeaver Visual Composer cockpit.

48. External Data Providers — Web Services Each Web service may require different input, so you have to spend some time trying out what works for your site and how to format it.

49. What We’ll Cover … • SAP NetWeaver Visual Composer overview • Building an SAP NetWeaver Visual Composer model • Demo – A complete cockpit from scratch • Improving performance tuning • Upgrading SAP NetWeaver Visual Composer 7.0 to version 7.3 • Looking at other options • Wrap-up

50. Performance Tips: BIA and Summary Cubes 1) If your cockpits are at a higher level such as weekly or monthly, consider the use of summary cubes to reduce the data accessed (also take a look at building aggregates). 2) For high volume or high number of users, you should seriously consider the BW Accelerator Solution. This compresses the data and stores the data in memory (no disk access when queries are run). This is “hyper fast”…