SAP BusinessObjects Web Intelligence: The ... - Amazon S3

1 Reading SampleIn this sample chapter, you l l start in Chapter 2 by creating your first document and query in SAP BusinessObjects BI. In this process, we ll explore the query panel, SAP BEx queries, query filters, and data sources. Then, in Chapter 3, we ll walk through creating a report in Web intelligence from start to finish!Ah-Soon, Brogden, Marks, Orthous, SinkwitzSAP BusinessObjects Web Intelligence: The Comprehensive Guide814 Pages, 4th, updated and revised edition, 2017, $ ISBN 978-1-4932-1547-8 knowledge. Creating New Documents and Queries Creating a Report in Web intelligence ContentsIndexThe Authors452 Chapter 2 Creating New Documents and QueriesCreate queries graphically with the highly intuitive and enhanced Query Panel in Web intelligence .

2 Use the Result Objects pane and Query Filters pane to access the data you need from universes, Excel or text files, free-hand SQL, analysis views or web services, and then cre-ate and share powerful analysis documents with business chapter takes you through the first steps of creating a Web intelligence docu-ment from within the BI Launch Pad portal. It describes a simple workflow startingfrom a relational universe and describes how to create a query from it through theQuery Panel, and filter the retrieved dataset with filters and these steps are easily done through Web intelligence Query Panel which providesbusiness users with an intuitive interface for retrieving and filtering data.

3 Queries arecreated graphically by selecting objects (database fields) to query or to filter. This col-lection of objects is translated a generated SQL statement sent to the versions of this Query Panel are also available for other data sources: Exceland text files, Free-Hand SQL, web service and analysis views. Query Panel s advancedcapabilities, like accessing SAP data sources, multi-dimensional universes, querystripping or multi-queries are covered in Chapter 12 to Chapter your data source, you can set some useful options to your Creating a Web intelligence Document from a UniverseThe portal interface in SAP BusinessObjects BI provides two ways to launch theWeb intelligence query and analysis tool in the BI Launch Pad.

4 After logging on to theBI Launch Pad and going to the Home tab, you ll notice a column on the right-hand2 Creating New Documents and Queries46side of the page with six application shortcuts. These links are beneath the My Appli-cations shows the shortcut icons for these six applications in the BI Launch Pad: Module Analysis Edition for OLAP Information Steward Crystal Reports for Enterprise BI Workspace Web IntelligenceFigure Launching Web intelligence from BI Launch PadAn alternate method of launching Web intelligence from within the BI Launch Pad isby clicking on the Applications link located in the top menu of the page.

5 Links to thesame six applications as previously described will appear but in a different shows the result of clicking on the Applications menu link and selectingWeb intelligence from the list 1: Click Applications and selectWeb intelligence in the menu Option 2: Click WebIntelligence icon a Web intelligence Document from a Universe2 Figure Launching Web intelligence from the Applications Menu LinkAn alternate method of launching Web intelligence is to click its icon in the bottomof the pane in the right you have set Web intelligence Java Applet as your preferred client (see Chapter 1,Section ), then it opens after the security warning and the splash screen.

6 Other-wise, if you have selected the Web intelligence HTML client, then the HTML versionopens almost both cases, Web intelligence displays to a blank screen with all of the shortcuticons disabled except for two choices: Create a new document ([Ctrl]+[N]) Open (retrieve) a document from the server ([Ctrl]+[O])From the Web intelligence tab itself, you have additional options to interact with thedocument by clicking on one of three small icons located beside the document is where you can enlarge the screen by opening the document in a new windowor simply close the Web intelligence application.

7 There are three clickable iconoptions on the Web intelligence tab: Open in a new window Pin (or unpin) this tab CloseFigure shows the options available after launching the Web intelligence applica-tion and before a document is created or on the Blank Document icon to create a new Web intelligence New Documents and Queries48 Figure Options Available before Creating or Opening a DocumentAs shown in Figure , the Create a Document dialog box opens and proposes you tocreate a blank document based on seven possible data sources: Universe Excel BEx SAP HANA SAP HANA Online Analysis View (this data source is not supported in Web intelligence HTML)

8 Free-hand SQL The No data source option allows you to start creating a document without any Selecting a Data Source for a New Document in Web intelligence JavaCreate a new documentImport an existingdocument Open in new windowPin the document a Web intelligence Document from a Universe2In addition of the data sources supported in HTML and Java Applet, two additionaldata sources can be used to create Web intelligence documents while working in theWeb intelligence Rich Client (see Figure ): Text and Web Data Source Types Available in Web intelligence Rich ClientAs this is the most common data source, to introduce you the Query Panel, we ll firstdescribe the workflow to create a new document from a universe; other data sourcesbeing presented in Section patented SAP BusinessObjects semantic layer known as the universe remains theprimary method for connecting reporting documents to traditional data warehousesand relational databases.

9 Historically, universes were created in the tool namedDesigner, renamed into Universe Design Tool in SAP BusinessObjects BI SAPB usinessObjects also introduced the Information Design Tool, a new universe cre-ation tool that creates a new universe format (UNX). This new universe format can becreated from multiple sources and from multidimensional New Documents and Queries50 The objects in your universes should be consistently named with business terms toprovide users with the simplest and most intuitive approach to retrieving the datathey ReferenceFor more details on universes, you can refer to Universe Design with SAP business -Objects BI: The Comprehensive Guide (SAP Press, 2014, ).

10 But little has changed from a user s perspective when it comes to connecting to a uni-verse to query a database. Database fields, known in the universe as objects, are usedin the Query Panel to retrieve data and to restrict the results to return only the infor-mation selecting Universe as the data source for a new document, you re presentedwith a list of available universes that you have permission to access. Click on a uni-verse in the list, and click on Select to proceed. Figure shows an example list ofavailable universes that can be used as a data Universe Query Panel in Web Intelligence2 After you make your universe selection, the Web intelligence tool will be launchedand opened to the Query Panel.