{"id":937,"date":"2010-11-17T22:19:38","date_gmt":"2010-11-17T21:19:38","guid":{"rendered":"http:\/\/www.hackingsap.com\/blog\/?p=937"},"modified":"2010-11-18T09:36:14","modified_gmt":"2010-11-18T08:36:14","slug":"sap-bex-analyzer-sucks","status":"publish","type":"post","link":"https:\/\/www.hackingsap.com\/blog\/sap-bex-analyzer-sucks","title":{"rendered":"SAP: &#8220;BEx Analyzer sucks&#8221;"},"content":{"rendered":"<p>When I first got into SAP BI a few years ago I followed this course on SAP BW 3.5 which took like 10 days or maybe even more. I do remember the first time I saw and used <strong>BEx Analyzer<\/strong>, the MS Excel plugin to view and analyze data from SAP BW. I was just shocked to see such a terrible user interface design and a tool that was not intuitive to use at all! And people were supposed to use this app for their daily work? OMG.<\/p>\n<p>SAP now released a video that basically says that BEx Analyzer sucks. Too complex, too much end-user training needed, to much complaints, too expensive and so on. The solution? <strong>SAP BusinessObjects Analysis edition for Microsoft Office<\/strong>.<\/p>\n<p>Have fun watching it.<\/p>\n<p><span class=\"embed-youtube\" style=\"text-align:center; display: block;\"><iframe loading=\"lazy\" class=\"youtube-player\" width=\"640\" height=\"360\" src=\"https:\/\/www.youtube.com\/embed\/tukmHIERq3M?version=3&#038;rel=1&#038;showsearch=0&#038;showinfo=1&#038;iv_load_policy=1&#038;fs=1&#038;hl=en-US&#038;autohide=2&#038;hd=1&#038;wmode=transparent\" allowfullscreen=\"true\" style=\"border:0;\" sandbox=\"allow-scripts allow-same-origin allow-popups allow-presentation allow-popups-to-escape-sandbox\"><\/iframe><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>SAP released a video that basically says that BEx Analyzer sucks. And it&#8217;s true.<\/p>\n","protected":false},"author":1,"featured_media":939,"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":[4,9],"tags":[115,11,45,283],"class_list":["post-937","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-sap","category-sapbusinessobjects","tag-bex","tag-businessobjects","tag-bw","tag-sap"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"https:\/\/www.hackingsap.com\/blog\/wp-content\/uploads\/sapbex.png","jetpack_shortlink":"https:\/\/wp.me\/pKaa2-f7","jetpack-related-posts":[{"id":2144,"url":"https:\/\/www.hackingsap.com\/blog\/book-review-mastering-sap-businessobjects-analysis-edition-for-olap-with-sap-netweaver-bw","url_meta":{"origin":937,"position":0},"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 &quot;Books&quot;","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":1851,"url":"https:\/\/www.hackingsap.com\/blog\/book-review-sap-netweaver-bw-and-sap-businessobjects-the-comprehensive-guide","url_meta":{"origin":937,"position":1},"title":"Book review: SAP NetWeaver BW and SAP BusinessObjects &#8211; 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 &quot;Books&quot;","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":937,"position":2},"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 &quot;Featured&quot;","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":2192,"url":"https:\/\/www.hackingsap.com\/blog\/sap-design-studio-and-conditions","url_meta":{"origin":937,"position":3},"title":"SAP Design Studio and Conditions","author":"Xavier Hacking","date":"June 8, 2013","format":false,"excerpt":"I got an email this week by Ado A. from Atlanta, GA about an issue he has with SAP BusinessObjects Design Studio. He is trying to filter a set of data in Top N categories, for example to get the 10 regions with the highest sales numbers (Top 10). Unfortunately,\u2026","rel":"","context":"In &quot;Knowledge sharing&quot;","block_context":{"text":"Knowledge sharing","link":"https:\/\/www.hackingsap.com\/blog\/category\/knowledge-sharing"},"img":{"alt_text":"DScond1","src":"https:\/\/i0.wp.com\/www.hackingsap.com\/blog\/wp-content\/uploads\/DScond1.png?resize=350%2C200","width":350,"height":200},"classes":[]},{"id":430,"url":"https:\/\/www.hackingsap.com\/blog\/xcelsiussap-bw-direct-connection","url_meta":{"origin":937,"position":4},"title":"Xcelsius\/SAP BW direct connection HTG","author":"Xavier Hacking","date":"February 23, 2010","format":false,"excerpt":"SAP how-to guide on direct connection between Xcelsius and SAP BW now available.","rel":"","context":"In &quot;Knowledge sharing&quot;","block_context":{"text":"Knowledge sharing","link":"https:\/\/www.hackingsap.com\/blog\/category\/knowledge-sharing"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":2092,"url":"https:\/\/www.hackingsap.com\/blog\/errors-after-promoting-bi4-reports-with-bex-query-data-sources-crystal-reports-web-intelligence","url_meta":{"origin":937,"position":5},"title":"Errors after promoting BI4 reports with BEx query data sources","author":"Xavier Hacking","date":"January 28, 2013","format":false,"excerpt":"Transporting (or promoting) objects in the SAP BusinessObjects BI4 environment is still a bit weird for those (like me) originally coming from the SAP BW world. The Lifecycle Manager (LCM) webapp somehow doesn\u2019t feel as robust as the Transport Management System in SAP, but in the end of it course\u2026","rel":"","context":"In &quot;Knowledge sharing&quot;","block_context":{"text":"Knowledge sharing","link":"https:\/\/www.hackingsap.com\/blog\/category\/knowledge-sharing"},"img":{"alt_text":"webi_change_datasource_1","src":"https:\/\/i0.wp.com\/www.hackingsap.com\/blog\/wp-content\/uploads\/webi_change_datasource_1.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\/937","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=937"}],"version-history":[{"count":3,"href":"https:\/\/www.hackingsap.com\/blog\/wp-json\/wp\/v2\/posts\/937\/revisions"}],"predecessor-version":[{"id":942,"href":"https:\/\/www.hackingsap.com\/blog\/wp-json\/wp\/v2\/posts\/937\/revisions\/942"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.hackingsap.com\/blog\/wp-json\/wp\/v2\/media\/939"}],"wp:attachment":[{"href":"https:\/\/www.hackingsap.com\/blog\/wp-json\/wp\/v2\/media?parent=937"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.hackingsap.com\/blog\/wp-json\/wp\/v2\/categories?post=937"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.hackingsap.com\/blog\/wp-json\/wp\/v2\/tags?post=937"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}