3448044 - Buttons "Publish Data" and "Revert Data" get disabled in case there is at least one table in a workbook with option "Planning Enabled" turned off in SAC Excel Add-In

When a workbook has just one table and option "Planning Enabled" turned on, it's expected that changes in this workbook can be made.
However, if one more table is added to the same workbook, the expected behavior from SAC Excel Add-In might differ from the behavior in SAC Story directly.

This parameter when turned on will be like:

"Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental".

• SAP Analytics Cloud
• SAP Analytics Cloud, add-in for Microsoft Office

Working as expected

If planning is not available on any of the models related objects (formula data source or table), publish or revert options are not enabled.

The Add-In is working as designed, as placed in SAP Help page Enable / Disable a model for planning with the following explanation:

• You have one table in your workbook and the model is disabled for planning. Then you add a second table based on the same model.
  In this case, the second table is planning-enabled. You can enter planning data and process it but you can't publish or revert your data as the model is disabled for planning in the workbook with the first table.
  
  
• You have a table (Table1) and a data source for formulas (DS_2) in your workbook based on the same model and you disable the model for planning on Table1. In this case, the data source for formulas DS_2 is still planning-enabled. You can enter planning data with the formula and process it but you can't publish or revert your data as the model is disabled for planning in the workbook with Table1.
  
  
• You have two tables (Table3 and Table4) in your workbook based on the two different models and you disable the model for planning on Table3.
  In this case, the other table Table4 is still planning-enabled. You can enter planning data and process it and you can also publish or revert your data as the model is still enabled for planning in the workbook.

• SAP Help: Enable / Disable a model for planning
• SAP Help: Permissions for the add-in
• SAP Help: SAP.SETDATA

Publish Data, Revert Data, SAC, Excel, Add-In, table, workbook, Planning Enabled, turned on, turned off, enable, disable, parameter, option , KBA , LOD-ANA-OF-XLA , SAP Analytics Cloud, add-in for Microsoft Office , Product Enhancement

SAP Analytics Cloud all versions ; SAP Analytics Cloud, add-in for Microsoft Office all versions