* Explains what Advanced Analysis is and how it can benefit users * Details how to deploy the tool and connect it with SAP and non-SAP data * Uses real-world scenarios to show how the tool can satisfy financial, HR, CRM, and retail analysis requirements This is the definitive source for information on SAP BusinessObjects Advanced Analysis, Microsoft Office edition, and provides you with a comprehensive functional overview, installation/deployment scenarios, data connectivity guidance, and basic/advanced usage scenarios. Learn about the details of the upcoming release of Advanced Analysis, Web edition, and integration with the upcoming release of SAP BusinessObjects XI 4.0. Installation, Deployment, and Configuration Learn about the necessary steps to install, deploy, and configure Advanced Analysis Office as part of your overall business intelligence (BI) landscape. Data Connectivity and Metadata Reuse Explore the options for connecting to your SAP and non-SAP corporate data using Advanced Analysis Office. Compare Advanced Analysis Office and BEx Analyzer Learn why Advanced Analysis is quickly becoming the new Business Explorer (BEx) Analyzer and how the two products match-up. Integration with SAP BusinessObjects Enterprise Find out how Advanced Analysis Office integrates with SAP BusinessObjects Enterprise and what the benefits from this integration are. Usage Scenarios Leverage practical examples that show you how to use the features and functions of Advanced Analysis Office to provide end-users with greater usability and the correct information.
| ISBN | 1592293719 | | DEWEY | 658.40380285 | | ISBN13 | 9781592293711
(What's this?) | | DEWEY edition | DC21 | | Publisher | SAP Press | | Pages | 342 | | Imprint | SAP Press | | Published in | Maryland | | Format | Hardback | | Academic level | General | | Publication date | 30 Nov 2010 | |
|
|
|
* ... Foreword ... 11 * ... Acknowledgments ... 13 * ... Preface ... 15 * 1 ... SAP Business-Objects Advanced Analysis, Edition for Microsoft Office Your New Business Explorer (BEx) Analyzer ... 19 * 1.1 ... SAP Business-Objects Advanced Analysis, Edition for Microsoft Office a Short Introduction ... 19 * 1.1.1 ... A Brief Introduction to Voyager ... 20 * 1.1.2 ... A Brief Introduction to SAP BEx ... 21 * 1.1.3 ... Pioneer Combining Voyager and SAP BEx ... 23 * 1.2 ... Introduction to the Complete SAP Business-Objects BI Client Portfolio ... 25 * 1.2.1 ... Enterprise Reporting ... 27 * 1.2.2 ... Ad Hoc Query and Reporting ... 29 * 1.2.3 ... Advanced Analysis ... 31 * 1.2.4 ... Dashboarding and Data Visualization ... 33 * 1.2.5 ... Search, Discovery, and Exploration ... 34 * 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.1.1 ... Technical Prerequisites ... 49 * 2.2 ... Deployment Options for SAP Advanced Analysis Office ... 53 * 2.2.1 ... Advanced Analysis Office Architecture ... 54 * 2.2.2 ... Deploying Advanced Analysis without SAP Business-Objects Enterprise ... 55 * 2.2.3 ... Deploying Advanced Analysis Combined with SAP Business-Objects Enterprise ... 56 * 2.2.4 ... Summary and Conclusions ... 58 * 2.2.5 ... Setting Up Connections in SAP Business-Objects Enterprise ... 62 * 2.2.6 ... Configuring Microsoft Excel and Microsoft PowerPoint Settings ... 66 * 2.2.7 ... Configuring Connections to SAP Business-Objects Enterprise ... 68 * 2.2.8 ... Enabling or Disabling Advanced Analysis Office Plug-In ... 73 * 2.2.9 ... Multi-Lingual Behavior of Advanced Analysis Office ... 75 * 2.2.10 ... Setting Up User Authorizations and Rights ... 76 * 2.2.11 ... User Authentication ... 83 * 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.2.1 ... BEx Query versus InfoProvider ... 95 * 3.3 ... Summary ... 97 * 4 ... Advanced Analysis Office Basic Functions ... 99 * 4.1 ... Advanced Analysis Office Microsoft Excel ... 101 * 4.1.1 ... Establishing Data Connectivity ... 102 * 4.1.2 ... Open and Saving Workbooks ... 110 * 4.1.3 ... Insert Your First Crosstab ... 111 * 4.1.4 ... Navigation Options ... 114 * 4.1.5 ... Formatting Data ... 121 * 4.1.6 ... Sorting and Filtering ... 126 * 4.1.7 ... Charting ... 140 * 4.1.8 ... Conditional Formatting ... 142 * 4.1.9 ... Ranking, Conditions, and Filter by Measures ... 152 * 4.1.10 ... Totals and Subtotals ... 161 * 4.1.11 ... Prompting and Variables ... 164 * 4.1.12 ... Displaying Information about the Data ... 167 * 4.2 ... Advanced Analysis Office Microsoft PowerPoint ... 170 * 4.2.1 ... Advanced Analysis Office Microsoft Excel versus Microsoft PowerPoint ... 173 * 4.2.2 ... Advanced Analysis Office for Microsoft PowerPoint Basic Steps ... 174 * 4.3 ... Summary ... 186 * 5 ... Advanced Analysis Office Advanced Functions ... 187 * 5.1 ... Advanced Functionality in Advanced Analysis Office for Microsoft Excel ... 187 * 5.1.1 ... Using Hierarchies ... 187 * 5.1.2 ... Displaying Characteristics as Hierarchy ... 203 * 5.1.3 ... Creating Calculations ... 206 * 5.1.4 ... Using Data as a Formula ... 211 * 5.1.5 ... Adding a Filter Panel ... 228 * 5.1.6 ... Creating a Microsoft PowerPoint Slide ... 230 * 5.1.7 ... Using Additional Information and Settings ... 234 * 5.1.8 ... Working with Styles ... 242
Enlarge
