SAP Knowledge Base Article - Public

2584786 - Retrieving data using ODATA

Symptom

Due to technical limitation, only up to 50 key figures and characteristics can be selected while retrieving data from ODATA

Environment

SAP Business ByDesign

Reproducing the Issue

  • Run the specified query which have relevant report name and selections used in the report.
  • You will be able to see only only first 50 key figures and characteristics visible in the data extracted

Cause

Due to technical limitation, only up to 50 key figures and characteristics can be selected.

Report execution through OData requests always gets executed only for initial selection, that is, the parameters which are maintained in the report metadata

Resolution

We recommend that you should explicitly select data for the needed fields. Also if you want to override the initial selection in the parameter values, then use $filter=PAR_SEL_DPY_MAINPROSPCT_ID eq '1001140'. Here 1001140 is an example value.

See Also

Help Center document, with the keyword as "Retrieving Analytics Data Using OData"

Keywords

ODATA, 50, key figures, characteristics, limit, amount , KBA , odata, data extraction , AP-RC-ANA , C4C, ByD, Travel: Analytics Tools & Frameworks , How To

Product

SAP Business ByDesign all versions