User manual BUSINESS OBJECTS INTERACTIVE ANALYSIS 1.0 BUILDING REPORTS

[. . . ] Building Reports with Interactive Analysis Interactive Analysis 1. 0 2010-07-06 Copyright © 2010 SAP AG. All rights reserved. SAP, R/3, SAP NetWeaver, Duet, PartnerEdge, ByDesign, SAP Business ByDesign, and other SAP products and services mentioned herein as well as their respective logos are trademarks or registered trademarks of SAP AG in Germany and other countries. Business Objects and the Business Objects logo, BusinessObjects, Crystal Reports, Crystal Decisions, Web Intelligence, Xcelsius, and other Business Objects products and services mentioned herein as well as their respective logos are trademarks or registered trademarks of Business Objects S. A. Business Objects is an SAP company. All other product and service names mentioned are the trademarks of their respective companies. [. . . ] They can use any filter operator and can filter on single values or lists of values. · Quick filters Quick filters provide an easy way to create filters using the Equal To operator. · Simple report filters Simple report filters provide an easy way to create filters using the Equal To operator. They can filter on single values only. 16. 3 Query filters and report filters compared You can apply filters at two levels within a document: · · query filters ­ these filters are defined on the query; they limit the data retrieved from the data source and returned to the Interactive Analysis 1. 0 Service Pack 1 document. report filters ­ these filters limit the values displayed on reports, tables, charts, sections within the document, but they don't modify the data that is retrieved from the data source; they simply hide values at the report level. 16. 4 Report filter operators 140 2010-07-06 Filtering report data 16. 4. 1 Equal To operator Use the Equal to operator to obtain data equal to a value. For example, to return data for the US only, create the filter "County Equal To US". 16. 4. 2 Not Equal To operator Use the Not Equal To operator to obtain data not equal to a value. For example, to return data for all countries except the US create the filter "County Not Equal To US". 16. 4. 3 Different From operator Use the Different From operator to retrieve data different from a value. For example, to retrieve data for all quarters execpt Q4, create the filter [Quarter] Different From "Q4". 16. 4. 4 Greater Than operator Use the Greater Than operator to retrieve data greater than a value. For example, to retrieve data for customers aged over 60, create the filter "[Customer Age] Greater than 60". 16. 4. 5 Greater Than Or Equal To operator Use the Greater Than Or Equal To operator to retrieve data greater than or equal to a value. For example, to retrieve data for revenue starting from $1. 5M, create the filter "[Revenue] Greater than or equal to 1500000". 141 2010-07-06 Filtering report data 16. 4. 6 Less Than operator Use the Less Than operator to retrieve data lower than a value. For example, to retrieve data for exam grades lower than 40, create the filter "[Exam Grade] Less Than 40". 16. 4. 7 Less Than Or Equal To operator Use the Less Than Or Equal To operator to retrieve data less than or equal to a value. For example, to retrieve data for customers whose age is 30 or less, create the filter "[Age] Less Than Or Equal To 30". 16. 4. 8 Between operator Use the Between operator to retrieve data between and including two values. For example, to retrieve data for weeks starting at week 25 and finishing at 36 (including week 25 and week 36), create the filter "[Week] Between 25 and 36". 16. 4. 9 Not Between operator Use the Not Between operator to retrieve data outside the range of two values. For example; to retrieve data for all the weeks of the year, except for and not including weeks 25 through 36, create the filter "[Week] Not between 25 and 36". 16. 4. 10 In List operator Use the In List operator to retrieve data corresponding to values in a list of values. 142 2010-07-06 Filtering report data For example, to retrieve data for the US, UK and Japan only, create the filter [Country] In List ("US";"UK";"Japan"). 16. 4. 11 Not In List operator Use the Not In List operator to retrieve data that does not correspond to multiple values. For example, if you do not want to retrieve data for the US, UK and Japan, create the filter [Country] Not In ("US";"UK";"Japan"). 16. 4. 12 Is Null operator Use the Is Null operator to retrieve data for which there are no values in the database. For example, to retrieve customers without children (the children column in the database has no value), create the filter [Children] Is Null. 16. 4. 13 Is Not Null operator Use the Is Not Null operator to return data for which there is a value in the database. For example, to return customers with children, create the filter [Children] Is not Null. 16. 5 Creating, editing and deleting report filters 16. 5. 1 To create a report filter using the Quick Filter option 1. Click the report tab of the report you want to filter. 143 2010-07-06 Filtering report data 2. If you want to filter a block (that is, a table, chart, or form), then click the top edge of the block to select it. If you want to filter a section, and not just the section cell, click View Structure and then select either the start section or end section divider. Click the arrow to the right of the Add Filter button on the Report toolbar and select Add Quick Filter. The selected section or block only displays values that correspond to the value you selected. [. . . ] You display the Document Properties pane by right-clicking a report outside all report components and selecting Document Properties from the menu. Group Property Description 287 2010-07-06 Working with documents Document Information Created by Last modified by Creation date Name Description Keywords Locale Data tracking The document creator. Tells Interactive Analysis 1. 0 Service Pack 1 to refresh the document when it is opened. Tells Interactive Analysis 1. 0 Service Pack 1 to drill in query drill mode. [. . . ]