Web Intelligence, The Business Intelligence Reporting Tool .

Transcription

SAP WebiAbout the TutorialWeb Intelligence, the business intelligence reporting tool, is a part of SAP BusinessObjectsproduct suite. This is a handy tool for business users for analytical and ad hoc reporting.Using Web Intelligence, business users can create basic, medium, and complex reportsfrom transactional data in database to meet business requirements. This tutorial explainsthe key concepts of SAP Web Intelligence (SAP Webi).AudienceThis tutorial is designed for all those readers who want to learn the basics of SAP WebIntelligence and implement it to analyze data with the help of BI Launchpad and Webi.PrerequisitesYou need to have the required skills to unearth relevant data and analyze it in order tocreate professional reports.Disclaimer & Copyright Copyright 2018 by Tutorials Point (I) Pvt. Ltd.All the content and graphics published in this e-book are the property of Tutorials Point (I)Pvt. Ltd. The user of this e-book is prohibited to reuse, retain, copy, distribute or republishany contents or a part of contents of this e-book in any manner without written consentof the publisher.We strive to update the contents of our website and tutorials as timely and as precisely aspossible, however, the contents may contain inaccuracies or errors. Tutorials Point (I) Pvt.Ltd. provides no guarantee regarding the accuracy, timeliness or completeness of ourwebsite or its contents including this tutorial. If you discover any errors on our website orin this tutorial, please notify us at contact@tutorialspoint.com.i

SAP WebiTable of ContentsAbout the Tutorial . iAudience . iPrerequisites . iDisclaimer & Copyright. iTable of Contents . ii1.SAP WEBI – OVERVIEW. 1Versions and History . 1Web Intelligence Architecture . 12.SAP WEBI – BI LAUNCHPAD . 33.SAP WEBI – BI PREFERENCES . 64.SAP WEBI – APPLICATION MODES . 8Data Application Mode . 8Reading Mode . 8Design Mode . 95.SAP WEBI – CREATING DOCUMENTS . 11Creating Documents in Webi . 11Creating Document Based on Universe . 12Creating Document based on BEx . 14Creating Document Based on Analysis View . 166.SAP WEBI – EDITING & OPENING DOCUMENTS. 177.WEB INTELLIGENCE – SENDING DOCUMENTS . 20Sending a Document via E-mail . 20Sending Documents to Other Users . 21ii

SAP WebiSending Documents Using FTP . 218.SAP WEBI – MANAGING REPORTS . 229.SAP WEBI – USING QUERIES . 25Query Definition . 25Query and Documents User Rights . 2710. SAP WEBI – QUERIES USING UNIVERSE . 2911. SAP WEBI – QUERIES USING BEX . 33How to Enable Access to BEx Query? . 34How to Use BEx as Data Source in WebI Rich Client?. 3512. SAP WEBI – QUERIES USING ANALYSIS VIEW . 3813. SAP WEBI – QUERY FILTERS . 4014. SAP WEBI – QUERY FILTER TYPES . 42Predefined Query Filters . 42Quick Filters . 43Custom Query Filters . 44Prompts . 45Combining Prompts with Query Filter . 4915. SAP WEBI – RANKING DATA. 5416. SAP WEBI – WORKING WITH REPORTS . 55Organizing Data with Sections, Breaks, Sorts . 56Creating a Section from a Column . 57Creating a Section from a Dimension . 57Creating Sections from Hierarchy . 58iii

SAP WebiRemoving or Hiding a Section . 5917. SAP WEBI – BREAKS . 61How to Insert a Break? . 61Manage Breaks . 6218. SAP WEBI – SORTS . 63How to Insert a Sort? . 6319. SAP WEBI – CHARTS . 65Bar Charts . 65Box Plot Charts . 65Column Charts. 66Line Charts . 67Map Charts. 67Pie Charts . 68Point Charts . 68Radar Chart . 69Tag Cloud . 70Waterfall . 70Add a Chart to Report . 71Copy Chart . 73Delete a Chart . 74Changing a Chart Type . 74Resize Charts . 75Formatting a Chart . 7620. SAP WEBI – CONDITIONAL FORMATTING . 78Creating a Conditional Formatting Formula . 78iv

SAP WebiManage Conditional Formatting Rules . 8021. SAP WEBI – FILTERING REPORT DATA. 82Report Filter Operators . 82Types of Report Filters . 83Create, Edit, Delete Standard Report Filters . 8322. SAP WEBI – INPUT CONTROLS . 85Defining Input Controls in Webi . 85Edit an Input Control . 87Organize Input Controls . 88View Input Controls Map . 89Define Table and Charts as Input Controls . 8923. SAP WEBI – FORMULAS AND VARIABLES . 91How to Enter a Formula?. 91How to Create a Variable? . 9124. SAP WEBI – DRILL OPTIONS IN REPORTS. 94Setting Drill Option . 9425. SAP WEBI – SHARING REPORTS . 96Publishing as Web Services .

year 1994 Business Objects v3.0 was launched. In 2005, BO XI was released and later on various other versions introduced. Some of the versions are: BO XI R1 BO XI R2 BO XI R3 BO XI R3.1 BO XI R3.2 In 2007, SAP acquired this company for 6.8 billion and the product has been renamed as SAP .