SAP Knowledge Base Article - Public

3276982 - Data not showing up for Restricted Measures when the account has 'Lookup' Formula in SAP Analytics Cloud (SAC)


When trying to create a restricted measure based on another measure having "Lookup" formula defined in model level, the restricted measure will not show any values both in Tables or Charts.


  • SAP Analytics Cloud (Enterprise) 2022.21.5
  • Import Data Connection

Reproducing the Issue

  1. Create a model based on import data connection. 
  2. Select the Account objects in the model and define a "Lookup" formula for one of the member. 
  3. Create a Story based on this model. 
  4. Visualize the data either with Charts or Tables, notice that everything is displayed properly. 
  5. Define a restricted measure based on the Account member which has "Lookup" formula. 
  6. Notice that the restricted measure does not display any value in the widgets.



This issue is currently under investigation by development.


This issue is currently under investigation by development.

See Also

Your feedback is important to help us improve our knowledge base.


sac, import, model, calc, calculation, look, up, lookup, restrict, restricted, measure, account, numeric, object , KBA , LOD-ANA-DES-CAL , SAC Story Calculations , LOD-ANA-DES , Story Design & Visualizations , Problem


SAP Analytics Cloud 1.0