SAP Knowledge Base Article - Public

2649756 - Only one Planning Model is allowed in a single Analysis for Office workbook

Symptom

You have two or more queries under a single Analysis for Office (AO) workbook and want an option to have different Planning Models for each query.

Environment

SAP Analysis for Microsoft Office

Reproducing the Issue

  • Insert two or more Planning Queries in Analysis for Office (can be on different worksheets)
  • Change the Planning model at the Design Panel / Components / Planning tab
  • The change applies to all queries

Cause

The product is designed to work like this.

Resolution

This is a limitation of AO, only one Planning model is allowed per workbook.

Keywords

Planning Model , KBA , BI-RA-AO-XLA , Excel Addin , Problem

Product

SAP Analysis for Microsoft Office 2.6