Symptom
The 'hide column' function is not available in the forecast layout table structure. However, this functionality works as expected in the cross tab table structure.
Environment
SAP Analytics Cloud
Reproducing the Issue
- In story, create a table and set table structure to 'forecast layout'
- right-click a column on table
- No 'hide column' option displayed
Cause
This behavior is by design.
Column/row hiding is disabled for the columns/rows containing version or time dimension in forecast layout. When creating or updating forecast layout, hidden columns/rows will be cleared and recreated again. By doing so, the hidden columns/rows created by users will be lost as well. Therefore it isn't possible to hide columns and rows for version and time dimension but all other dimension will be supported. This special case exists only for the forecast layout.
Resolution
Column/row hiding is not supported in forecast layout table structure
Keywords
SAP Analytics Cloud, forecast layout, hide column, hide row, table, version, time, hidden , KBA , LOD-ANA-TAB-COR , SAC Table Core, Drill, In-Cell-Chart, Custom Cells , Problem
SAP Knowledge Base Article - Public