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