{"id":3549,"date":"2020-05-31T13:16:50","date_gmt":"2020-05-31T12:16:50","guid":{"rendered":"https:\/\/www.hackingsap.com\/blog\/?p=3549"},"modified":"2020-05-31T13:17:41","modified_gmt":"2020-05-31T12:17:41","slug":"sap-analytics-cloud-and-sap-data-warehouse-cloud-early-insights","status":"publish","type":"post","link":"https:\/\/www.hackingsap.com\/blog\/sap-analytics-cloud-and-sap-data-warehouse-cloud-early-insights","title":{"rendered":"SAP Analytics Cloud and SAP Data Warehouse Cloud: Early Insights"},"content":{"rendered":"<p>One of the projects that I\u2019m currently working on involves a very interesting setup with the brand new SAP Data Warehouse Cloud (DWC) as its datawarehousing solution. As front-end \u00a0we use SAP Analytics Cloud (SAC), which is available as an embedded offering within DWC. This is actually the first DWC implementation in Europe so that\u2019s very exciting and cool to be part of!<\/p>\n<p>In the following video the project is introduced and the solution architecture is shown, plus a demo on how the data models were created in DWC. At the end of the video a demo is given of one of the dashboards that we created in SAC on top of these DWC models.<\/p>\n<figure class=\"wp-block-embed-youtube wp-block-embed is-type-video is-provider-youtube wp-embed-aspect-4-3 wp-has-aspect-ratio\">\n<div class=\"wp-block-embed__wrapper\">\n<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\/cgs2IqftgH0?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>\n<\/div>\n<\/figure>\n<h2 class=\"wp-block-heading\">Spaces<\/h2>\n<p>From the SAP Analytics Cloud side there are a few things that we need to take into account with this approach. The embedded SAC tenant is very much linked to its DWC counterpart. You have to work within an isolated \u201cspace\u201d and make sure that all SAC users also are made a member of the space that you built the stories in. This is in addition to the DWC role(s) that have to be assigned to these users. Unfortunately these spaces lack any form of structure or options for management. There are no folders and the sharing settings of documents cannot be adjusted. This could maybe work with a very small user base but is something you really don\u2019t want for a large audience. As there are no (public) folders, all objects (SAC stories, DWC views) are listed in a single list of documents.\u00a0<\/p>\n<h2 class=\"wp-block-heading\">Models<\/h2>\n<p>The SAC classic setup, where a model must be built first before the data can be consumed in the SAC story, is altered in the embedded SAC version. If you want to use a DWC view in a SAC story, you need to go to the respective space in DWC and create a story from there. A pop-up will appear that lists all available DWC views; no separate model is required anymore. Via this workflow it is also possible to add additional DWC views to the same story.\u00a0<\/p>\n<p>A step that is left out of this workflow is the option to use a story template, which is an important asset to develop a consistent line of reporting. If you switch from the DWC side of the tenant to the SAC side, the standard option to create a story is still available, including the template selection step. However, the problem here is that there is no option to select the DWC views, as this probably requires you to be within the particular DWC space first.<\/p>\n<h2 class=\"wp-block-heading\">Data Warehouse Cloud Live Connection<\/h2>\n<p>Luckily the solution for the above problems is already available in a live data connections for DWC. With this we can let DWC act as any other live data source (SAP BW, SAP HANA). The only difference is that the creation of a model is not necessary, even when the DWC live connection is used from a standalone tenant (which is actually a plus!).<\/p>\n<h2 class=\"wp-block-heading\">Conclusion<\/h2>\n<p>So in conclusion I think it is a very good approach to offer an out of the box SAC environment within DWC. The developments and testing of DWC views and SAC stories went in extremely short cycles, which meant that we were able to make a huge progress in a very short time frame. I\u2019m not convinced though whether the idea of using spaces is really the way to go. If the audience consists of isolated (business) teams that build their own DWC views and SAC stories it looks like a handy approach, but in a classic setup where a dedicated team creates a set of reports for a large, company wide audience better platform management options are required. Good thing is that we can achieve this with the new DWC live connection!<\/p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>One of the projects that I\u2019m currently working on involves a very interesting setup with the brand new SAP Data Warehouse Cloud (DWC) as its datawarehousing solution. As front-end \u00a0we use SAP Analytics Cloud (SAC), which is available as an embedded offering within DWC. This is actually the first DWC implementation in Europe so that\u2019s [&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":[299,346],"tags":[348,347],"class_list":["post-3549","post","type-post","status-publish","format-standard","hentry","category-sap-analytics-cloud","category-sap-datasphere","tag-dwc","tag-sac"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_shortlink":"https:\/\/wp.me\/pKaa2-Vf","jetpack-related-posts":[{"id":3514,"url":"https:\/\/www.hackingsap.com\/blog\/sap-teched-2019-highlights","url_meta":{"origin":3549,"position":0},"title":"SAP TechEd 2019 Highlights","author":"Xavier Hacking","date":"October 18, 2019","format":false,"excerpt":"I went to Las Vegas SAP TechEd 2019 a couple of weeks ago, of course focussing on all the new stuff for SAP Analytics Cloud (SAC) and the brand new SAP Data Warehouse Cloud (DWC). Let's go through some highlights. Embedded Analytics Announced a long time ago already, but now\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\/www.hackingsap.com\/blog\/wp-content\/uploads\/DWCloudSACTeched.png?resize=350%2C200&ssl=1","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/www.hackingsap.com\/blog\/wp-content\/uploads\/DWCloudSACTeched.png?resize=350%2C200&ssl=1 1x, https:\/\/i0.wp.com\/www.hackingsap.com\/blog\/wp-content\/uploads\/DWCloudSACTeched.png?resize=525%2C300&ssl=1 1.5x, https:\/\/i0.wp.com\/www.hackingsap.com\/blog\/wp-content\/uploads\/DWCloudSACTeched.png?resize=700%2C400&ssl=1 2x"},"classes":[]},{"id":3555,"url":"https:\/\/www.hackingsap.com\/blog\/sap-data-warehouse-cloud-webinar","url_meta":{"origin":3549,"position":1},"title":"SAP Data Warehouse Cloud Webinar","author":"Xavier Hacking","date":"September 29, 2020","format":false,"excerpt":"On Tuesday 6 October 2020 we (Interdobs) hosted a webinar on our real case experiences with SAP Data Warehouse Cloud. We demonstrated the DWC solution and discussed our project learnings. You can rewatch the webinar via this link, or in audio via the podcast player at the end of this\u2026","rel":"","context":"In &quot;De Nederlandse BI Podcast&quot;","block_context":{"text":"De Nederlandse BI Podcast","link":"https:\/\/www.hackingsap.com\/blog\/category\/podcast"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/www.hackingsap.com\/blog\/wp-content\/uploads\/sapdatawarehousecloud_webinar202010.png?resize=350%2C200&ssl=1","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/www.hackingsap.com\/blog\/wp-content\/uploads\/sapdatawarehousecloud_webinar202010.png?resize=350%2C200&ssl=1 1x, https:\/\/i0.wp.com\/www.hackingsap.com\/blog\/wp-content\/uploads\/sapdatawarehousecloud_webinar202010.png?resize=525%2C300&ssl=1 1.5x, https:\/\/i0.wp.com\/www.hackingsap.com\/blog\/wp-content\/uploads\/sapdatawarehousecloud_webinar202010.png?resize=700%2C400&ssl=1 2x, https:\/\/i0.wp.com\/www.hackingsap.com\/blog\/wp-content\/uploads\/sapdatawarehousecloud_webinar202010.png?resize=1050%2C600&ssl=1 3x"},"classes":[]},{"id":3575,"url":"https:\/\/www.hackingsap.com\/blog\/sap-teched-2020-running-sap-data-warehouse-cloud-in-a-live-environment-cm103","url_meta":{"origin":3549,"position":2},"title":"SAP TechEd 2020 &#8211; Running SAP Data Warehouse Cloud in a Live Environment [CM103]","author":"Xavier Hacking","date":"December 11, 2020","format":false,"excerpt":"SAP TechEd 2020 was a completely virtual event and we (the Interdobs DWC team) were given the opportunity to host session CM103 to talk a bit about our experiences with SAP Data Warehouse Cloud (and SAP Analytics Cloud) in a live environment. Obviously it always better to be in Las\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":"","src":"https:\/\/i0.wp.com\/img.youtube.com\/vi\/YTO51TuH2FE\/0.jpg?resize=350%2C200","width":350,"height":200},"classes":[]},{"id":3631,"url":"https:\/\/www.hackingsap.com\/blog\/gartner-magic-quadrant-for-analytics-and-business-intelligence-platforms-2022","url_meta":{"origin":3549,"position":3},"title":"Gartner Magic Quadrant for Analytics and Business Intelligence Platforms 2022","author":"Xavier Hacking","date":"April 5, 2022","format":false,"excerpt":"It's that time of the year again: Gartner just published its holy Magic Quadrant for Analytics and Business Intelligence (ABI) Platforms for 2022! Our beloved SAP Analytics Cloud is SAP's offering in this area and is compared to tools as PowerBI (Microsoft), Tableau (SalesForce) and Qlik. Status Quo? When I\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\/www.hackingsap.com\/blog\/wp-content\/uploads\/Gartner-Magic-Quadrant-2021-1.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-1.png?resize=350%2C200&ssl=1 1x, https:\/\/i0.wp.com\/www.hackingsap.com\/blog\/wp-content\/uploads\/Gartner-Magic-Quadrant-2021-1.png?resize=525%2C300&ssl=1 1.5x"},"classes":[]},{"id":3661,"url":"https:\/\/www.hackingsap.com\/blog\/dashboards-are-dead-really","url_meta":{"origin":3549,"position":4},"title":"Dashboards are dead? Really?","author":"Xavier Hacking","date":"July 28, 2022","format":false,"excerpt":"I saw\u00a0this\u00a0nice discussion on LinkedIn last week on the state of dashboarding. And yes, I was as surprised as you to see a relevant, professional post on this platform in 2022, as LinkedIn has turned into some sort of Facebook lately, but okay... \ud83d\ude05\u00a0\u00a0 The premise of the post was\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\/www.hackingsap.com\/blog\/wp-content\/uploads\/dashboards-are-dead-thoughspot.png?resize=350%2C200&ssl=1","width":350,"height":200},"classes":[]},{"id":3683,"url":"https:\/\/www.hackingsap.com\/blog\/book-review-sap-analytics-cloud-financial-planning-and-analysis-sap-press","url_meta":{"origin":3549,"position":5},"title":"Book review: SAP Analytics Cloud &#8211; Financial Planning and Analysis (SAP Press)","author":"Xavier Hacking","date":"August 16, 2022","format":false,"excerpt":"Another review on yet another SAP Analytics Cloud (SAC) book? Oh yes! This time I read\u00a0SAP Analytics Cloud - Financial Planning and Analysis, again by SAP Press, and I was very glad to see this 450+ pages strong book on SAC Planning being announced some time ago.\u00a0 Few may know\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\/SAP-Analytics-Cloud-Financial-Planning-Analysis-SAP-Press.png?resize=350%2C200&ssl=1","width":350,"height":200},"classes":[]}],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/www.hackingsap.com\/blog\/wp-json\/wp\/v2\/posts\/3549","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=3549"}],"version-history":[{"count":3,"href":"https:\/\/www.hackingsap.com\/blog\/wp-json\/wp\/v2\/posts\/3549\/revisions"}],"predecessor-version":[{"id":3552,"href":"https:\/\/www.hackingsap.com\/blog\/wp-json\/wp\/v2\/posts\/3549\/revisions\/3552"}],"wp:attachment":[{"href":"https:\/\/www.hackingsap.com\/blog\/wp-json\/wp\/v2\/media?parent=3549"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.hackingsap.com\/blog\/wp-json\/wp\/v2\/categories?post=3549"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.hackingsap.com\/blog\/wp-json\/wp\/v2\/tags?post=3549"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}