Exploring SAP Business AI
Exploring Key Components and Applications of SAP Business AI
Introducing the Generative AI Copilot Joule
Introducing Agentic AI and Joule Agents
Introducing Business AI in SAP IBP
Leveraging Joule for Enhanced Planning
Applying AI in Demand and Inventory Planning
Enhancing Supply Planning and Exception Management with AI
The Future of AI in SAP IBP Intelligent Agents

Describing GenAI-Powered Natural Language Formula Creation in the SAP IBP Excel Add-In

Objective

After completing this lesson, you will be able to describe how the planning assistant uses GenAI to generate formulas and formatting from natural language inputs.

Generative AI in Planning UI's

Struggling to remember complex Excel formulas or the steps for conditional formatting? What if you could simply describe the action you want to perform in natural language?

The image illustrates how the Excel add‑in for SAP IBP will leverage AI‑powered planning assistance to let users create calculation formulas through natural‑language prompts as part of upcoming functionality.

In the Excel add-in, the planning assistant allows planners to describe actions in natural language. For example, a user types "Sum sales from January to March for Product A," and the assistant translates this request into the appropriate Excel command. For conditional formatting, a planner can say, "Highlight all unmet demand in red," and after a right-click, the assistant configures Excel accordingly.

Lesson Summary

  • AI-Powered Planning Assistant allows planners to describe formulas and calculations in natural language, which the planning assistant translates into appropriate Excel commands, enabling simple calculations, totals and time-based aggregations without manual formula writing.
  • Conditional Formatting and Actions enables planners to request formatting changes (such as highlighting unmet demand) through conversational prompts, which the assistant configures automatically in Excel.