3686910 - Error "Failed to fetch data" due "Invalidated View" occurs when consuming SAP Datasphere models

When consuming Datasphere models in front-end tools like SAP Analytics Cloud (SAC), the error below may appear:

• "Failed to fetch data"

• In HAR file/DevTools Network, further information is provided:
  "Caught exception : exception 70034011: Inconsistent calculation model;calculationNode (N_0001_DSRC): Invalidated View: 'H00::SPACE:§MNG_AM_MODEL§MNG_AM_MODEL (t -1)'
  Try to re-open the story or refresh the browser. 

SAP Datasphere

SAP Analytics Cloud or other consumption tool

Significant changes in the underlying objects.

When an object undergoes substantial modifications, it can invalidate dependent objects, such as views, requiring them to be redeployed.
Additionally, if the definition of an object no longer aligns with another, errors may occur.
Specifically, this error indicates that the view is invalid, which typically happens when an underlying object's definition changes or is dropped.

Redeploy the impacted views. It is required to manually redeploy each invalidated view.

To identify invalid views, use the SQL Statement below using a Database Analysis User:

SELECT *
FROM VIEWS
WHERE IS_VALID='FALSE';

To identify dependent objects based on the views which got invalid, consider using the SQL Statement below using a Database Analysis User:

SELECT *
FROM OBJECT_DEPENDENCIES
WHERE BASE_OBJECT_NAME = 'OBJECT1'
    OR BASE_OBJECT_NAME = 'OBJECT2'
    OR BASE_OBJECT_NAME = 'OBJECT3'...;

KBA , DS-MD-VIW , Views , DS-MD-AM , Analytic Model , Known Error