3515483 - After BW changes, the issue "Failed to fetch data" was raised in view mode - SAP Analytics Cloud

After BW changes, the issue "Failed to fetch data" was raised in view mode when using a dimension with a hierarchy in SAP Analytics Cloud.

One of the GetResponse calls from the network trace (.HAR file, KBA 2280022) recorded the following message:
--------------------------------------------------------------------
Error reading the data of InfoProvider [...]
...
Error 2.999 has occurred in the BWA/SAP HANA server
...
Failed to lookup path 'H000Join';QueryId: [...][Request Info: Object Name = [...], FM Name = TREX_DBS_AGGREGATE]
...
Parallel processing of query [...] resulted in the following messages:
...
Error while reading data; navigation is possible
---------------------------------------------------------------------

"Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental."

• SAP Analytics Cloud
• SAP NetWeaver
• SAP BW/4HANA
• SAP S/4HANA

Failed to fetch data, TREX_DBS_AGGREGATE, InfoProvider, 'H000Join', HCPR, BEx query, CDS view, view mode , KBA , LOD-ANA-LDC-BW , SAC Live Data Connection BW , BW-BEX-OT-DBIF , Interface to Database , Problem