{"id":2372,"date":"2020-12-08T00:00:34","date_gmt":"2020-12-07T23:00:34","guid":{"rendered":"https:\/\/devstage.bix-consulting.com\/?p=2372"},"modified":"2023-06-22T14:32:22","modified_gmt":"2023-06-22T12:32:22","slug":"sap-analytics-cloud-live-zugriff-auf-externe-daten","status":"publish","type":"post","link":"https:\/\/teststage.bix-consulting.com\/en\/sap-analytics-cloud-live-zugriff-auf-externe-daten\/","title":{"rendered":"SAP Analytics Cloud - Live access to external data"},"content":{"rendered":"<p>[et_pb_section fb_built=&#8220;1&#8243; disabled_on=&#8220;on|on|on&#8220; _builder_version=&#8220;4.21.0&#8243; _module_preset=&#8220;default&#8220; custom_padding=&#8220;||0px||false|false&#8220; disabled=&#8220;on&#8220; global_colors_info=&#8220;{}&#8220; theme_builder_area=&#8220;post_content&#8220;][et_pb_row use_custom_gutter=&#8220;on&#8220; gutter_width=&#8220;2&#8243; _builder_version=&#8220;4.21.0&#8243; _module_preset=&#8220;default&#8220; background_color=&#8220;#F4F4F4&#8243; border_radii=&#8220;off|20px|20px||&#8220; global_colors_info=&#8220;{}&#8220; theme_builder_area=&#8220;post_content&#8220;][et_pb_column type=&#8220;4_4&#8243; _builder_version=&#8220;4.21.0&#8243; _module_preset=&#8220;default&#8220; global_colors_info=&#8220;{}&#8220; theme_builder_area=&#8220;post_content&#8220;][et_pb_text _builder_version=&#8220;4.21.0&#8243; _module_preset=&#8220;default&#8220; custom_padding=&#8220;|20px||20px|false|false&#8220; global_colors_info=&#8220;{}&#8220; theme_builder_area=&#8220;post_content&#8220;]<\/p>\n<h4>Challenge<\/h4>\n<p style=\"text-align: justify;\">Ein in europaweit agierendes Unternehmen bietet Tankkarten f\u00fcr seine ca. 250.000 Gesch\u00e4ftskunden an. Das Gesch\u00e4ftsmodell beinhaltet f\u00fcr das Unternehmen ein hohes finanzielles Risiko, da es prozessbedingt in Vorleistung (Kostenabgang vor Zahlung des Endkunden) geht. Die H\u00f6he der Vorleistung betr\u00e4gt pro Monat einen 10-stelligen Betrag! Ziel muss es demnach sein, die Wahrscheinlichkeit eines Zahlungsausfalls zu minimieren.<\/p>\n<p>[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row _builder_version=&#8220;4.21.0&#8243; _module_preset=&#8220;default&#8220; custom_padding=&#8220;0px||0px||false|false&#8220; global_colors_info=&#8220;{}&#8220; theme_builder_area=&#8220;post_content&#8220;][et_pb_column type=&#8220;4_4&#8243; _builder_version=&#8220;4.21.0&#8243; _module_preset=&#8220;default&#8220; global_colors_info=&#8220;{}&#8220; theme_builder_area=&#8220;post_content&#8220;][et_pb_post_title title=&#8220;off&#8220; meta=&#8220;off&#8220; force_fullwidth=&#8220;off&#8220; image_width=&#8220;60%&#8220; _builder_version=&#8220;4.21.0&#8243; _module_preset=&#8220;default&#8220; background_color=&#8220;#F4F4F4&#8243; custom_margin=&#8220;||||false|false&#8220; custom_padding=&#8220;||||false|false&#8220; global_colors_info=&#8220;{}&#8220; theme_builder_area=&#8220;post_content&#8220;][\/et_pb_post_title][\/et_pb_column][\/et_pb_row][et_pb_row _builder_version=&#8220;4.21.0&#8243; _module_preset=&#8220;default&#8220; custom_padding=&#8220;0px||||false|false&#8220; global_colors_info=&#8220;{}&#8220; theme_builder_area=&#8220;post_content&#8220;][et_pb_column type=&#8220;4_4&#8243; _builder_version=&#8220;4.21.0&#8243; _module_preset=&#8220;default&#8220; global_colors_info=&#8220;{}&#8220; theme_builder_area=&#8220;post_content&#8220;][et_pb_text _builder_version=&#8220;4.21.0&#8243; _module_preset=&#8220;default&#8220; background_color=&#8220;#F4F4F4&#8243; custom_padding=&#8220;20px|20px|20px|20px|false|false&#8220; border_radii=&#8220;off|||20px|20px&#8220; global_colors_info=&#8220;{}&#8220; theme_builder_area=&#8220;post_content&#8220;]<\/p>\n<h4>The approach<\/h4>\n<p style=\"text-align: justify;\">biX Consulting hat auf Basis von KI ein Modell entwickelt, welches die Problematik der Kundenbewertung deutlich optimiert. Im Rahmen von Big Data werden sekundenschnell interne sowie externe Daten zusammengef\u00fchrt, verarbeitet und daraus eine verl\u00e4ssliche Aussage zur Bonit\u00e4t des (Neu)-Kunden getroffen. Mit dieser L\u00f6sung wird die Wahrscheinlichkeit des Ausfallsrisikos elementar reduziert.<\/p>\n<p>[\/et_pb_text][\/et_pb_column][\/et_pb_row][\/et_pb_section][et_pb_section fb_built=&#8220;1&#8243; _builder_version=&#8220;4.21.0&#8243; _module_preset=&#8220;default&#8220; custom_margin=&#8220;||||false|false&#8220; custom_padding=&#8220;0px||||false|false&#8220; global_colors_info=&#8220;{}&#8220; theme_builder_area=&#8220;post_content&#8220;][et_pb_row use_custom_gutter=&#8220;on&#8220; gutter_width=&#8220;2&#8243; make_equal=&#8220;on&#8220; _builder_version=&#8220;4.21.0&#8243; _module_preset=&#8220;default&#8220; background_color=&#8220;#F4F4F4&#8243; border_radii=&#8220;on|20px|20px|20px|20px&#8220; global_colors_info=&#8220;{}&#8220; theme_builder_area=&#8220;post_content&#8220;][et_pb_column type=&#8220;4_4&#8243; _builder_version=&#8220;4.21.0&#8243; _module_preset=&#8220;default&#8220; global_colors_info=&#8220;{}&#8220; theme_builder_area=&#8220;post_content&#8220;][et_pb_text _builder_version=&#8220;4.21.0&#8243; _module_preset=&#8220;default&#8220; custom_padding=&#8220;|20px||20px|false|false&#8220; hover_enabled=&#8220;0&#8243; global_colors_info=&#8220;{}&#8220; theme_builder_area=&#8220;post_content&#8220; sticky_enabled=&#8220;0&#8243;]<\/p>\n<p style=\"text-align: justify;\">SAP Analytics Cloud (SAC) is the standard tool for analysing data, especially in the SAP world. It is often necessary to include additional external data sources in analyses and to integrate and process their data in real-time. This expands the analysis spectrum and can provide new insights for upcoming decisions, but in many cases it is a technical challenge.<\/p>\n<p style=\"text-align: justify;\">With the connection of the SAC to the harmonization layer from denodo, biX Consulting offers a solution which significantly extends the possibility of integrating heterogeneous data sources. The solution also takes the aspects of data governance into particular account, i.e. the use of existing authorization management from SAP BW, no persistence of external data in the SAC, and the possibility of multi-user access.<\/p>\n<h4 style=\"text-align: justify;\">SAC and R-Server<\/h4>\n<p style=\"text-align: justify;\">The SAC offers the possibility to integrate an R-Server and to extend it with own modules. From the R-Server it is in turn possible to access other systems. This access is realised by using suitable drivers such as JDBC.<\/p>\n<p style=\"text-align: justify;\">In this scenario, the R-server performs like a hub function. For example, it is possible to transfer data filters from SAC via the R-Server to the downstream systems. It is also possible to pre-calculate data using statistical methods or to realise complex visualisation.<\/p>\n<p>[\/et_pb_text][\/et_pb_column][\/et_pb_row][\/et_pb_section][et_pb_section fb_built=&#8220;1&#8243; _builder_version=&#8220;4.21.0&#8243; _module_preset=&#8220;default&#8220; custom_padding=&#8220;0px||||false|false&#8220; global_colors_info=&#8220;{}&#8220; theme_builder_area=&#8220;post_content&#8220;][et_pb_row _builder_version=&#8220;4.21.0&#8243; _module_preset=&#8220;default&#8220; global_colors_info=&#8220;{}&#8220; theme_builder_area=&#8220;post_content&#8220;][et_pb_column type=&#8220;4_4&#8243; _builder_version=&#8220;4.21.0&#8243; _module_preset=&#8220;default&#8220; global_colors_info=&#8220;{}&#8220; theme_builder_area=&#8220;post_content&#8220;][et_pb_image src=&#8220;https:\/\/teststage.bix-consulting.com\/wp-content\/uploads\/2023\/06\/R-Server_Denodo_SAC.png&#8220; title_text=&#8220;R-Server_Denodo_SAC&#8220; show_bottom_space=&#8220;off&#8220; _builder_version=&#8220;4.21.0&#8243; _module_preset=&#8220;default&#8220; custom_padding=&#8220;|20px||20px|false|false&#8220; global_colors_info=&#8220;{}&#8220; theme_builder_area=&#8220;post_content&#8220;][\/et_pb_image][\/et_pb_column][\/et_pb_row][\/et_pb_section][et_pb_section fb_built=&#8220;1&#8243; _builder_version=&#8220;4.21.0&#8243; _module_preset=&#8220;default&#8220; custom_margin=&#8220;||||false|false&#8220; custom_padding=&#8220;||0px||false|false&#8220; global_colors_info=&#8220;{}&#8220; theme_builder_area=&#8220;post_content&#8220;][et_pb_row _builder_version=&#8220;4.21.0&#8243; _module_preset=&#8220;default&#8220; custom_padding=&#8220;0px||0px||false|false&#8220; global_colors_info=&#8220;{}&#8220; theme_builder_area=&#8220;post_content&#8220;][et_pb_column type=&#8220;4_4&#8243; _builder_version=&#8220;4.21.0&#8243; _module_preset=&#8220;default&#8220; global_colors_info=&#8220;{}&#8220; theme_builder_area=&#8220;post_content&#8220;][et_pb_text _builder_version=&#8220;4.21.0&#8243; _module_preset=&#8220;default&#8220; background_color=&#8220;RGBA(255,255,255,0)&#8220; custom_padding=&#8220;20px|20px|20px|20px|false|false&#8220; border_radii=&#8220;off|||20px|20px&#8220; global_colors_info=&#8220;{}&#8220; theme_builder_area=&#8220;post_content&#8220;]<\/p>\n<h4>R-Server and denodo<\/h4>\n<p style=\"text-align: justify;\">The denodo data virtualisation platform plays a central role. It controls access to distributed systems and thus enables harmonised access to data by the R-server. For instance, denodo converts external web services into views, which can then be read out of the R-Server using SQL tools. Technically, the R-server and denodo are connected via a LAN connection or via the Internet.<\/p>\n<h6 style=\"text-align: justify;\">Data supplier for live SAC access<\/h6>\n<p style=\"text-align: justify;\">To enable access to the external data with a SAC Live Data Connection, the data from the R-server will be stored in the SAP Business Warehouse. For this purpose, SAP BW can use advanced Data Store Objects (aDSO) to persist the data and uses composite providers and queries to visualise the reports for live access from the SAC.<\/p>\n<p style=\"text-align: justify;\">Via live access, it is possible to execute queries in SAP Business Warehouse (BW) in real time, hence without additional persistence in the cloud. If data in SAP BW is changed, the display elements of the SAC are thus also refreshed.<\/p>\n<p style=\"text-align: justify;\">Multi-user access is enabled by filtering the data on requesting users and using the authorisation system of SAP BW.<\/p>\n<p>[\/et_pb_text][\/et_pb_column][\/et_pb_row][\/et_pb_section][et_pb_section fb_built=&#8220;1&#8243; _builder_version=&#8220;4.21.0&#8243; _module_preset=&#8220;default&#8220; custom_padding=&#8220;||0px||false|false&#8220; global_colors_info=&#8220;{}&#8220; theme_builder_area=&#8220;post_content&#8220;][et_pb_row _builder_version=&#8220;4.21.0&#8243; _module_preset=&#8220;default&#8220; global_colors_info=&#8220;{}&#8220; theme_builder_area=&#8220;post_content&#8220;][et_pb_column type=&#8220;4_4&#8243; _builder_version=&#8220;4.21.0&#8243; _module_preset=&#8220;default&#8220; global_colors_info=&#8220;{}&#8220; theme_builder_area=&#8220;post_content&#8220;][et_pb_image src=&#8220;https:\/\/teststage.bix-consulting.com\/wp-content\/uploads\/2023\/06\/Denodo_Showcase.png&#8220; title_text=&#8220;Denodo_Showcase&#8220; show_bottom_space=&#8220;off&#8220; _builder_version=&#8220;4.21.0&#8243; _module_preset=&#8220;default&#8220; custom_padding=&#8220;|20px||20px|false|false&#8220; global_colors_info=&#8220;{}&#8220; theme_builder_area=&#8220;post_content&#8220;][\/et_pb_image][et_pb_text _builder_version=&#8220;4.21.0&#8243; _module_preset=&#8220;default&#8220; custom_padding=&#8220;|20px||20px|false|false&#8220; global_colors_info=&#8220;{}&#8220; theme_builder_area=&#8220;post_content&#8220;]<\/p>\n<p>Extension of the analysis possibilities in SAC by integrating external data at runtime<\/p>\n<p>[\/et_pb_text][\/et_pb_column][\/et_pb_row][\/et_pb_section][et_pb_section fb_built=&#8220;1&#8243; _builder_version=&#8220;4.21.0&#8243; _module_preset=&#8220;default&#8220; custom_margin=&#8220;||||false|false&#8220; custom_padding=&#8220;10px||0px||false|false&#8220; global_colors_info=&#8220;{}&#8220; theme_builder_area=&#8220;post_content&#8220;][et_pb_row _builder_version=&#8220;4.21.0&#8243; _module_preset=&#8220;default&#8220; custom_padding=&#8220;0px||0px||false|false&#8220; global_colors_info=&#8220;{}&#8220; theme_builder_area=&#8220;post_content&#8220;][et_pb_column type=&#8220;4_4&#8243; _builder_version=&#8220;4.21.0&#8243; _module_preset=&#8220;default&#8220; global_colors_info=&#8220;{}&#8220; theme_builder_area=&#8220;post_content&#8220;][et_pb_text _builder_version=&#8220;4.21.0&#8243; _module_preset=&#8220;default&#8220; background_color=&#8220;RGBA(255,255,255,0)&#8220; custom_padding=&#8220;20px|20px|20px|20px|false|false&#8220; border_radii=&#8220;off|||20px|20px&#8220; global_colors_info=&#8220;{}&#8220; theme_builder_area=&#8220;post_content&#8220;]<\/p>\n<h4>Technical requirements<\/h4>\n<ul style=\"margin-left:1.5em\">\n<li>R-Server with connection SAC and denodo<\/li>\n<li>R-Server module for persisting data<\/li>\n<li>R-Server modules for interface interactions<\/li>\n<\/ul>\n<p>[\/et_pb_text][\/et_pb_column][\/et_pb_row][\/et_pb_section][et_pb_section fb_built=&#8220;1&#8243; _builder_version=&#8220;4.21.0&#8243; _module_preset=&#8220;default&#8220; custom_padding=&#8220;15px||0px||false|false&#8220; global_colors_info=&#8220;{}&#8220; theme_builder_area=&#8220;post_content&#8220;][et_pb_row _builder_version=&#8220;4.21.0&#8243; _module_preset=&#8220;default&#8220; background_color=&#8220;#F4F4F4&#8243; border_radii=&#8220;on|20px|20px|20px|20px&#8220; global_colors_info=&#8220;{}&#8220; theme_builder_area=&#8220;post_content&#8220;][et_pb_column type=&#8220;4_4&#8243; _builder_version=&#8220;4.16&#8243; _module_preset=&#8220;default&#8220; global_colors_info=&#8220;{}&#8220; theme_builder_area=&#8220;post_content&#8220;][et_pb_text _builder_version=&#8220;4.21.0&#8243; _module_preset=&#8220;default&#8220; custom_padding=&#8220;|20px||20px|false|false&#8220; global_colors_info=&#8220;{}&#8220; theme_builder_area=&#8220;post_content&#8220;]<\/p>\n<h4>Benefits<\/h4>\n<p style=\"text-align: justify;\">The solution developed by biX Consulting provides a central access point to external and internal data using the denodo infrastructure. No upload of data to SAP cloud is required. The data to be integrated can be requested by the user in SAC. The persistence of the external data and the data harmonised by support of the denodo platform takes place in SAP BW, from where it can be read and visualised in SAC. Multi-user accesses are possible. No further software licences are required for the\nSAC live connection.<\/p>\n<p>[\/et_pb_text][\/et_pb_column][\/et_pb_row][\/et_pb_section][et_pb_section fb_built=&#8220;1&#8243; _builder_version=&#8220;4.21.0&#8243; _module_preset=&#8220;default&#8220; custom_margin=&#8220;||||false|false&#8220; custom_padding=&#8220;0px||0px||false|false&#8220; global_colors_info=&#8220;{}&#8220; theme_builder_area=&#8220;post_content&#8220;][et_pb_row _builder_version=&#8220;4.21.0&#8243; _module_preset=&#8220;default&#8220; custom_padding=&#8220;||0px||false|false&#8220; global_colors_info=&#8220;{}&#8220; theme_builder_area=&#8220;post_content&#8220;][et_pb_column type=&#8220;4_4&#8243; _builder_version=&#8220;4.21.0&#8243; _module_preset=&#8220;default&#8220; global_colors_info=&#8220;{}&#8220; theme_builder_area=&#8220;post_content&#8220;][et_pb_post_title title=&#8220;off&#8220; meta=&#8220;off&#8220; _builder_version=&#8220;4.21.0&#8243; _module_preset=&#8220;default&#8220; border_radii=&#8220;on|20px|20px|20px|20px&#8220; global_colors_info=&#8220;{}&#8220; theme_builder_area=&#8220;post_content&#8220;][\/et_pb_post_title][\/et_pb_column][\/et_pb_row][\/et_pb_section]<\/p>","protected":false},"excerpt":{"rendered":"<p>Development of a central access point for internal and external data using the Denodo infrastructure<\/p>","protected":false},"author":6,"featured_media":3641,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_et_pb_use_builder":"on","_et_pb_old_content":"","_et_gb_content_width":"","_lmt_disableupdate":"","_lmt_disable":"","footnotes":""},"categories":[32],"tags":[43,39,26,45,29,31,73,77,48,128,40,143,142,80,130,129,38,24,27,127,44,41,131,50,42,49,46,47,144],"modified_by":"admin","_links":{"self":[{"href":"https:\/\/teststage.bix-consulting.com\/en\/wp-json\/wp\/v2\/posts\/2372"}],"collection":[{"href":"https:\/\/teststage.bix-consulting.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/teststage.bix-consulting.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/teststage.bix-consulting.com\/en\/wp-json\/wp\/v2\/users\/6"}],"replies":[{"embeddable":true,"href":"https:\/\/teststage.bix-consulting.com\/en\/wp-json\/wp\/v2\/comments?post=2372"}],"version-history":[{"count":0,"href":"https:\/\/teststage.bix-consulting.com\/en\/wp-json\/wp\/v2\/posts\/2372\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/teststage.bix-consulting.com\/en\/wp-json\/wp\/v2\/media\/3641"}],"wp:attachment":[{"href":"https:\/\/teststage.bix-consulting.com\/en\/wp-json\/wp\/v2\/media?parent=2372"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/teststage.bix-consulting.com\/en\/wp-json\/wp\/v2\/categories?post=2372"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/teststage.bix-consulting.com\/en\/wp-json\/wp\/v2\/tags?post=2372"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}