SAP Knowledge Base Article - Preview

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

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

SAP BW/4HANA all versions ; SAP NetWeaver 7.5 ; SAP S/4HANA Cloud 1911 ; SAP S/4HANA Cloud 2002

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.