... Foreword ... 11
... Acknowledgments ... 13
... Preface ... 15
1 ... SAP BusinessObjects Advanced Analysis, Edition for Microsoft Office -- Your New Business Explorer (BEx) Analyzer ... 19
... 1.1 ... SAP BusinessObjects Advanced Analysis, Edition for Microsoft Office -- a Short Introduction ... 19
... 1.2 ... Introduction to the Complete SAP BusinessObjects BI Client Portfolio ... 25
... 1.3 ... SAP Advanced Analysis -- One Part of the Overall BI Puzzle ... 36
... 1.4 ... User Requirements for Advanced Analysis Office ... 40
... 1.5 ... Summary ... 48
2 ... Installation, Deployment and Configuration of Advanced Analysis Office ... 49
... 2.1 ... Installation of SAP Advanced Analysis Office ... 49
... 2.2 ... Deployment Options for SAP Advanced Analysis Office ... 53
... 2.3 ... Summary ... 84
3 ... Advanced Analysis Office -- Data Connectivity and Metadata Reuse ... 85
... 3.1 ... Data Connectivity Options ... 85
... 3.2 ... Leveraging SAP NetWeaver BW Metadata ... 87
... 3.3 ... Summary ... 97
4 ... Advanced Analysis Office -- Basic Functions ... 99
... 4.1 ... Advanced Analysis Office -- Microsoft Excel ... 101
... 4.2 ... Advanced Analysis Office -- Microsoft PowerPoint ... 170
... 4.3 ... Summary ... 186
5 ... Advanced Analysis Office -- Advanced Functions ... 187
... 5.1 ... Advanced Functionality in Advanced Analysis Office for Microsoft Excel ... 187
... 5.2 ... Advanced Functionality in Advanced Analysis Office for Microsoft PowerPoint ... 247
... 5.3 ... Summary ... 253
6 ... Advanced Analysis Office and BEx Analyzer -- a Comparison ... 255
... 6.1 ... Supported Functionality ... 255
... 6.2 ... Missing Functionality ... 257
... 6.3 ... Summary and Conclusion ... 259
7 ... Advanced Analysis Office Integrated with SAP BusinessObjects Enterprise ... 261
... 7.1 ... Lifecycle Management ... 261
... 7.2 ... Object-Level and Data-Level Security ... 269
... 7.3 ... Sharing of Common Objects ... 271
... 7.4 ... User Authentication and SSO ... 278
... 7.5 ... Integration with InfoView ... 280
... 7.6 ... Summary ... 283
8 ... Advanced Analysis Office -- Usage Scenarios ... 285
... 8.1 ... Advanced Analysis Office and Customer Support ... 285
... 8.2 ... Advanced Analysis Office and Product Profitability ... 296
... 8.3 ... Advanced Analysis Office and Sales Planning ... 307
... 8.4 ... Advanced Analysis Office and Procurement ... 315
... 8.5 ... Summary ... 321
9 ... Advanced Analysis -- Product Outlook ... 323
... 9.1 ... Advanced Analysis, Edition for Microsoft Office ... 323
... 9.2 ... Advanced Analysis, Web Edition ... 326
... 9.3 ... Integration with SAP BusinessObjects XI 4.0 ... 330
... 9.4 ... Beyond SAP BusinessObjects XI 4.0 ... 332
... 9.5 ... Summary ... 334
... The Author ... 335
... Index ... 337