User manual BUSINESS OBJECTS DESKTOP INTELLIGENCE ACCESS AND ANALYSIS GUIDE

[. . . ] Desktop_Intelligence_Access_and_Analysis_Guide Desktop_Intelligence_Access_and_Analysis_Guide Copyright © 2007 Business Objects. patents, which may cover products that are offered and licensed by Business Objects: 5, 555, 403; 6, 247, 008; 6, 289, 352; 6, 490, 593; 6, 578, 027; 6, 768, 986; 6, 772, 409; 6, 831, 668; 6, 882, 998 and 7, 139, 766. Business Objects and the Business Objects logo, BusinessObjects, Crystal Reports, Crystal Xcelsius, Crystal Decisions, Intelligent Question, Desktop Intelligence, Crystal Enterprise, Crystal Analysis, Web Intelligence, RapidMarts, and BusinessQuery are trademarks or registered trademarks of Business Objects in the United States and/or other countries. All other names mentioned herein may be trademarks of their respective owners. [. . . ] In this case, the alerter appears on the printed report, but no longer appears on your screen. To turn an alerter on 1. Click Apply or OK. To display or hide all alerters in the current report You can also display or hide all alerters that you have applied to the current report. Click Alerters under Report Options. Desktop_Intelligence_Access_and_Analysis_Guide 171 10 Filtering and Ranking Data Highlighting data If this option is already checked and you want to hide the alerters in your report, click it again to remove the check. Click OK to apply the option and to close the dialog box. Working with existing alerters Once you have created an alerter, you can use it as the basis for other new alerters. You copy the existing alerter, then modify its conditions and their corresponding formats. Copy an alerter 1. In the Definition tab, the name of the initial alerter appears in the Name box followed by no2. If you renamed your first alerter so its name is not the same as the variable name Desktop Intelligence gives the new alerter the variable name. In the Conditions tab, define the first range of values for the alerter. Repeat Step 5 and Step 6 to define a second range of values if you wish, then click Apply or OK. To edit an alerter 1. Click Apply or OK. 172 Desktop_Intelligence_Access_and_Analysis_Guide Filtering and Ranking Data Highlighting data 10 To delete an alerter 1. Click Remove. Desktop_Intelligence_Access_and_Analysis_Guide 173 10 Filtering and Ranking Data Highlighting data 174 Desktop_Intelligence_Access_and_Analysis_Guide Customizing Queries on Universes 11 11 Customizing Queries on Universes Overview Overview This chapter describes how to benefit from the most powerful query features in Desktop Intelligence. You learn how to · · · · · · create your own objects apply complex conditions work with multiple conditions combine the results of multiple queries into one data set view, edit and reuse the SQL generated by Desktop Intelligence queries use one query as input to another Creating user objects 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 create your own additional user objects. You include them in queries in the same way that you include regular objects. You do not need to define a connection to a database to define a user object. Why create a user object? Based on one or more existing objects, user objects enable you to: · · · make additional calculations beyond those provided by the base universe objects. group data. Here's an example of a user object. 176 Desktop_Intelligence_Access_and_Analysis_Guide Customizing Queries on Universes Creating user objects 11 Example: Obtaining total ordered revenue by creating a user object To obtain the revenue generated by an order, you create the Total user object with the following formula: =Quantity Ordered*Product Price where Quantity Ordered and Product Price are objects in your universe. When you include the Total user object in a query, Desktop Intelligence makes the calculation and places the results in the report. What does a user object consist of? A user object has a name, a type (character, date or numeric), a qualification (dimension, measure or detail) and a formula. The formula contains a combination of functions, objects, user objects, operators, and text. User objects are end-user personal objects that are not shared with other end-users. User objects are defined for each universe and stored on a local file inside the "\Universe" folder. For example, if you create a user object in the BEACH. UNV universe, Desktop Intelligence stores it locally in the file BEACH. UDO in the Universe folder. What are the restrictions on user objects? You can work only with the user objects that you create yourself, and you cannot move user objects from the User Objects class. Also, user objects are available only in the universe in which they were created. [. . . ] The script is converted. 322 Desktop_Intelligence_Access_and_Analysis_Guide Desktop Intelligence and Visual Basic for Applications Using the Visual Basic editor 18 Note: The macro may sometimes need some slight tweaking in the Visual Basic Editor after conversion to get it to work correctly. For information on how to do this, see the Customizing Desktop Intelligence guide. Using the Visual Basic editor You can open the Visual Basic Editor directly from Desktop Intelligence to create macros and programs to use in Desktop Intelligence. This development environment has its own set of online Help files. To open the Visual Basic Editor 1. Programming in Visual Basic requires knowledge of the programming environment. [. . . ]