Symptom
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
- Too much data requested; Add filter or remove drilldown characteristic
- In some cases, this error would appear 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."
Read more...
Environment
- SAP NetWeaver 7.5x
- SAP BW/4HANA - all version
- S/4HANA Embedded Analytics - all version
- SAP Marketing Cloud - all version
Product
Keywords
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 , 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
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.