{"id":3212,"date":"2017-05-24T15:12:35","date_gmt":"2017-05-24T14:12:35","guid":{"rendered":"http:\/\/www.hackingsap.com\/blog\/?p=3212"},"modified":"2017-05-24T15:27:06","modified_gmt":"2017-05-24T14:27:06","slug":"book-review-sap-businessobjects-analysis-office-the-comprehensive-guide","status":"publish","type":"post","link":"https:\/\/www.hackingsap.com\/blog\/book-review-sap-businessobjects-analysis-office-the-comprehensive-guide","title":{"rendered":"Book review: SAP BusinessObjects Analysis Office – The Comprehensive Guide"},"content":{"rendered":"

With all the buzz around the big upcoming Lumira 2 release, you would almost forget that there are other SAP BI tools in the market as well. For example Analysis for Office: the successor of the good old BEx Analyzer. For some reason these tools have\u00a0never been a very popular topic to write about. This is somewhat strange, as\u00a0Analysis for Office, and even BEx Analyzer, are still extremely popular under SAP BI customers and therefor widely used besides the \u2019newer\u2019 front-end tools.<\/p>\n

Analysis for Office\u00a0is not a difficult tool to learn, but it has a lot of hidden, unknown and\u00a0even misunderstood features that are very useful for data analysts. My head still explodes when I see somebody using Analysis for Office to \u2018download\u2019 all the data into Excel, manually copy\/paste the results to different tabs, and starts applying Excel filters, sorting etc. So there is absolutely a need for guidance here.<\/p>\n

Luckily,\u00a0Tobias Meyer<\/a> published SAP BusinessObjects Analysis Office – The Comprehensive Guide<\/strong> last year on version 2.3, and this year an updated version on Analysis for Office 2.4. The book covers all the features that Analysis for Office (both the Excel and PowerPoint versions) offers in detail, but goes a lot further than that. Ever heard about Shortcut properties for the Analysis for Office add-on launcher?<\/p>\n

\"afobook\"<\/p>\n

So, as all features are nicely listed and explained in detail, I use this book as a reference guide in case I need to know the details behind a feature or to look for some useful configuration file tweak, like how to change the default user settings for a new software rollout. Or, I use it to learn about areas I haven\u2019t worked a lot in, like the Integrated Planning features.<\/p>\n

The book covers a lot of information about SAP Excel formulas (20 pages) and how to use VBA (58 pages, including some example use case results). This is extremely useful if you want to go this way with the tool. Of course I\u2019m personally not a big fan of creating such advanced BI applications in Analysis for Office\/Excel, as I prefer Design Studio (Lumira 2) for these cases.<\/p>\n

The book seems to be aimed at intermediate\/advanced users. Obviously a lot of SAP BI lingo is used from the start of the book, so it might be hard for new users to follow. I always like it when a book on a software tool has a guided\/step-by-step \u2018beginner\u2019 chapter, that does a short walkthrough of the basics of the tool. Insert a query, add a dimension, set a filter, that kind of stuff. Maybe something for a next release.\u00a0?<\/p>\n

So to conclude, this is an excellent collection of Analysis for Office knowledge material for any Analysis for Office or BEx Analyzer user who wants to up his game. More info on the book on reyemsaibot.com<\/a>.<\/p>\n","protected":false},"excerpt":{"rendered":"

With all the buzz around the big upcoming Lumira 2 release, you would almost forget that there are other SAP BI tools in the market as well. For example Analysis for Office: the successor of the good old BEx Analyzer. For some reason these tools have\u00a0never been a very popular topic to write about. This […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[304,34],"tags":[],"class_list":["post-3212","post","type-post","status-publish","format-standard","hentry","category-analysis-for-office","category-books"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_shortlink":"https:\/\/wp.me\/pKaa2-PO","jetpack-related-posts":[{"id":937,"url":"https:\/\/www.hackingsap.com\/blog\/sap-bex-analyzer-sucks","url_meta":{"origin":3212,"position":0},"title":"SAP: “BEx Analyzer sucks”","author":"Xavier Hacking","date":"November 17, 2010","format":false,"excerpt":"SAP released a video that basically says that BEx Analyzer sucks. And it's true.","rel":"","context":"In "SAP"","block_context":{"text":"SAP","link":"https:\/\/www.hackingsap.com\/blog\/category\/sap"},"img":{"alt_text":"SAP BEx Sucks, SAP BusinessObjects Analysis rules","src":"https:\/\/i0.wp.com\/www.hackingsap.com\/blog\/wp-content\/uploads\/sapbex.png?resize=350%2C200&ssl=1","width":350,"height":200},"classes":[]},{"id":2144,"url":"https:\/\/www.hackingsap.com\/blog\/book-review-mastering-sap-businessobjects-analysis-edition-for-olap-with-sap-netweaver-bw","url_meta":{"origin":3212,"position":1},"title":"Book review: Mastering SAP BusinessObjects Analysis, edition for OLAP with SAP NetWeaver BW","author":"Xavier Hacking","date":"March 29, 2013","format":false,"excerpt":"SAP BusinessObjects Analysis, edition for OLAP is probably the BI4 tool I have spent the least time in yet. It can be seen as the successor to the BEx Web Analyzer and it is the web counterpart of SAP BusinessObjects Analysis, edition for Office. For my projects this might be\u2026","rel":"","context":"In "Books"","block_context":{"text":"Books","link":"https:\/\/www.hackingsap.com\/blog\/category\/books"},"img":{"alt_text":"hilgefortanalysisolap1","src":"https:\/\/i0.wp.com\/www.hackingsap.com\/blog\/wp-content\/uploads\/hilgefortanalysisolap1-300x300.jpg?resize=350%2C200","width":350,"height":200},"classes":[]},{"id":3604,"url":"https:\/\/www.hackingsap.com\/blog\/video-sap-analytics-cloud-data-analyzer-update-2021-22","url_meta":{"origin":3212,"position":2},"title":"Video: SAP Analytics Cloud Data Analyzer Update [2021.22]","author":"Xavier Hacking","date":"November 10, 2021","format":false,"excerpt":"The SAC Data Analyzer is an ad-hoc analysis tool built-in the SAP Analytics Cloud platform, which works in a similar way as the classic BEx Web or the Analysis for Office plugin for Excel. For some unknown reason you could only access the Data Analyzer via a specific URL; not\u2026","rel":"","context":"In "SAP Analytics Cloud"","block_context":{"text":"SAP Analytics Cloud","link":"https:\/\/www.hackingsap.com\/blog\/category\/sap-analytics-cloud"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/img.youtube.com\/vi\/G-cWgRaFm2A\/0.jpg?resize=350%2C200","width":350,"height":200},"classes":[]},{"id":1851,"url":"https:\/\/www.hackingsap.com\/blog\/book-review-sap-netweaver-bw-and-sap-businessobjects-the-comprehensive-guide","url_meta":{"origin":3212,"position":3},"title":"Book review: SAP NetWeaver BW and SAP BusinessObjects – The Comprehensive Guide","author":"Xavier Hacking","date":"September 15, 2012","format":false,"excerpt":"Let's have a look at another SAP BI book that SAP Press released this year. They are on a great streak and later this year we can expect even more releases from them on HANA, Web Intelligence, ABAP for BW, SAP BusinessObjects Administration and Security. But, let's go back to\u2026","rel":"","context":"In "Books"","block_context":{"text":"Books","link":"https:\/\/www.hackingsap.com\/blog\/category\/books"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/www.hackingsap.com\/blog\/wp-content\/uploads\/sapbwbocomprehensiveguide.png?resize=350%2C200","width":350,"height":200},"classes":[]},{"id":3166,"url":"https:\/\/www.hackingsap.com\/blog\/design-studio-1-x-and-hierarchies-not-assigned-node-filtering","url_meta":{"origin":3212,"position":4},"title":"Design Studio 1.x and hierarchies: Not Assigned node filtering","author":"Xavier Hacking","date":"January 29, 2017","format":false,"excerpt":"In BW hierarchies, the values that are not assigned to a hierarchy node are gathered\u00a0under the Not Assigned node. The query output shows this node in the hierarchy on the same level as the top node of the hierarchy. This works the same for all SAP front-end tools that support\u2026","rel":"","context":"In "Featured"","block_context":{"text":"Featured","link":"https:\/\/www.hackingsap.com\/blog\/category\/featured"},"img":{"alt_text":"Web Analyzer Not Assigned","src":"https:\/\/i0.wp.com\/www.hackingsap.com\/blog\/wp-content\/uploads\/Web-Analyzer-Not-Assigned.png?resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/www.hackingsap.com\/blog\/wp-content\/uploads\/Web-Analyzer-Not-Assigned.png?resize=350%2C200 1x, https:\/\/i0.wp.com\/www.hackingsap.com\/blog\/wp-content\/uploads\/Web-Analyzer-Not-Assigned.png?resize=525%2C300 1.5x"},"classes":[]},{"id":3508,"url":"https:\/\/www.hackingsap.com\/blog\/video-sap-analytics-cloud-data-analyzer-2019-14","url_meta":{"origin":3212,"position":5},"title":"Video: SAP Analytics Cloud Data Analyzer [2019.14]","author":"Xavier Hacking","date":"July 21, 2019","format":false,"excerpt":"SAP Analytics Cloud version 2019.14 introduces a new cool feature: the Data\u00a0Analyzer. With the Data Analyzer we can instantly report on BEx Queries in SAP Analytics Cloud, without having to create a model first (don't panic, HANA views are also on the roadmap). For those who have used the Lumira\u2026","rel":"","context":"In "SAP Analytics Cloud"","block_context":{"text":"SAP Analytics Cloud","link":"https:\/\/www.hackingsap.com\/blog\/category\/sap-analytics-cloud"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/img.youtube.com\/vi\/q_UtfZYqqhg\/0.jpg?resize=350%2C200","width":350,"height":200},"classes":[]}],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/www.hackingsap.com\/blog\/wp-json\/wp\/v2\/posts\/3212","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.hackingsap.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.hackingsap.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.hackingsap.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.hackingsap.com\/blog\/wp-json\/wp\/v2\/comments?post=3212"}],"version-history":[{"count":5,"href":"https:\/\/www.hackingsap.com\/blog\/wp-json\/wp\/v2\/posts\/3212\/revisions"}],"predecessor-version":[{"id":3218,"href":"https:\/\/www.hackingsap.com\/blog\/wp-json\/wp\/v2\/posts\/3212\/revisions\/3218"}],"wp:attachment":[{"href":"https:\/\/www.hackingsap.com\/blog\/wp-json\/wp\/v2\/media?parent=3212"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.hackingsap.com\/blog\/wp-json\/wp\/v2\/categories?post=3212"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.hackingsap.com\/blog\/wp-json\/wp\/v2\/tags?post=3212"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}