SAP Knowledge Base Article - Public

3504377 - Dimension member is grayed out when adding in a table widget with linked dimensions in a classic story in SAP Analytics Cloud (SAC)

Symptom

When adding a dimension as row in a table widget using linked dimensions, the dimension member is grayed out in the classic story in SAC

Environment

SAP ANALYTICS CLOUD 2024.8.20

Connection: live

Data source: BW

Reproducing the Issue

  1. Login in SAC
  2. Open the classic story containing table widget with linked dimensions
  3. In the builder panel, add the dimension as a row
  4. Notice the the desired dimension is grayed out

Cause

  • The desired dimension to be added is from the secondary model from the 2 linked models
  • If we linked Model-1.dimension with Model-2.dimension, we should not be able to add Model-2.dimension within the dimension dropdowns of the builder panel.

Resolution

If you want to add the dimension from the Model-2, use the Model-2 as primary model when linking both the models. This way you can add the desired dimension from Model-2 in the builder panel.

See Also

Keywords

linked dimensions, table, classic, story, classic mode, dimensions, rows, columns, widget, models, blended models, SAC , KBA , LOD-ANA-DES , Story Design & Visualizations , Problem

Product

SAP Analytics Cloud 1.0