Symptom
You want to create a Custom Group (Custom Hierarchy) based on a 0CALDAY dimension and notice that the option "Create Custom Group" is not available.
Environment
SAP Analytics Cloud
Reproducing the Issue
- Click on "Set Hierarchy" for a 0CALDAY dimension;
- On the Hierarchy help notice that "Create Custom Group" is not available;
Cause
Flat navigation attributes e.g. (YEAR, MONTH) are supported, however for hierarchy time dimension like 0CALDAY (e.g. dimensions that are enabled to create a time variance) custom grouping is not supported and the option will be unavailable.
Also notice that BW dimensions that do not support hierarchies will not show the Set Hierarchy menu, and as an extension, will not support custom groupings.
Resolution
Please feel free to submit your customer influence as describe in the note:
2424376 - How do you create an enhancement request for SAP Analytics Cloud?
Keywords
Custom, grouping, hierarchy, 0CALDAY, dimension, Set , KBA , LOD-ANA-LDC-BW , SAC Live Data Connection BW , Problem