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. [. . . ] It shows the combined revenue for September, January and March (Sum) and the total revenue for the other nine months of the year (Sum Other). Tip: To remove the ranking, click inside the ranked data, then click Apply Ranking. Editing an existing ranking Once you have defined a ranking by specifying the ranking values you want to display, you can edit it by selecting different ranking values. For example, if you have applied a ranking that enables you to view the top and bottom 3 ranking of revenue for customers, you can edit the ranking to show the top 10 instead. To select different values for an existing ranking: 1. Click inside the data where the ranking was applied. The Select Top/Bottom Variable Name dialog box appears, with the current ranking options selected. Alter the ranking settings as desired, then click OK (or Apply). When you exit from the Dialog box, the values with the new ranking criteria are displayed. Removing a ranking When you remove a ranking, all the data that it excluded re-appears in the report. For example, if you applied a ranking that displays the top 10 customers by revenue, then you remove that ranking, the report displays the revenue for all customers. Desktop Intelligence User's Guide: Data Access and Analysis 209 10 Filtering and Ranking Data Hiding columns and rows of data To remove a ranking, first click inside the data on which you applied the ranking. Click the dimmed Apply Ranking button on the Report toolbar. Apply Ranking 2. 4. Click Ranking on the Format menu, Remove the Top and Bottom check marks, Click OK or Apply. Managing ranking with filters and sorts To rank data in a report, you must remove any sorts or filters currently applied to that data. If any sorts or filters exist when you try to apply a ranking, Desktop Intelligence displays the following message: Click Yes to remove the existing sort or filter. Hiding columns and rows of data You can hide columns or rows of data so that the data is not displayed in your table but still remains in the report. Right-click inside the table or crosstab. Click Table or Crosstab on the Format menu. 210 Desktop Intelligence User's Guide: Data Access and Analysis Filtering and Ranking Data Hiding columns and rows of data 10 3. Click the Pivot tab in the dialog box that appears. Hiding Data · · In the Used Variables box, click the variable you want to hide, then click Hide. To hide more than one variable at the same time, hold down the Ctrl key, click the variables, then click Hide. Hidden variables are grayed in the Used Variables box. Note: When you hide a dimension, Desktop Intelligence does not recalculate measures. Hiding a dimension is not the same as removing it from a report. Showing data · To display a previously hidden variable, click it in the Used Variables list, then click Show. Desktop Intelligence User's Guide: Data Access and Analysis 211 10 Filtering and Ranking Data Highlighting data Highlighting data You can highlight data in a Desktop Intelligence report using alerters. Alerters use special formatting to make data that fits certain conditions stand out from the rest of the data. This helps draw attention to trends and exceptions in report data. Example: Which sales representatives generate revenue over $500 000 You want to identify excellent salespeople who generate revenue over $500 000, and poor salespeople who generate revenue below $50 000. You define a condition for your good salespeople: "Revenue >= 500000" and define a format that will be applied for values that fit this condition: "Good job!" in green. You then define a condition for your not-so-good salespeople: "Revenue <= 50000". and define a format that will be applied for values that fit this condition: "Work harder!" in red. [. . . ] displays the syntax for Desktop Intelligence command line -offline -blind -nologo -document <documentname> -help Desktop Intelligence User's Guide: Data Access and Analysis 379 C Command-Line Options for Desktop Intelligence Error messages Help Message busobj . exe [-user <username> [-pass <password] . . . . . . . . . . . . . . . . . . [-system <systemname>] . . . . . . . . . . . . . . . . . . [-auth "enterprise" | "ldap" | "ad" | "nt" . . . . . . . . . . . . . . . . . . [-offline | -online . . . . . . . . . . . . . . . . . . [-blind] . . . . . . . . . . . . . [-nologo] [-document <documentname>] [-help] Error messages Error Message The syntax of the command is incorrect. Comment Error in the syntax of the command-line. If the user uses -pass, -system, -auth, -offline, online, -blind, options without -user. -offline and -online options There is only one possible mode. Invalid User name in To us offline mode, the user must have logged in Offline Mode. [. . . ]