2572550 - OLAP effort too large; add filter or remove drill down characteristic

Executing a BW Query (or a CDS query) fails with one of the below errors:

• OLAP effort too large; add filter or remove drill down characteristic [BRAIN_DEV 135]
• Too much data requested; Add filter or remove drilldown characteristic
  • In some cases, the error appears combined with error "Data source "DS_1" is not initialized."

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

• SAP NetWeaver 7.5x
• SAP BW/4HANA - all version
• S/4HANA Embedded Analytics - all version
• SAP Marketing Cloud - all version
• SAP Analytics Cloud

BRAIN_DEV135, BRAIN_DEV 135, BRAIN_DEV: 135, OLAP effort; @Analytics.settings.maxProcessingEffort, Data source “DS_1” is not initialized, Data source "DS_1" is not initialized, [9] Memory allocation failed, GLOBAL_ALLOCATION_LIMIT, SAC, SAP Analytics Cloud , KBA , BW-BEX-OT-OLAP , Analyzing Data , BW4-AE-CORE , Core Services , BW-BEX-OT-ODP , Query Runtime for Operational Data Provisioning , BC-SRV-APS-EXT-AQD , Fiori based Query Designer , BI-RA-AD-EA , Embedded Analytics for S/4 , How To