SAP Knowledge Base Article - Public

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

Symptom

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".

Environment

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

Cause

Working as expected

Resolution

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 two tables (Table1 and Table2) in your workbook based on the same model and you disable the model for planning on Table1.
    In this case, the other table Table2 is still 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 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.

See Also

Keywords

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

Product

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