SAP Knowledge Base Article - Public

3567300 - Date dimension is not available for Calculated Dimension formula

Symptom

  • SAP Analytics Cloud Date column from DataSphere is not available for Calculated Dimension formula

Environment

  • SAP ANALYTICS CLOUD 2024.21.14

Reproducing the Issue

  1. Open Calculated Dimension formula
  2. Start typing the name of Date dimension
  3. The dimension is not available for calculation

Cause

The Date dimension has a flat structure

Resolution

The Flat Date dimensions are not supported for calculation formula. This is by Design

See Also

https://jira.tools.sap/browse/FPA121-5635

https://jira.tools.sap/browse/FPA30-8586

Keywords

KBA , LOD-ANA-DES , Story Design & Visualizations , Problem

Product

SAP Analytics Cloud 1.0