MGS 4020 Business Intelligence Environment Tools Jun 18

MGS 4020 Business Intelligence Environment & Tools Jun 18, 2020 Georgia State University - Confidential MGS 4020_08. ppt/Jun 18, 2020/Page 1

Agenda Business Intelligence Environment Business Intelligence Tools - MS Excel Georgia State University - Confidential Business Intelligence Tools - Business Objects Business Intelligence Tools - Webi Business Intelligence Tools - Cognos MGS 4020_08. ppt/Jun 18, 2020/Page 2

Internal Source Systems Extract, Transformation and Load Business Intelligence Environment Data Warehouse Data Mart External Data Sources Georgia State University - Confidential MGS 4020_08. ppt/Jun 18, 2020/Page 3

Business Intelligence Environment Broad User Base Microsoft Excel Report Writers Data Warehouse Data Mart BI Query & Analysis Tools OLAP Cubes EIS / Dashboards β Data Mining Tools Narrow User Base Georgia State University - Confidential MGS 4020_08. ppt/Jun 18, 2020/Page 4

Agenda Business Intelligence Environment Business Intelligence Tools - MS Excel Georgia State University - Confidential Business Intelligence Tools - Business Objects Business Intelligence Tools - Webi Business Intelligence Tools - Cognos MGS 4020_08. ppt/Jun 18, 2020/Page 5

Microsoft Excel Why Excel is an effective BI Tool • Extensive knowledge base • Very good for “what-if” analysis • Flexible • Feature rich • Great single user analysis tool • Open Architecture support powerful Add-ins • Ability to import data for analysis Where Excel falls short • Some flexibility requires programming knowledge • Database ability limited by =Dfunctions • Limited meta-data capabilities • No server based components • Mainly a document centric approach • Interface to database has limitations Georgia State University - Confidential MGS 4020_08. ppt/Jun 18, 2020/Page 6

Microsoft Excel Features that support Business Intelligence • Data-Import External Data (MS Query) • Charting • Pivot-Tables • Database Functions (Dfunctions) • If-Then-Else Logic • VBA interface Uses Excel Database Functions to work with results DAVERAGE DCOUNTA DGET DMAX DMIN DPRODUCT DSTDEVP DSUM DVARP Can uses VBA script to allow for Dynamic Queries Georgia State University - Confidential MGS 4020_08. ppt/Jun 18, 2020/Page 7

BI Query & Analysis Tools • Provides an end user the ability to query a database and analyze information BI Query & Analysis Tool Vendors • Business Objects • Cognos • Brio • Micro. Strategy Georgia State University - Confidential MGS 4020_08. ppt/Jun 18, 2020/Page 8

BI Query & Analysis Tool Common Features • • Meta-Data Layer - Insulates the end user from the complexities of the data, database and technology Easy to use query interface Built in data functions Slice-and-Dice Capabilities Charting and Graphing Report Development Security Dashboarding BI Query and Analysis Meta-Data functions • • • Defines table relationships Provides business naming Pre-defines calculations Reorganizes data fields Assists in data security Provides help text on tables, columns & calculations Georgia State University - Confidential MGS 4020_08. ppt/Jun 18, 2020/Page 9

Agenda Business Intelligence Environment Business Intelligence Tools - MS Excel Georgia State University - Confidential Business Intelligence Tools - Business Objects Business Intelligence Tools - Webi Business Intelligence Tools - Cognos MGS 4020_08. ppt/Jun 18, 2020/Page 10

Business Objects What is Business Objects? • BUSINESS OBJECTS is an integrated query, reporting and analysis solution for business professionals that allows you to access the data in your corporate databases directly from your desktop and present and analyze this information in a BUSINESS OBJECTS document. • BUSINESS OBJECTS makes it easy to access this data, because you work with it in business terms that are familiar to you, not technical database terms like SQL. You don’t need any knowledge of the database structure or technology. Once you’ve used BUSINESS OBJECTS to access the data you need, you can present Georgia State University - Confidential MGS 4020_08. ppt/Jun 18, 2020/Page 11

Business Objects – What data sources are available? BUSINESS OBJECTS let you access data from a wide range of sources. You can access data from • • • Relational databases (RDBMS), such as ORACLE, Microsoft SQL Server, Informix and IBM DB 2. Multidimensional (OLAP) databases, such as Microsoft OLAP Services, Hyperion Essbase, and ORACLE Express. Text files and spreadsheets Packaged applications such as SAP Virtually any data source using Microsoft Visual Basic for Applications (VBA) Georgia State University - Confidential MGS 4020_08. ppt/Jun 18, 2020/Page 12

Business Objects – New Report Wizard • To help you build a data provider when you create a new document, BUSINESS OBJECTS launches the New Report Wizard when you start the application for the first time: Georgia State University - Confidential MGS 4020_08. ppt/Jun 18, 2020/Page 13

Business Objects – Specify Data Access • Select an option for the report layout, then click Begin. The Specify Data Access dialog box appears: Georgia State University - Confidential MGS 4020_08. ppt/Jun 18, 2020/Page 14

Business Objects – Select A Universe • The next step depends on what you want to do: • If you chose to build a query on a universe in the previous step, the Select a Universe dialog box now appears: Georgia State University - Confidential MGS 4020_08. ppt/Jun 18, 2020/Page 15

Business Objects – What Exactly is a Universe? • BUSINESS OBJECTS universes make it easy to access data, because they contain objects of data in business terms that are familiar to you. What’s more, you need no knowledge of the database structure, or of database technology, to be able to create powerful reports with data that is relevant to your work. • Universes provide the business-intelligent, semantic layer that isolates you from the technical issues of the database. A universe maps to data in the database, in everyday terms that describe your business situation. • Universes are made up of classes and objects. For example, the objects in a human resources universe would be Names, Addresses, Salaries, etc. Classes are logical groupings of objects. Each class has a meaningful name, such as Vacation (for objects pertaining to employees’ vacations). Each object maps to data in the database, and enables you to retrieve data for your reports. Georgia State University - Confidential MGS 4020_08. ppt/Jun 18, 2020/Page 16

Business Objects – Classes & Sub-classes Georgia State University - Confidential MGS 4020_08. ppt/Jun 18, 2020/Page 17

Business Objects – Dimension objects, measure objects and detail objects • Dimension objects retrieve the data that will provide the basis for analysis in a report. Dimension objects typically retrieve character-type data (customer names, resort names, etc. ), or dates (years, quarters, reservation dates, etc. ) • A detail object is always associated to one dimension object, on which it provides additional information. For example, Address is a detail object that is associated to Customer. Address provides additional information on customers, i. e. , their addresses. • Measure objects retrieve numeric data that is the result of calculations on data in the database. In the demo universe, Revenue is the calculation of number of items sold multiplied by item price. Measure objects are usually located in the Measures class. Georgia State University - Confidential MGS 4020_08. ppt/Jun 18, 2020/Page 18

Building a Query on the Query Panel Georgia State University - Confidential MGS 4020_08. ppt/Jun 18, 2020/Page 19

Building a Query on the Query Panel Georgia State University - Confidential a. Classes appear as folders. b. Objects appear as cubes (for dimensions), spheres (for measures) or pyramids (for details). c. This button displays the universe’s predefined conditions. d. This button, selected by default, displays the universe’s classes and objects. e. Information on the selected class or object appears here. f. This button enables you to set options before running the query, for example to specify a maximum number of rows. g. The Result Objects box displays the objects that are included in the query. h. When you click Run, the query connects to the database and the data appears in the MGS 4020_08. ppt/Jun 18, 2020/Page 20

Building a Query on the Query Panel Georgia State University - Confidential i. Save and Close lets you save the query you have defined without running it. You can run it later on by using the Refresh command. j. When you click View, the raw data retrieved by the query appears in the Data Manager. From the Data Manager, you can edit, accept or cancel the query. k. When you click Run, the query connects to the database and the data appears in the MGS 4020_08. ppt/Jun 18, 2020/Page 21

Building a Query on the Query Panel Click Run. BUSINESS OBJECTS retrieves the data for Resort, Year and Revenue, and displays this in a new document: Georgia State University - Confidential MGS 4020_08. ppt/Jun 18, 2020/Page 22

Creating User Objects – What is a User Object? • • A universe consists primarily of classes and objects, created by the universe designer. If the objects in a universe do not meet your needs, you can customize the universe by creating your own objects, which are called user objects. User objects appear in the User Objects class in the universe. You include them in queries in the same way that you include regular objects. Moreover, you do not need to define a connection to a database to define a user object. Georgia State University - Confidential MGS 4020_08. ppt/Jun 18, 2020/Page 23

Creating User Objects To create a user object in any universe available to you 1. Select the Universes command on the Tools menu. The Universes dialog box appears. 2. Select the universe in which you want to create the user object, then click User Objects. The User Objects dialog box appears. 3. Click Add. The User Object dialog box appears: 4. In the Definition tab, type the name of the user object in the Name field. Georgia State University - Confidential MGS 4020_08. ppt/Jun 18, 2020/Page 24

Creating User Objects 5. 6. 7. 8. 9. In the Type list, select the type of the user object (Character, Number or Date). In the Description field, type a help text on the object. The help text appears when you select the user object in the Query Panel. In the Qualification box, click a radio button to qualify the user object as a dimension, a measure or a detail. Click the Formula tab to write the formula for the user object. Click OK. The user object you have created appears in the User Objects dialog box. The next time you build or edit a query on the universe, the user object you have created will appear in the User Objects class. Georgia State University - Confidential MGS 4020_08. ppt/Jun 18, 2020/Page 25

Creating User Objects - Formula 1. Click the Formula tab, then check Get Assistance on Functions: 2. 3. Double-click the objects, functions and operators you want to use in the user object's formula. • When you double-click an object or an operator, it appears in the Formula box. The functions and operators you can select depend on the database at your site. • When you double-click a function, the Function[Function. Name] dialog box appears. Georgia State University - Confidential MGS 4020_08. ppt/Jun 18, 2020/Page 26

Creating User Objects - Formula 4. 5. 6. In the Function[Function. Name] dialog box, type an argument in each field. • If the function's arguments include objects, user objects, functions or operators, you can double-click these in order to insert them in the function's formula. • The arguments appear in the Formula box. If necessary, type text, numbers or dates in the formula. You must type quotes (") before and after text and numbers, but type a single quote (') before and after dates. Click OK, then click Test to check the syntax of the formula. Georgia State University - Confidential MGS 4020_08. ppt/Jun 18, 2020/Page 27

Applying a complex condition on a query Applying a complex condition requires three steps. First, you select the object you want, then the operator (e. g. , greater than), then the operand (e. g. , values that you type, or another object). The following procedure explains how to do it, and gives information to help you choose the operator and operand you need: 1. In the Query Panel, drag the object you want to use from the Classes and Objects list to the Conditions box. The Classes and Objects list turns into the Operators list: Georgia State University - Confidential MGS 4020_08. ppt/Jun 18, 2020/Page 28

Applying a complex condition on a query Georgia State University - Confidential MGS 4020_08. ppt/Jun 18, 2020/Page 29

Applying a complex condition on a query 2. Double-click the operator you want to use. The Operators list turns into the Operands list: Georgia State University - Confidential MGS 4020_08. ppt/Jun 18, 2020/Page 30

Applying a complex condition on a query 3. Double-click the operand you want. The following table helps you select the operand you need and tells you what to do next: Georgia State University - Confidential MGS 4020_08. ppt/Jun 18, 2020/Page 31

Agenda Business Intelligence Environment Business Intelligence Tools - MS Excel Business Intelligence Tools - Business Objects Business Intelligence Tools - Webi Business Intelligence Tools - Cognos • EIS / Dashboarding Georgia State University - Confidential MGS 4020_08. ppt/Jun 18, 2020/Page 32

EIS / Dashboarding • To provide real time view of KPI and metrics • EIS / Dashboarding vendors • • Cognos Business Objects http: //www. businessobjects. com/products/dashboard_manager • • Brio Pilot Lightship Georgia State University - Confidential MGS 4020_08. ppt/Jun 18, 2020/Page 33

Business Objects - Dashboard Georgia State University - Confidential MGS 4020_08. ppt/Jun 18, 2020/Page 34

Agenda Business Intelligence Environment Business Intelligence Tools - MS Excel Georgia State University - Confidential Business Intelligence Tools - Business Objects Business Intelligence Tools - Webi Business Intelligence Tools - Cognos MGS 4020_08. ppt/Jun 18, 2020/Page 35

Webi 6. 1: Reporting features http: //webiwh/wiasp/ Report creation features new to Web. Intelligence 6. 1 – – – – – Multi-block creation Multi-report creation Add pre-defined blocks and cells Local Variables Better control when formatting and positioning Improved layout properties Define Sections through Drag & Drop (or Report Panel) Insert breaks & sorts, calculations, rows, columns Filtering blocks and report: simple filters & compound filters Drag-and-drop report editing, turn to Georgia State University - Confidential MGS 4020_08. ppt/Jun 18, 2020/Page 36

Completely New Query Window Three modes: • Edit Query • Edit Report • View Results Georgia State University - Confidential MGS 4020_08. ppt/Jun 18, 2020/Page 37

Webi 6. 1 – Query Users • • For query users, the differences will be greater. Look and feel of the new query panel is much more user friendly and powerful, but will take some time to become familiar with The following slides will take you through some basic report creation and the new features of Webi 6. 1 **Please Note** When entering in a date range, you now must enter in the entire year(eg. 2003) and not just 03(eg. 4/20/2003 as opposed to 4/20/03) Georgia State University - Confidential MGS 4020_08. ppt/Jun 18, 2020/Page 38

Webi 6. 1 – Query Features Edit Query – create/edit a query, define query filters, query properties, and/or scope of analysis. Edit Report change document format including the structure (e. g multiblocks), layout and colors. Georgia State University - Confidential MGS 4020_08. ppt/Jun 18, 2020/Page 39

Webi 6. 1: Edit Query All New Documents start here, but users can return to edit the query at any time Georgia State University - Confidential MGS 4020_08. ppt/Jun 18, 2020/Page 40

Webi 6. 1: View and Display Modes When editing the report users may view a report in: – Structure or Results – Normal or Page Layout – Drill mode (View Results) Georgia State University - Confidential MGS 4020_08. ppt/Jun 18, 2020/Page 41

Webi 6. 1: Edit Report Normal Page Display (Page Layout button is Toggled off…) Georgia State University - Confidential MGS 4020_08. ppt/Jun 18, 2020/Page 42

Webi 6. 1: Edit Report Page Layout Display button is Toggled on… Georgia State University - Confidential MGS 4020_08. ppt/Jun 18, 2020/Page 43

Webi 6. 1: Tabs Report Manager: Data, Templates, Properties, Map The Properties tab displays is relevant to a selected object, block, etc. The Map tab facilitates navigation. Georgia State University - Confidential MGS 4020_08. ppt/Jun 18, 2020/Page 44

Webi 6. 1: Edit Report Toolbar User can toggle between View Structure and View Results Top Bar – General Document-related features Bottom Bar – Selection specific features (including Drill) Georgia State University - Confidential MGS 4020_08. ppt/Jun 18, 2020/Page 45

Webi 6. 1: Report Pane Georgia State University - Confidential MGS 4020_08. ppt/Jun 18, 2020/Page 46

Webi 6. 1: Filter Pane Filter zone: Refining the display of report data Georgia State University - Confidential MGS 4020_08. ppt/Jun 18, 2020/Page 47

Webi 6. 1: Feedback and Tool Tips • • Tool tips on icons – mouseover help Tips & feedback when dragging object (pre-drop) On Mouseover Icons indicate filters, sorts & breaks Clicking on these icons enables you to view their properties Georgia State University - Confidential MGS 4020_08. ppt/Jun 18, 2020/Page 48

Webi 6. 1: Show Me How & Help • “Show me how” icon, – Top right corner of Java Report Panel – Opens a page with links to flash demos • Help menu Georgia State University - Confidential MGS 4020_08. ppt/Jun 18, 2020/Page 49

Webi 6. 1: Multi-Block Create Multiblocks with new block Templates Alternatively, Drag & Drop existing block and Turn to… Georgia State University - Confidential MGS 4020_08. ppt/Jun 18, 2020/Page 50

Webi 6. 1: Multi-report Reports may be added in – Structure or Results – Normal or Page Layout Views – When in Drill mode Georgia State University - Confidential Inserting (or Duplicating) a Report MGS 4020_08. ppt/Jun 18, 2020/Page 51

Webi 6. 1: Block & Cell Templates Block templates Georgia State University - Confidential MGS 4020_08. ppt/Jun 18, 2020/Page 52

Webi 6. 1: Block & Cell Templates Cell templates – – – Blank cell Drill Filters Last refresh Date Page Number/Total Pages Total Number of Pages Georgia State University - Confidential MGS 4020_08. ppt/Jun 18, 2020/Page 53

Webi 6. 1: Local Variables Click Create Variable button Save variable to local data objects Select a cell Same workflow as in Business Objects Georgia State University - Confidential MGS 4020_08. ppt/Jun 18, 2020/Page 54

Webi 6. 1: Layout & Positioning User Options button • With user-options button: – Control layout and positioning of objects – Define measurement unit – Grid on/off, Snap to, Spacing Georgia State University - Confidential MGS 4020_08. ppt/Jun 18, 2020/Page 55

Webi 6. 1: Inserting Sections • • Create sections with Drag & Drop (as Business. Objects) Sections sliders to denote the beginning/end Can be resized! – (can’t be done in 2. 7 nor Business. Objects!) • Sections can be independent – even better! Cells in between sections enables creation of sub-reports Dragable sliders Georgia State University - Confidential Example of URL providing a logo to separate sections MGS 4020_08. ppt/Jun 18, 2020/Page 56

Webi 6. 1: Inserting Breaks & Sorts • Breaks (Workflow like Web. I and Business. Objects) • Sorts can be added (Workflow like Business. Objects) • …and Sorts can be removed from breaks (can not do this in Web. Intelligence 2. 7 nor Business. Objects) Georgia State University - Confidential MGS 4020_08. ppt/Jun 18, 2020/Page 57

Webi 6. 1: Inserting Calcs, Rows, Cols • Calculations can be selected from a menu Georgia State University - Confidential MGS 4020_08. ppt/Jun 18, 2020/Page 58

Webi 6. 1: Filtering Reports & Blocks Quick filters can be applied to – Blocks – Object – Sections Select object and click Quick Filter Button Choose from LOV and filter is displayed Georgia State University - Confidential MGS 4020_08. ppt/Jun 18, 2020/Page 59

Webi 6. 1: Normal Filters • • Drag & drop object to the filter zone launches editor Filter defaults to “Constant” for performance reasons Describes where the filter will be applied. Georgia State University - Confidential MGS 4020_08. ppt/Jun 18, 2020/Page 60

Webi 6. 1: Simple Filters & LOVs • • • List of Values (with chunking feature) Users can search the entire list of values Users can navigate by chunk Chunking feature Search among entire list Georgia State University - Confidential MGS 4020_08. ppt/Jun 18, 2020/Page 61

Webi 6. 1: Compound Filters Drag & Drop to filter zone for compound filters – Adding a simple filter to a simple filter or dragging a simple filter onto another simple filter creates a compound filter – Clicking the AND/OR toggles between the two operators Georgia State University - Confidential MGS 4020_08. ppt/Jun 18, 2020/Page 62

Webi 6. 1: Turn to… Right-click on table/chart to get a Turn To… menu Choose table/chart from dialog Or, Drag & Drop from Report Templates menu Georgia State University - Confidential MGS 4020_08. ppt/Jun 18, 2020/Page 63

Building Queries Georgia State University - Confidential MGS 4020_08. ppt/Jun 18, 2020/Page 64

Webi 6. 1: Overview Familiar presentation (Full-Client & Web. Intelligence Mix) Universe Objects Dimensions, Measures, Details Predefined Filters Result Objects Data for report creation Query Filters Refining data to answer business questions Scope of Analysis Extend data for analysis Georgia State University - Confidential MGS 4020_08. ppt/Jun 18, 2020/Page 65

Webi 6. 1: Objects Dimensions, Details & Measures • Defined in the universe in business terms Predefined Filters • Facilitate access (different than with Web. Intelligence 2. 7) • Also using everyday business terms Georgia State University - Confidential MGS 4020_08. ppt/Jun 18, 2020/Page 66

Webi 6. 1: Hierarchical View Hierachical view Georgia State University - Confidential MGS 4020_08. ppt/Jun 18, 2020/Page 67

Webi 6. 1: Result Objects Displays Objects to be available in the report Semantic change from Web. I 2. 7 & Full-Client Reporter – With new Web. Intelligence, Filters on measures are applied only to Result objects. Objects in the Scope of Analysis do not affect the query results when using filters on measures. – In previous products, Filters on measures are applied to Results Objects+Scope of Analysis objects. Georgia State University - Confidential MGS 4020_08. ppt/Jun 18, 2020/Page 68

Webi 6. 1: Overview Simple to understand & manipulate A simple dialog box provides the filter settings Georgia State University - Confidential MGS 4020_08. ppt/Jun 18, 2020/Page 69

Webi 6. 1: Creation Drag & Drop into Query Pane to display Filter dialog box Georgia State University - Confidential MGS 4020_08. ppt/Jun 18, 2020/Page 70

Webi 6. 1: Creation via Drag & Drop objects to create combination filters Query Objects can be dragged to redefine their logical context Georgia State University - Confidential MGS 4020_08. ppt/Jun 18, 2020/Page 71

Webi 6. 1: Basic Choices • All Simple Filters may be one of these types: – – • Constant – user-defined text entry within Filter dialog box Values from list – choose when displayed in Filter dialog box Prompt – choose when list of values appears at refresh time Predefined Filters – defined inside the universe, when added, no Filter dialog appears Simple Filters can be combined as And/Or operands Clicking on And with toggle the operand to OR, and vice-versa Georgia State University - Confidential MGS 4020_08. ppt/Jun 18, 2020/Page 72

Webi 6. 1: Operators and Operands Complete set of operators Operand types: Constant Values from List Prompts Georgia State University - Confidential MGS 4020_08. ppt/Jun 18, 2020/Page 73

Webi 6. 1: Filter on Measures Filters on Measures: Change from FC & previous Web. Intelligence – The Scope of Analysis is not part of the measure’s aggregation with Web. I • Sales are filtered by Region, Customer and City (Results Objects + Scope) Georgia State University - Confidential MGS 4020_08. ppt/Jun 18, 2020/Page 74

Webi 6. 1: Advanced Filters • When combined with simple filters, Advanced filters enable more complex business questions Results Objects for this Query Show me all Cities, Stores and Revenue for Countries WHERE Revenue > $1 m for the Year 2002 • Such Filters are Impossible to do with simple Query Filters because they require a Sub-Query Georgia State University - Confidential MGS 4020_08. ppt/Jun 18, 2020/Page 75

Webi 6. 1: Advanced Filters Another example: Results Objects for this Query Show me all Years, Products, Sales FOR (City, Year) WHERE Units Sold > 10, 000 Again, Advanced filters enable Sub-Queries, i. e. more complex business questions Georgia State University - Confidential MGS 4020_08. ppt/Jun 18, 2020/Page 76

Webi 6. 1: SQL Subqueries • • • Advanced Filters change a filter’s aggregation level The SQL the query generates uses a subquery Advanced filters can be nested as well Advanced Filter with Two Objects and a simple combination filter Advanced Filter with an Advanced Filter embedded (nested Advanced Filter) Georgia State University - Confidential MGS 4020_08. ppt/Jun 18, 2020/Page 77

Webi 6. 1: Prompts & List of Values • Prompts – Used with query filters (not report filters) Prompt with previously selected values Select default values that report viewers will see Georgia State University - Confidential MGS 4020_08. ppt/Jun 18, 2020/Page 78

Webi 6. 1: Prompts & List of Values • 2 different types of prompts: – Defined in the query itself (are prompted first) – Defined in Universe (in objects, join, Custom List of Values – these are prompted after Query prompts) • Prompts – Report creators can define prompts order for prompts defined in the query panel – 1 st Country, 2 nd Region, 3 rd City, then Store • • Expected format (Date + Number) helps ease-of-use Any operator (e. g. except, isnull, etc) can be used to define a prompt Georgia State University - Confidential MGS 4020_08. ppt/Jun 18, 2020/Page 79

Webi 6. 1: Prompts & List of Values • List of Values features – LOV are used both during Report Creation and also at Run-Time by report viewers – Custom List of Values can be predefined within Designer • • Single or multiple column Full Compatibility with Designer 5. x – Nested LOV (or cascading prompting) – enables a user-oriented workflow – Plus new extra features oriented performance & scalability Georgia State University - Confidential MGS 4020_08. ppt/Jun 18, 2020/Page 80

Webi 6. 1: Prompts & List of Values • List of Value Enhancements • Uses batch display to increase performance time for very large lists Asc. /Desc. sort Browse batches – Ascending/Descending sorts – Search values (wildcards) Search Pattern Georgia State University - Confidential MGS 4020_08. ppt/Jun 18, 2020/Page 81

Webi 6. 1: Prompts & List of Values: Browsing • Browse List of Values by Batch – Allow to handle very huge LOV – The default batch size is a server parameter, allow to size according to the server configuration (default at 1, 000) – The entire values of the LOV is cached during the user session (per document) Georgia State University - Confidential MGS 4020_08. ppt/Jun 18, 2020/Page 82

Webi 6. 1: Prompts & List of Values: Sorting • Sorting the List of Values – Ascending, Descending sort – The batch display is still on, when sorting, the LOV is positioned to the first batch – For Custom LOVs, the sort is available for each column Ascending Descending Batch 1 Batch 2 Batch 3 Georgia State University - Confidential MGS 4020_08. ppt/Jun 18, 2020/Page 83

Webi 6. 1: Prompts & List of Values: Searching Without search Search Values through a search pattern – Use * to filter values (pattern matching) With search • The batch display is still active even when searching • Results are batched to match the pattern Georgia State University - Confidential MGS 4020_08. ppt/Jun 18, 2020/Page 84

Webi 6. 1: Query Panel –Basic Prompt Workflow At Design-Time Filters can include many prompts Users can define prompt order for the refresh workflow Georgia State University - Confidential MGS 4020_08. ppt/Jun 18, 2020/Page 85

Webi 6. 1: Query Panel – Scope of Analysis • Scope of Analysis pane same as Web. Intelligence 2. 7 – Define the scope either by levels (1, 2, 3) or create a custom Scope of Analysis The Scope is deduced from the Results Objects and the Hierarchies defined within the universe Year, Product Family, Country are in the Results Objects (white). Objects in Gray are the extended scope… Georgia State University - Confidential MGS 4020_08. ppt/Jun 18, 2020/Page 86

Webi 6. 1: Query Panel – Query Properties available in the second tab Limits – – « Max rows retrieved » limits the data in the document « Max retrieval time » limits the execution time of the query (in seconds) – “Retrieve duplicate rows” Checked by default Data Security – “Allow other users to edit the query” Checked by default Prompt Order (refer to Prompt chapter) Context – – “Reset contexts on refresh” contexts will be prompted for each refresh. If Checked, the preset contexts are reused without prompt during refresh “Clear Contexts” allows to reset the preset list Georgia State University - Confidential MGS 4020_08. ppt/Jun 18, 2020/Page 87

Webi 6. 1: Query Panel – View SQL Show the generated SQL – Displays mono- and multi-flow Synchronization, Join, Union, Intersection, Minus – Can copy and paste elsewhere Georgia State University - Confidential MGS 4020_08. ppt/Jun 18, 2020/Page 88

Agenda Business Intelligence Environment Business Intelligence Tools - MS Excel Georgia State University - Confidential Business Intelligence Tools - Business Objects Business Intelligence Tools - Webi Business Intelligence Tools - Cognos MGS 4020_08. ppt/Jun 18, 2020/Page 89

Cognos http: //hoteleservices. sabre. com/booking. html Georgia State University - Confidential MGS 4020_08. ppt/Jun 18, 2020/Page 90