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. 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. SAP is the trademark or registered trademark of SAP AG in Germany and in several other countries. [. . . ] 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. 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. In the universe, the scope of analysis corresponds to the hierarchical levels below the object selected for a query. For example, a scope of analysis of one level down for the object Year, would include the object Quarter, which appears immediately under Year. It allows objects lower down the hierarchy to be included in the query, without them appearing in the Results Objects pane. The hierarchies in a universe allow you to choose your scope of analysis, and correspondingly the level of drill available. In the Java Report Panel and in Web Intelligence Rich Client, you can also create a custom scope of analysis by selecting specific dimensions for the Scope of Analysis pane. Note: You cannot set the scope of analysis when working in query drill mode because this drill mode causes Web Intelligence to modify the scope dynamically in response to drill actions. Levels of scope of analysis You can set the following levels for scope of analysis: Level Description Only the objects that appear in the Results Objects pane are included in the query. None 40 Building queries with Web Intelligence Query - HTML Setting the scope of analysis To set the scope of analysis in Query - HTML 5 Level Description For each object in the Result Objects pane, one, two, or three objects lower down the hierarchy tree are included in the query. The data from these objects is stored in the cube until you add them to the document. · · · One level down Two levels down Three levels down Custom Note: All objects added manually to the This option is available in the Java Scope of Analysis panel are included Report Panel and in Web Intelligence in the query. Rich Client only. Including a scope of analysis in a document increases the document size significantly. [. . . ] Click Define filter type on the right of the outline query filter and select Prompt from the list of filter operators. Edit the prompt message to form a business question, or leave the default message. Click Properties to display the "Prompt Properties" dialog box. 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. [. . . ]