{"id":3308,"date":"2018-01-12T20:47:21","date_gmt":"2018-01-12T19:47:21","guid":{"rendered":"http:\/\/www.hackingsap.com\/blog\/?p=3308"},"modified":"2018-01-12T20:47:21","modified_gmt":"2018-01-12T19:47:21","slug":"how-to-use-sap-analysis-office-with-sap-analytics-cloud","status":"publish","type":"post","link":"https:\/\/www.hackingsap.com\/blog\/how-to-use-sap-analysis-office-with-sap-analytics-cloud","title":{"rendered":"How to use SAP Analysis Office with SAP Analytics Cloud"},"content":{"rendered":"<p>In the below video I give a quick run-through of how the use <strong>SAP Analysis Office<\/strong> in combination with\u00a0<strong>SAP Analytics Cloud<\/strong>. Not only can we use\u00a0SAP Analytics Cloud models as a data source in SAP Analysis\u00a0Office, we can also store the workbooks on\u00a0SAP Analytics Cloud. Even better, we can open them from there, and make SAP Analysis Office refresh them for us without having to enter user credentials again! As you&#8217;ll see, the current integration is still very basic, but hey, we&#8217;re getting there. In the video I&#8217;m using SAP\u00a0Analysis Office 2.6, but it should also work with version 2.5.<\/p>\n<p>Scenario:<\/p>\n<ol>\n<li>Create Analysis Office Workbook with SAP Analytics Cloud Model as a data source.<\/li>\n<li>Store Analysis Office Workbook on SAP Analytics Cloud.<\/li>\n<li>Open Analysis Office Workbook from SAP Analytics Cloud.<\/li>\n<\/ol>\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\/rp7kdGAfLJE?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;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>In the below video I give a quick run-through of how the use SAP Analysis Office in combination with\u00a0SAP Analytics Cloud. Not only can we use\u00a0SAP Analytics Cloud models as a data source in SAP Analysis\u00a0Office, we can also store the workbooks on\u00a0SAP Analytics Cloud. Even better, we can open them from there, and make [&hellip;]<\/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,299],"tags":[],"class_list":["post-3308","post","type-post","status-publish","format-standard","hentry","category-analysis-for-office","category-sap-analytics-cloud"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_shortlink":"https:\/\/wp.me\/pKaa2-Rm","jetpack-related-posts":[{"id":3530,"url":"https:\/\/www.hackingsap.com\/blog\/sap-analytics-cloud-add-in-for-ms-office-beta-first-look","url_meta":{"origin":3308,"position":0},"title":"SAP Analytics Cloud Add-in for MS Office (beta) &#8211; First Look","author":"Xavier Hacking","date":"January 24, 2020","format":false,"excerpt":"At the end of 2019 SAP suddenly introduced a completely new addition to the SAP Analytics Cloud suite: SAP Analytics Cloud for Office. I\u2019ve had a quick look at the beta version of this Excel add-in and it - obviously - looks a lot like our good old SAP Analysis\u2026","rel":"","context":"In &quot;Analysis for Office&quot;","block_context":{"text":"Analysis for Office","link":"https:\/\/www.hackingsap.com\/blog\/category\/analysis-for-office"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/www.hackingsap.com\/blog\/wp-content\/uploads\/SAC_Officeaddin_Roadmap_2020Q1.png?resize=350%2C200&ssl=1","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/www.hackingsap.com\/blog\/wp-content\/uploads\/SAC_Officeaddin_Roadmap_2020Q1.png?resize=350%2C200&ssl=1 1x, https:\/\/i0.wp.com\/www.hackingsap.com\/blog\/wp-content\/uploads\/SAC_Officeaddin_Roadmap_2020Q1.png?resize=525%2C300&ssl=1 1.5x, https:\/\/i0.wp.com\/www.hackingsap.com\/blog\/wp-content\/uploads\/SAC_Officeaddin_Roadmap_2020Q1.png?resize=700%2C400&ssl=1 2x"},"classes":[]},{"id":3586,"url":"https:\/\/www.hackingsap.com\/blog\/gartner-magic-quadrant-2021","url_meta":{"origin":3308,"position":1},"title":"Gartner Magic Quadrant 2021","author":"Xavier Hacking","date":"March 3, 2021","format":false,"excerpt":"Aaaah, winter is almost over which means that the whole BI world is waiting for Gartner to come up with a new Magic Quadrant for Analytics and Business Intelligence Platforms report: The holy scoreboard of the BI Vendor Wars!\u00a0Behold! I always like to skim through the report to see how\u2026","rel":"","context":"In &quot;SAP&quot;","block_context":{"text":"SAP","link":"https:\/\/www.hackingsap.com\/blog\/category\/sap"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/www.hackingsap.com\/blog\/wp-content\/uploads\/Gartner-Magic-Quadrant-2021.png?resize=350%2C200&ssl=1","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/www.hackingsap.com\/blog\/wp-content\/uploads\/Gartner-Magic-Quadrant-2021.png?resize=350%2C200&ssl=1 1x, https:\/\/i0.wp.com\/www.hackingsap.com\/blog\/wp-content\/uploads\/Gartner-Magic-Quadrant-2021.png?resize=525%2C300&ssl=1 1.5x"},"classes":[]},{"id":3521,"url":"https:\/\/www.hackingsap.com\/blog\/sap-analytics-cloud-2019-roundup-the-good-the-bad-and-the-ugly","url_meta":{"origin":3308,"position":2},"title":"SAP Analytics Cloud 2019 Roundup: the good, the bad and the ugly","author":"Xavier Hacking","date":"December 29, 2019","format":false,"excerpt":"2019 is almost over, so just like last year\u00a0this is a good moment to look back at what happened in the SAP Analytics Cloud universe over the past 12 months. This year we got an astonishing 24 wave releases for the SAC tenants that are on the fast track schedule,\u2026","rel":"","context":"In &quot;SAP Analytics Cloud&quot;","block_context":{"text":"SAP Analytics Cloud","link":"https:\/\/www.hackingsap.com\/blog\/category\/sap-analytics-cloud"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":3269,"url":"https:\/\/www.hackingsap.com\/blog\/5-crazy-sap-bi-predictions-for-2018","url_meta":{"origin":3308,"position":3},"title":"5 crazy SAP BI predictions for 2018","author":"Xavier Hacking","date":"January 3, 2018","format":false,"excerpt":"2017 is over, 2018 is here, so it is time to make some crazy (or maybe not so crazy) predictions for the SAP BI universe this year! 1. SAPcoin SAP will launch its own cryptocurrency based on the blockchain technology, to simplify transactions between and within organizations that run SAP\u2026","rel":"","context":"In &quot;SAP&quot;","block_context":{"text":"SAP","link":"https:\/\/www.hackingsap.com\/blog\/category\/sap"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/www.hackingsap.com\/blog\/wp-content\/uploads\/sap-lumira-mobile-app-shut-up-and-take-my-walldorfs.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":3308,"position":4},"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 &quot;SAP Analytics Cloud&quot;","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":3397,"url":"https:\/\/www.hackingsap.com\/blog\/sap-analytics-cloud-anno-2018-the-good-the-bad-the-ugly","url_meta":{"origin":3308,"position":5},"title":"SAP Analytics Cloud anno 2018: the good, the bad &#038; the ugly","author":"Xavier Hacking","date":"December 28, 2018","format":false,"excerpt":"Just a few more days and the year is almost over again, which makes this a perfect time to have a look at what happened in the past 12 months in the world of SAP Analytics Cloud. With all the updates the tool got in 2018 (22 waves!), you\u2019d almost\u2026","rel":"","context":"In &quot;SAP Analytics Cloud&quot;","block_context":{"text":"SAP Analytics Cloud","link":"https:\/\/www.hackingsap.com\/blog\/category\/sap-analytics-cloud"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]}],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/www.hackingsap.com\/blog\/wp-json\/wp\/v2\/posts\/3308","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=3308"}],"version-history":[{"count":1,"href":"https:\/\/www.hackingsap.com\/blog\/wp-json\/wp\/v2\/posts\/3308\/revisions"}],"predecessor-version":[{"id":3309,"href":"https:\/\/www.hackingsap.com\/blog\/wp-json\/wp\/v2\/posts\/3308\/revisions\/3309"}],"wp:attachment":[{"href":"https:\/\/www.hackingsap.com\/blog\/wp-json\/wp\/v2\/media?parent=3308"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.hackingsap.com\/blog\/wp-json\/wp\/v2\/categories?post=3308"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.hackingsap.com\/blog\/wp-json\/wp\/v2\/tags?post=3308"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}