Business Objects 5.1 Windows BusinessObjects 1

Business Objects 5.1 Windows BusinessObjects 1

BusinessObjects 2

BusinessObjects BusinessObjects BusinessObjects Windows95/98/NT BusinessObjects Windows BusinessObjects BusinessObjects BusinessObjects BusinessObjects BusinessObjects BusinessObjects User s Guide BusinessObjects 3

10 15 efashion BusinessObjects BusinessObjects BusinessObjects BusinessObjects 4

BusinessObject Efashion.rep Annual.rep Tutorial.rep BusinessObjects UserDocs BusinessObjects 5

2001 efashion 11 11 211 BusinessObjects 6

BusinessObjects 7

BusinessObject efashion BusinessObjects efashion Efashion.unv BusinessObjects universe BusinessObjects BusinessObjects 5.0 Universe Efashion.mdb Microsoft Access database BusinessObjects 5.0 Demo Efashion.xls Efashion.bmp Efashmd.ret Efashion.ret Efashion.rep Tutorial.rep Revenue.rep Microsoft Excel spreadsheet BusinessObjects BusinessObjects 5.0 UserDocs efashion BusinessObjects BusinessObjects 5.0 UserDocs BusinessObjects BusinessObjects BusinessObjects 5.0 Template BusinessObjects BusinessObjects BusinessObjects 5.0 UserDocs BusinessObjects InfoView BusinessObjects InfoView efashion BusinessObjects 8

1 efashion Efashion.rep, Revenue Year 2001 2 Efashion.rep, Revenue by Region 3 Efashion.rep, Margin Analysis 4 Efashion.rep, Product Analysis 5 Efashio.rep, Product Analysis 6 Efashion.rep, Actual V Budget BusinessObjects 7 BusinessObjects Revenue.rep, Sales Analysis 8 Tutorial.rep Weekly Revenue BusinessObjects 9

documentation@businessobjects.com BusinessObjects http://www.businessobjects.com BusinessObjects 10

Efashion Efashion 10 Efashion.rep Revenue Year 2001 efashion 2001 efashion BUSINESSOBJECTS universe efashion 2001 BUSINESSOBJECTS BUSINESSOBJECTS BusinessObjects 11

1 BUSINESSOBJECTS BUSINESSOBJECTS BUSINESSOBJECTS BUSINESSOBJECTS 2 BUSINESSOBJECTS BUSINESSOBJECTS BUSINESSOBJECTS BUSINESSOBJECTS 1 2 Universe BusinessObjects 12

3 Available Universes efashion a. b. c. BusinessObjects 13

1 2 Measures Sales revenue Quantity sold 2001 BusinessObjects 14

3 pre-defined 4 Time Period This Year Conditions 5 BUSINESSOBJECTS efashion BUSINESSOBJECTS BusinessObjects 15

BUSINESSOBJECTS 1 2 BUSINESSOBJECTS BUSINESSOBJECTS5.0 UserDocs.rep 1 2 BusinessObjects 16

3 1 2 1 2 3 BusinessObjects 17

Ctrl Z BUSINESSOBJECTS 1 2 Revenue for year 2001 1 BusinessObjects 18

2 3 18 4 BusinessObjects 19

5 6 7 BusinessObjects 20

1 BusinessObjects 21

2 3 4 Ctrl 5 BusinessObjects 22

1 2 3 BusinessObjects 23

4 5 1 BusinessObjects 24

2 3 BUSINESSOBJECTS Report1( Report2, Report3 ) 1 2 Revenue Year 2001 BusinessObjects 25

BUSINESSOBJECTS BusinessObjects 26

15 Efashion.rep BusinessObjects 27

efashion efashion BusinessObjects 28

BUSINESSOBJECTS 1 2001 Insert Report( ) 2 Rename Report( ) 3 Rename Report Revenue by Region( ) OK BusinessObjects 29

BUSINESSOBJECTS 1 Edit Data Provider( ) 2 Time Period ( ) Quarter Quarter Result Objects 3 Product( ) Lines( ) 4 Measures( ) Margins( ) Result Objects 6 BusinessObjects 30

5 Run BUSINESSOBJECTS Quarter Lines Margins BusinessObjects 31

BUSINESSOBJECTS BUSINESSOBJECTS BUSINESSOBJECTS Address Store BusinessObjects 32

, 1 City 2 Ctrl Lines Quarter Sales Revenue 3 Drop to create a table BusinessObjects 33

BusinessObjects 34

1 City City 2 City 3 Drop to move contents and create a section City City 11 City / BusinessObjects 35

1 2 3 Drop to turn into a crossbar Accessories in Austin in Q1 Austin Austin Q1 1 Accessories Q1 Austin Accessories Turn To Cross tab BusinessObjects 36

1 Lines Lines 2 Ranking Top Bottom 3 Top BUSINESSOBJECTS 4 Based on Sales revenue 5 OK BusinessObjects 37

1 Insert Cell button Insert Cell 2 3 4 Top Three Product Lines 1 2 3 BusinessObjects 38

Formatting Formatting 1 2 Font color 3 OK 4 Borders Borders 5 No Borders 6 Bottom Border 7 BusinessObjects 39

1 2 Copy 3 Austin 4 Paste Austin / BusinessObjects 40

1 Austin 2 Ctrl Houston Dallas Miami 3 Group Values Rename Group 4 South OK Austin Houston Dallas Miami South City+ 5 1 4 San Francisco Los Angeles BusinessObjects 41

West New York Boston Washington East Chicago Springs Midwest City+ BusinessObjects 42

1 City+ 2 Edit Variable 3 Region OK Region BusinessObjects 43

BusinessObjects 44

1 2 West West BusinessObjects 45

1 Quarter 2 Quarter Region 3 Swap cursor Drop to swap contents Region Sweat-T-Shirts BusinessObjects 46

15 Efashion.rep Margin Analysis BusinessObjects 47

BusinessObjects 48

1 2 Revenue by Region Duplicate Report Revenue by Region 1 1 3 Revenue by Region 1 4 Margin Analysis BusinessObjects 49

1 Q1 Delete 2 Yes 1 Region 2 Region 3 Drop to turn to table Lines Lines 1 BusinessObjects 50

2 Margin per City City Region 1 2 City 3 City Region 4 Region Drop to replace contents City BusinessObjects 51

Quantity sold Margin 1 2 3 Drop to insert BusinessObjects 52

1 2 Structure 3 Insert Column After 4 5 BusinessObjects 53

1 2 Edit Formula 3 BUSINESSOBJECTS 4 Margin 5 BusinessObjects 54

6 Quantity sold 7 OK efashion BusinessObjects 55

1 2 3 Margin as % rev 4 BusinessObjects 56

5 6 7 8 Margin 9 10 Sales Revenue 11 BusinessObjects 57

12 13 100 14 Margin as % rev BusinessObjects 58

1 Margin Quantity sold Margin per unit Margin as % rev 2 Margin as % rev 3 Percentage Style BusinessObjects 59

BusinessObjects 1 Margin as % rev 2 > 1 BusinessObjects 60

2 3 4 Average margin 5 Evaluate the formula in its context 6 Average margin 1 City 2 BusinessObjects 61

3 4 Above Average Margin Name BusinessObjects 62

Description 5 Conditions 6 Variable to Compare Margin as % revenue 7 Operator 1 > 8 Value 1 Variables from the menu BusinessObjects 63

9 Average margin Insert 10 Cell Content Format Cell Format 11 Conditions BusinessObjects 64

12 OK Edit Alerter 13 BusinessObjects 65

BusinessObjects 66

BusinessObjects 67

15 Efashion BusinessObjects 68

BusinessObjects 69

Margin Analysis Quarterly Variance 1 2 3 Above average margin 4 OK BusinessObjects 70

1 2 3 4 5 Drop to replace contents BusinessObjects 71

1 2 1 2 1 Q1 2 3 BusinessObjects 72

1 2 3 Q1 OK Q2 Q1 1 Q2 2 Ctrl Q1 BusinessObjects 73

3 Q2 Q2 Q1 Q3 Q4 1 Q4 2 Ctrl Q3 3 Q4 1 Q2 Q1 2 Ctrl Q4 Q3 3 4 OK BusinessObjects 74

Efashion 1 Enter 2 BusinessObjects 75

3 4 14 13 OK Efashion 1 2 Insert picture 3 BusinessObject5.0 UserDocs BusinessObjects 76

4 Efashion.bmp EFashion 1 2 No Borders BusinessObjects 77

Efashion BUSINESSOBJECTS BUSINESSOBJECTS Efashion BUSINESSOBJECTS 1 2 Publish to Corporate Documents BUSINESSOBJECTS BusinessObjects 78

3 OK BUSINESSOBJECTS the INFO VIEW User s Guide BusinessObjects 79

15 Efashion.rep Quarterly variance Product Analysis. BusinessObjects 80

1 2 3 BusinessObjects 81

efashion 1 Product Analysis Apply Template Apply a Template 2 Efashion 3 OK BusinessObjects 82

/ Efashion 1 title Product Sales by City 2 add comment for the year 2001-12-30 BUSINESSOBJECTS User s Guard BusinessObjects 83

1 2 Insert Break 4 3 4 Center Across Break BusinessObjects 84

1 Margin 2 Sum 3 4 sum 5 6 sum BusinessObjects 85

1 for year 2001 2 Austin Ctrl 3 copy Drop to copy contents 4 sales revenue BusinessObjects 86

1 2 sales revenue Ctrl 3 drop to copy contents BusinessObjects 87

BUSINESSOBJECTS BUSINESSOBJECTS BUSINESSOBJECTS BUSINESSOBJECTS BUSINESSOBJECTS User s Guide 1 City copy 2 3 Paste Format BusinessObjects 88

1 Alignment 2 3 4 Ctrl 5 Align Right BusinessObjects 89

1 2 BusinessObjects 90

2 BusinessObjects 91

1 2 Miami 3 Miami Miami Miami BusinessObjects 92

BusinessObjects BusinessObjects Universe (Query) 15 Efashion.rep, - Actual-Budget BusinessObjects BusinessObjects BusinessObjects 1 (New Data Provider) (New Data Wizard) BusinessObjects 93

2 (Access new data in a different way) 3 (Personal data File) (Access Personal Data) BusinessObjects Microsoft Excel 1 Microsoft.xls 2 BusinessObjects5.0 \ UserDocs efashion.xls 3 4 (Data Manager) BusinessObjects 94

5 (Definition) 6 Budget 7 BusinessObjects (By Data Provider) 1 2 1 Efashion 1 2 3 Actual 1 BusinessObjects 95

BusinessObjects Universe Excel 2 Actual Quarter (Define Link Between Dimensions) 3 Quarter 4 actual budget 1 Product Analysis - Actual-Budget 2 Report Manager Data Quarter Actual, Sales Revenue, Projected Sales Revenue Quantity sold, Quarter, BusinessObjects 96

3 Turn To Chart Chart AutoFormat 4 5 measure objects Sales revenue, Y dimension objects X 3 3 units Y X Y 1 Chart Format BusinessObjects 97

2 Series 3 1 Group Y 2 4 2 2 BusinessObjects 98

5 1 6 (Overlap) 50 Gap Width 100 7 Y BusinessObjects 99

/ Show/Hide Legend 1 2 1 Data Series Format BusinessObjects 100

2 3 4 5 1 Data Series Format 2 3 4 currency BusinessObjects 101

1 Y data label 2. Currency Style BusinessObjects Windows 1 Y Format Axis Label 2 Pattern 3 4 (Font) 5 6 BusinessObjects 102

1 Quarterly Variance 2 efashion 3 Actual-Budget 4 efashion Actual-Budget Quarterly Variance Actual-Budget BusinessObjects 103

BusinessObjects drill mode 15 Revenue.rep sales analysis BusinessObjects BusinessObjects (Query Panel) BusinessObjects BusinessObjects 104

Universe BusinessObjects 1 2 3 BusinessObjects UserDocs 4 Revenue.rep Sales Analysts 3 3 4 efashion 2001 T Sweat-T-Shirt 3 2000 2001 2001 1 2 Drill BusinessObjects 105

East efashion 2000 2001 2000 2000 2000 4 BusinessObjects 106

2000 2000 Q1 Q2 Q3 Q4 Q3 drill down Drill Through (Jewelry) BusinessObjects 107

Right-click to Explore 1 SKU 2 SKU BusinessObjects SKU 20% 1 SKU 2 Rank. / BusinessObjects 108

3 Top 4 In percentage of total number of values 5 20 Q1 Q2 Q3 Q4 4 Q2 1,081,320 Q3 133,725 (Send To) Mail Microsoft Outlook BusinessObjects BusinessObjects 109

8........................................................ 15 Tutorial.rep, Weekly Revenue BusinessObjects 110

Efashion query BusinessObjects 111

BusinessObjects 1 New Report Wizard 2 Select a template Begin 3 EFASHION Next 4 Universe Next 5 Universe efashion Finish 6 Result Objects BusinessObjects 112

1 Product folder Conditions section BusinessObjects 113

2 Equal to 3 Type a new prompt 4 BusinessObjects 114

1. Time folder Week Conditions section 2. Operators list Equal to 3. Operands list Type a new prompt 4. BusinessObjects 115

1. Query Panel Run Enter or Select Values 2. Which product line? Values List of Values 3. Accessories OK Accessories Enter Select Values BusinessObjects 116

4. Which week? Values List of Values 5. 6 OK 6. OK 7. < > <Title> Weekly Sales Accessories Accessories Categories BusinessObjects 117

1. Accessories 2. Report toolbar Insert Break 3. Accessories Formatting toolbar Center Across Break Sales revenue Report toolbar Sum Accessories Accessories Delete. BUSINESSOBJECTS Insert BusinessObjects 118

< > <add comment> 1. 2. 3. Insert Special Field Query Prompt List of Prompts 4. Which week? OK 1. 2. 3. 4. BusinessObjects 119

5. Insert Special Field Date and Time Last Refresh 1. Report Manager Category and Sales revenue Report 2. Turn to Chart BusinessObjects 120

3. Chart Types 3-D Pie %% labels OK 4. Report toolbar / Show Chart Legend 5. Chart Legend Hats Gloves Scarves 58% BusinessObjects 121

7 Sweaters 1. Standard toolbar Refresh 2. Sweaters 7 OK BUSINESSOBJECTS 7 Sweaters 7 BusinessObjects 122