{"id":10397,"date":"2026-04-30T11:00:39","date_gmt":"2026-04-30T09:00:39","guid":{"rendered":"https:\/\/www.bix-consulting.com\/?p=10397"},"modified":"2026-04-30T11:00:42","modified_gmt":"2026-04-30T09:00:42","slug":"end-to-end-forecasting-with-sap-business-data-cloud","status":"publish","type":"post","link":"https:\/\/www.bix-consulting.com\/en\/end-to-end-forecasting-with-sap-business-data-cloud\/","title":{"rendered":"End-to-End Forecasting with SAP Business Data Cloud"},"content":{"rendered":"\n[et_pb_section fb_built=“1″ _builder_version=“4.27.6″ _module_preset=“default“ global_colors_info=“{}“ theme_builder_area=“post_content“][et_pb_row _builder_version=“4.27.6″ _module_preset=“default“ background_color=“RGBA(255,255,255,0)“ width=“100%“ custom_margin=“-20px||||false|false“ custom_padding=“20px||||false|false“ border_radii=“off|30px|30px|30px|30px“ locked=“off“ global_colors_info=“{}“ theme_builder_area=“post_content“][et_pb_column type=“4_4″ _builder_version=“4.21.0″ _module_preset=“default“ global_colors_info=“{}“ theme_builder_area=“post_content“][et_pb_text _builder_version=“4.27.6″ _module_preset=“default“ background_color=“RGBA(255,255,255,0)“ custom_margin=“||||false|false“ custom_padding=“|20px||20px|false|false“ border_radii=“off|30px|30px|30px|30px“ global_colors_info=“{}“ theme_builder_area=“post_content“]

May 2026<\/strong><\/p>\n

Data Products, Databricks, and Seamless Planning<\/h4>\n

Forecasting is only as good as the data behind it \u2014 and for many companies, getting the right data to the right place at the right time can still be hard. Sales actual data lives in on-premise BW, machine learning runs in Databricks, and planning happens in SAC. Stitching these together typically means copying data across systems and maintaining complex pipelines.<\/span><\/p>\n

With SAP Business Data Cloud, it becomes possible to build a fully integrated forecasting workflow without a single unnecessary data copy. In this article, I’ll walk through exactly that: an end-to-end scenario in which a planner can trigger an AI-generated sales forecast and work with it in SAC, all with a single button click.<\/span><\/p>\n

The business scenario focuses<\/strong> on generating an Ice Cream sales forecast, built on sales actual data from BW and weather forecast data loaded from an external service. An ML model in Databricks \u2013 trained on historical sales figures and weather parameters \u2013 takes the weather forecast for the coming month and produces a corresponding sales forecast.<\/p>\n

The end user works within an SAC story, launching the forecast calculation with a single button and directly analyzing the results.<\/p>\n

Technically<\/strong>, the scenario unfolds in five steps:<\/p>\n

    \n
  1. Setting up Data products: sales actual data in Datasphere, sales forecast in Databricks.<\/span><\/li>\n
  2. Modeling in Datasphere.<\/span><\/li>\n
  3. Calculating the sales forecast in Databricks.<\/li>\n
  4. Building a Seamless Planning model in SAC. <\/span><\/li>\n
  5. Automating the process flow with Multi-actions and Task Chains.<\/span><\/li>\n<\/ol>\n

    End-to-end architecture is shown on the schema below:<\/p>[\/et_pb_text][et_pb_image src=“https:\/\/www.bix-consulting.com\/wp-content\/uploads\/2026\/04\/202605_Blog_IK.png_01.png“ title_text=“202605_Blog_IK.png_01″ align=“center“ _builder_version=“4.27.6″ _module_preset=“default“ width=“60%“ custom_margin=“40px||20px||false|false“ global_colors_info=“{}“ theme_builder_area=“post_content“][\/et_pb_image][et_pb_text _builder_version=“4.27.6″ _module_preset=“default“ background_color=“RGBA(255,255,255,0)“ custom_margin=“||||false|false“ custom_padding=“|20px||20px|false|false“ border_radii=“off|30px|30px|30px|30px“ global_colors_info=“{}“ theme_builder_area=“post_content“]

    Datasphere ingests the sales actual data from BW, wraps it as a Data product, and shares it with Databricks. There, it is combined with historical weather parameters \u2013 sourced from an external service \u2013 to produce the dataset used for ML model training. Given the weather forecast, the pre-trained model generates the sales forecast, wraps it as a Data Product, and shares it back with Datasphere.<\/p>\n

    A Seamless planning model, built on top of a Datasphere view, reads the generated forecast in real time and allows planners to create new planning versions with the required adjustments. \u00a0<\/p>\n

    Let\u2019s dive into the details.<\/p>[\/et_pb_text][\/et_pb_column][\/et_pb_row][\/et_pb_section]\n","protected":false},"excerpt":{"rendered":"

    A fully integrated, AI-generated sales forecast built on BW sales data and external weather data \u2014 shared with Databricks without physical copying and triggered in SAC with a single click.<\/p>","protected":false},"author":9,"featured_media":10413,"comment_status":"closed","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":"","_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"iawp_total_views":7,"footnotes":""},"categories":[18],"tags":[],"class_list":["post-10397","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-blog"],"modified_by":"admin","_links":{"self":[{"href":"https:\/\/www.bix-consulting.com\/en\/wp-json\/wp\/v2\/posts\/10397","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.bix-consulting.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.bix-consulting.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.bix-consulting.com\/en\/wp-json\/wp\/v2\/users\/9"}],"replies":[{"embeddable":true,"href":"https:\/\/www.bix-consulting.com\/en\/wp-json\/wp\/v2\/comments?post=10397"}],"version-history":[{"count":12,"href":"https:\/\/www.bix-consulting.com\/en\/wp-json\/wp\/v2\/posts\/10397\/revisions"}],"predecessor-version":[{"id":10430,"href":"https:\/\/www.bix-consulting.com\/en\/wp-json\/wp\/v2\/posts\/10397\/revisions\/10430"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.bix-consulting.com\/en\/wp-json\/wp\/v2\/media\/10413"}],"wp:attachment":[{"href":"https:\/\/www.bix-consulting.com\/en\/wp-json\/wp\/v2\/media?parent=10397"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.bix-consulting.com\/en\/wp-json\/wp\/v2\/categories?post=10397"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.bix-consulting.com\/en\/wp-json\/wp\/v2\/tags?post=10397"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}