User manual BUSINESS OBJECTS DATA INSIGHT XI 3.0

[. . . ] BusinessObjects Data Insight XI 3. 0 User's Guide BusinessObjects Data Insight XI 12. 0. 0. 0 March 2008 Contact information Contact us on the Web at http://technicalsupport. businessobjects. com If you find any problem with this documentation, please report it to Business Objects in writing at documentation@businessobjects. com. Copyright Patents Copyright © 2005­2008 Business Objects. patents, which may cover products that are offered and sold by Business Objects: 5, 555, 403, 6, 247, 008 B1, 6, 578, 027 B2, 6, 490, 593 and 6, 289, 352. Business Objects, the Business Objects logo, Crystal Reports, and Crystal Enterprise are trademarks or registered trademarks of Business Objects SA or its affiliated companies in the United States and other countries. All other names mentioned herein may be trademarks of their respective owners. [. . . ] Outer join in which all rows from the table represented on the left will be included, even if they do not have matches in the related table. Outer join in which all rows from the table represented on the right will be included, even if they do not have matches in the related table. A full outer join n which all rows from both tables will be included, even if they do not have matches in the related table. One-to-one join. One-to-many join. 126 BusinessObjects Data Insight XI Release 2 User's Guide Join line icon Description The custom query builder cannot determine the join type. Remove a join To remove a join, in the Relations pane, select the join, and then press the Delete key. The custom query builder removes the join and alters the statement in the SQL pane. By entering your choices into a spreadsheet-like grid, the Column pane of the Custom Query window allows you to specify query options, such as which data columns to display, how to order the results, and what rows to select. In the Column pane you can specify: Columns to display and column name aliases. Changes you make in the Column pane are automatically reflected in the Relations pane and SQL pane. Similarly, the Column pane is updated automatically to reflect changes made in the other panes. The Column pane Chapter 7: Custom queries 127 The following table lists the name of these columns and a description of each: Column name Description Column Alias Object Object Alias Output Displays the name of the column in the table used for the query. Note: If the database allows, you can use a data column for sort or search clauses without displaying it in the result set. Specifies that the associated data column is used to sort the query results and whether the sort is ascending or descending. Specifies the sort priority for data columns used to sort the result set. When you change the sort order for a data column, the sort order for all other columns is updated accordingly. Specifies that the associated data column is being used to create an aggregate query. When you move to a cell in this column and select an aggregate function to apply to the associated data column, by default the resulting expression is added as an output column for the result set. Specifies a search condition (filOperators available for use: ter) for the associated data col= equal to umn. <= less than or equal to If you enter values for more than one cell in the Criteria column, > greater than the resulting search conditions >= greater than or equal to are automatically linked with a logical AND. To specify multiple search condition expressions for a single database column [for example, (fname > `A') AND (fname < `M')], add the data column to the Column pane twice and enter separate values in the Criteria grid column for each instance of the data column. Specifies an additional search condition expression for the data column, linked to previous expressions with a logical OR. Logical OR only displays if you enter data in the criteria column. Sort Type Sort Order Group By Criteria Or. . . The SQL pane The SQL pane of the Custom Query window displays the SQL statement for your query. In this pane, you can enter the SQL statements directly, or you can edit statements created in other panes. In this pane, you have access to the Edit menu's options for copying, cutting, and pasting text. [. . . ] Having this information allows you to evaluate these rows and make necessary adjustments so that each of these customers meets the pre-determined business rule criteria. 254 BusinessObjects Data Insight XI 3. 0 User's Guide At this point, you might want to save these results in a report and export it to whomever is responsible for correcting and/or gathering customer data. You can also use the Save Data As function in the Results window to export the data for further analysis, manual review by stakeholders, or input to a cleansing process. Truth data queries Truth data queries allow you to validate your address data. Data Insight uses Data Quality technology to provide data results that you can use to make management decisions. For example, the results will allow you to prioritize which addresses or data sources to cleanse. [. . . ]