Venkadesh Seetharaman is a highly motivated digital supply chain expert currently working at Bolders Consulting Group as a digital supply chain architect. He has more than 20 years of diverse experience in supply chain consulting that includes process and technology consulting. He has worked on large-scale SAP IBP, SAP S/4HANA, and other supply chain transformation projects for global customers, resolving complex supply chain problems through process correction, technology implementation, and continuous improvements in various industries, including life sciences, high-tech, automotive, utilities, communication, and fast-moving consumer goods. Venkadesh believes that cultivating structured supply chain education helps in solving most critical supply chain problems, which motivates him to be an avid blogger and content developer across SAP Community.

Venkadesh is also certified by SAP SE in several areas: SAP IBP, SAP Cloud Integration for data services, SAP Advanced Planning and Optimization (SAP APO), and materials management. Apart from work, Venkadesh is also an avid marathoner and cycler, and he loves to spend time with his family and kids.

Manage exceptions with SAP IBP analytics and dashboards

... Preface ... 15

... How This Book Is Organized ... 15

... Acknowledgments ... 18

... Conclusion ... 18

1 ... Introduction to Demand Planning ... 19

1.1 ... What Is Demand Planning? ... 19

1.2 ... Demand Planning with SAP ... 24

1.3 ... Summary ... 37

2 ... Configuring the Demand Planning Data Model ... 39

2.1 ... Architecture ... 40

2.2 ... Attribute and Master Data Type ... 43

2.3 ... Time Profile and Planning Area ... 54

2.4 ... Planning Level and Attribute as Key Figure ... 83

2.5 ... Key Figures ... 93

2.6 ... Version Management ... 126

2.7 ... Planning Operators ... 129

2.8 ... Global Configuration ... 141

2.9 ... Summary ... 143

3 ... Configuring the Demand Sensing Data Model ... 145

3.1 ... Planning Area ... 145

3.2 ... Lag-Based Snapshots ... 159

3.3 ... Global Configuration ... 161

3.4 ... Summary ... 162

4 ... Statistical Forecasting ... 163

4.1 ... Introduction to Statistical Forecasting ... 164

4.2 ... Statistical Forecasting Model Configuration ... 166

4.3 ... Preprocessing and Data Cleansing ... 168

4.4 ... Constant Models ... 180

4.5 ... Trend Models ... 190

4.6 ... Seasonal Models ... 199

4.7 ... Regression and Sporadic Models ... 205

4.8 ... Classification/Advanced Models ... 215

4.9 ... Postprocessing Models ... 220

4.10 ... Advanced Forecast Automation ... 233

4.11 ... Summary ... 236

5 ... Event-Based Planning ... 237

5.1 ... Product Lifecycle Planning ... 237

5.2 ... Manual Forecasting ... 255

5.3 ... External Forecasting ... 259

5.4 ... Driver-Based Planning ... 264

5.5 ... Promotional Planning ... 272

5.6 ... Financial Planning ... 282

5.7 ... Summary ... 284

6 ... Operational Demand Planning ... 285

6.1 ... Demand Sensing ... 286

6.2 ... Lag-Based Planning ... 315

6.3 ... Summary ... 318

7 ... Data Segmentation and Realignment ... 319

7.1 ... Data Segmentation ... 319

7.2 ... ABC/XYZ Segmentation Rules ... 323

7.3 ... ABC/XYZ Simulation ... 333

7.4 ... Data Realignment ... 353

7.5 ... Summary ... 367

8 ... Microsoft Excel-Based Planning ... 369

8.1 ... SAP IBP, Add-In for Microsoft Excel Ribbon ... 370

8.2 ... Planning View Formatting ... 379

8.3 ... Simulation Planning ... 395

8.4 ... Planner Collaboration ... 407

8.5 ... Summary ... 420

9 ... Exception Management with Analytics and Dashboards ... 423

9.1 ... Advanced Analytics and Dashboards ... 425

9.2 ... Custom Alerts ... 434

9.3 ... Case Management ... 446

9.4 ... Intelligent Visibility ... 447

9.5 ... Navigate to Other SAP Systems ... 450

9.6 ... Summary ... 454

10 ... Data Integration ... 455

10.1 ... Data Integration Using the Web UI ... 456

10.2 ... Data Integration Using SAP Cloud Integration for Data Services ... 461

10.3 ... Data Integration with Other SAP IBP Modules ... 488

10.4 ... Summary ... 493

11 ... Identity and Access Management ... 495

11.1 ... Identity Authentication ... 495

11.2 ... Identity and Access Management Configuration ... 497

11.3 ... Permission Filters ... 501

11.4 ... Planning Filters ... 507

11.5 ... Identity and Access Management Information System ... 511

11.6 ... Summary ... 513

12 ... Application Job Scheduling ... 515

12.1 ... Templates ... 516

12.2 ... Application Jobs ... 520

12.3 ... Application Logs ... 537

12.4 ... Data Lifecycle Management ... 538

12.5 ... Summary ... 547

... The Author ... 549

... Index ... 551