User manual BUSINESS OBJECTS ENTERPRISE XI 3.0 BUILDING QUERIES WITH WEB INTELLIGENCE QUERY - HTML

[. . . ] Building queries with Web Intelligence Query - HTML BusinessObjects Enterprise XI 3. 0 Copyright © 2008 Business Objects, an SAP company. Business Objects owns the following U. S. patents, which may cover products that are offered and licensed by Business Objects: 5, 295, 243; 5, 339, 390; 5, 555, 403; 5, 590, 250; 5, 619, 632; 5, 632, 009; 5, 857, 205; 5, 880, 742; 5, 883, 635; 6, 085, 202; 6, 108, 698; 6, 247, 008; 6, 289, 352; 6, 300, 957; 6, 377, 259; 6, 490, 593; 6, 578, 027; 6, 581, 068; 6, 628, 312; 6, 654, 761; 6, 768, 986; 6, 772, 409; 6, 831, 668; 6, 882, 998; 6, 892, 189; 6, 901, 555; 7, 089, 238; 7, 107, 266; 7, 139, 766; 7, 178, 099; 7, 181, 435; 7, 181, 440; 7, 194, 465; 7, 222, 130; 7, 299, 419; 7, 320, 122 and 7, 356, 779. Business Objects and its logos, BusinessObjects, Business Objects Crystal Vision, Business Process On Demand, BusinessQuery, Cartesis, Crystal Analysis, Crystal Applications, Crystal Decisions, Crystal Enterprise, Crystal Insider, Crystal Reports, Crystal Vision, Desktop Intelligence, Inxight and its logos , LinguistX, Star Tree, Table Lens, ThingFinder, Timewall, Let There Be Light, Metify, NSite, Rapid Marts, RapidMarts, the Spectrum Design, Web Intelligence, Workmail and Xcelsius are trademarks or registered trademarks in the United States and/or other countries of Business Objects and/or affiliated companies. [. . . ] The "Interrupt Data Retrieval" dialog box appears. Select a the query you want to remove by right-clicking the appropriate Query tab. Click Remove. Multiple queries You can include one or multiple queries in a Web Intelligence document. When you include multiple queries, those queries can be based on a single universe or on multiple universes available in InfoView. For example, you can include product sales data and customer data in the same document. In this case, your corporate data for product line sales is available on one universe and data on customers is available on another universe. You want to present product line sales results and information on customer age groups in the same report. To do this, you create a single document that includes two queries; one query on each universe. You can then include and format results from both queries on the same report. Defining multiple queries in a single document is necessary when the data you want to include in a document is available on multiple universes, or when you want to create several differently-focused queries on the same universe. You can define multiple queries when you build a new document or add more 36 Building queries with Web Intelligence Query - HTML Working with queries To add a query in Query - HTML 4 queries to an existing document. You can present the information from all of the queries on a single report or on multiple reports in the same document. To add a query in Query - HTML 1. Select the universe you want to use to build the query. You can create a new query on a universe already used in the document or select a different universe. By default, the universe used in the current document is displayed first. Define the objects, filters, scope of analysis, and properties you want for the query. The data content, scope of analysis, and filters you define here will only apply to the selected query. The query properties you define only apply to the selected query. To duplicate a query If you want to build a different query on a universe already included in the document, you can duplicate the existing query on that universe and then modify it, instead of starting from scratch. Select the query you want to duplicate by right-clicking the appropriate Query tab at the bottom of the report panel. Select Duplicate Building queries with Web Intelligence Query - HTML 37 4 Working with queries To duplicate a query 38 Building queries with Web Intelligence Query - HTML Setting the scope of analysis 5 5 Setting the scope of analysis Scope of analysis Scope of analysis The scope of analysis for a query is extra data that you can retrieve from the database to give more details on the results returned by each of the objects in a query. This extra data does not appear in the initial result report, but it remains available in the data cube, so you can pull this data in to the report to allow you to access more detail at any time. This process of refining the data to lower levels of detail is called drilling down on an object. [. . . ] Use the "Prompt Properties" dialog box to define how the prompt displays. Defining how prompts display By default, prompts display a box and a list of values. You answer the prompt by either typing the value(s) in the box or by selecting value(s) from the list. You can modify how prompts display by checking one, some, or all of the following options: If you want the prompt (useful when you. . . ) to display. . . want to view all the valthe list of values associatues for the object and ed with the filtered dimenthen select from those sion, measure, or detail, values then. . . leave the option selected by default: Prompt with List of Values 66 Building queries with Web Intelligence Query - HTML Filtering data using prompts in Query - HTML To remove a prompt 8 If you want the prompt (useful when you. . . ) to display. . . then. . . the value(s) specified the last time the prompt was answered (users can select a different value(s)), often reselect the same value(s) when you refresh the document, but want the ability to select select the option: Keep a different value when last values selected necessary, such as the name of the current month almost always reselect the same value(s) when the value(s) you specify you refresh the docuas the default (users can ment, but want the ability select the option: Set deselect a different valto select a different value fault value(s) ue(s)), when necessary, such as the number for the current year prevent users from typing a list of values from which select the option: Select a value that might not exusers select a value(s), only from List ist on the database To make the prompt optional, select Optional prompt. [. . . ]