3705979 - "A Cyclical dependency was found in the measure" error appears in a widget in SAP Analytics Cloud (SAC)

The following error message appears when a calculation references an account or measure that has the same name as the model calculation:
"A cyclical dependency was found in the measure"

SAP Analytics Cloud

1. Create a model calculation where the calculation name matches the account or measure member name referenced in the formula
   Example:
   1. Measure calculation name as Expenses(same as existing account member) with the formula
      ACCOUNTLOOKUP([FixedCurrency], [Expenses])
   2. Account member name as FixedCurrency(same as existing measure member)  with the formula
      MEASURELOOKUP([Expenses], [FixedCurrency])
2. Save the model
3. Create a story using this model and insert a chart widget
4. In the story, create any type of account or measure calculation:

1. 1. If an account calculation is created, select the FixedCurrency account member in the calculation and add FixedCurrency as the measure on the axis
   2. If a measure calculation is created, select the Expenses measure member in the calculation and add Expenses as the account on the axis

     5. Click Ok

The system detects a self-reference because the model calculation name matches the account or measure used in its formula

1. Navigate to the model calculation that uses ACCOUNTLOOKUP or MEASURELOOKUP
2. Rename the model calculation or account member so that it does not match the referenced account or measure
3. Return to the story calculation that triggered the error
4. Edit and re-save the story calculation (it may initially show an error due to the renamed model calculation)
5. The widget will then display data correctly

• KBA 2569847 - Where can you find SAC user assistance (help) to use, configure, and operate it more effectively?
• KBA 2487011 - What information do I need to provide when opening a case for SAP Analytics Cloud?
• KBA 2511489 - Troubleshooting performance issues in SAP Analytics Cloud
• SAP Analytics Cloud Connection Guide
• SAP Analytics Cloud Get More Help and SAP Support
• Need More Help? Contact Support 

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

calc, calculation, account, lookup, cyclic, cyclical, error, dependency, dependent, widget, chart, table, story,  , KBA , LOD-ANA-DES-CAL , SAC Story Calculations , LOD-ANA-DES , Story Design & Visualizations , Problem