User manual BUSINESS OBJECTS DESKTOP INTELLIGENCE XI RELEASE 2 DATA ACCESS AND ANALYSIS FOR WINDOWS

[. . . ] Desktop Intelligence User's Guide: Data Access and Analysis Desktop Intelligence XI Release 2 Windows Patents Business Objects owns the following U. S. 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. [. . . ] 4. Type a value (number, character or date), or Click the down arrow button to the right of the Value 1 box, then click Variables or List of Values. Select a variable or a value. If operator 1 requires the use of a second operator, click the operator to use in the Operator 2 box. Click inside the Value 2 box and repeat step 2. Step 4: Set the formatting Specify different formats for each range, using fonts, colors and borders, for example. Or you can enter a text or select a variable that will mask the data that satisfies the conditions you set. Click OK to return to the Edit Alerters dialog box. Switching alerters off and on Once you have created alerters, you can apply or deactivate them whenever you like. For example, you can create an alerter, apply it to a report, print the report, then deactivate the alerter. In this case, the alerter appears on the printed report, but no longer appears on your screen. Turn an alerter on 1. Click the cell, column or row where the alerter is displayed. 214 Desktop Intelligence User's Guide: Data Access and Analysis Filtering and Ranking Data Highlighting data 10 2. Click Alerters on the Format menu. 3. 4. Click the check box next to the alerter that you want to deactivate. Click Apply or OK. 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. 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. Desktop Intelligence User's Guide: Data Access and Analysis 215 10 Filtering and Ranking Data Highlighting data 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. Edit an alerter 1. Click Remove. 216 Desktop Intelligence User's Guide: Data Access and Analysis Customizing Queries on Universes chapter 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. [. . . ] Note: Command-Line options are available only on Windows. Syntax The desktop Intelligence binary is located in: $INSTALLDIR\BusinessObjects Enterprise 11. 5win32_x86 Where $INSTALLDDIR is the installation directory. Here is the syntax: busobj . exe [-user <username> [-pass <password] . . . . . . . . . . . . . . . . . . [-system <systemname>] . . . . . . . . . . . . . . . . . . [-auth "enterprise" | "ldap" | "ad" | "nt" . . . . . . . . . . . . . . . . . . [-offline | -online . . . . . . . . . . . . . . . . . . [-blind] . . . . . . . . . . . . . . . . . . [-nologo] [-document <documentname>] Options Options -user <username -pass <password> -system <systemname> Description User name is used to log into Desktop Intelligence Password is used to log into Desktop Intelligence System name is where the user is authenticated 378 Desktop Intelligence User's Guide: Data Access and Analysis Command-Line Options for Desktop Intelligence Options C Options -auth Description Authorization mode is used to authenticate the user. Possible values are: · · · · -online "enterprise" for Enterprise "ldap" for for LDAP "ad" for Active Directory "nt" for Windows Authentication The Default value is "enterprise" Start Desktop Intelligence in online mode. Desktop Intelligence starts, opens/refreshes a document or runs a script then exits, without displaying the user interface. [. . . ]