SAP Knowledge Base Article - Public

3451156 - Missing data when importing data from SAP Business ByDesign Analytics in SAP Analytics Cloud (SAC)

Symptom

  • Missing data when importing data from SAP Business ByDesign Analytics in SAP Analytics Cloud (SAC)

Environment

  • SAP Analytics Cloud, Enterprise Edition
  • SAP Business ByDesign

Reproducing the Issue

  1. Login to SAC tenant.
  2. Create a new Import Data Connection to SAP Business ByDesign Analytics.
    • Please ensure that that the Data Service URL uses the right format in SAP Analytics Business ByDesign (Example:  <system URL>/sap/byd/odata/<madav_ID>.svc )
    • Note that every data source in ByD will have one dedicated URL so you need to have a dedicated connection in SAC for each of them.
    • If you don't know the Data Service URL, please refer to SAP KBA 2913312 or submit one case to component AP-RC-ANA.
  3. Create a new model based on the connection created above.
  4. Select one entity and then build one query by moving data elements into the Selected Data and Filters areas.
  5. Select OK to run the query.
    • In the data appearing in the Data Integration view, verify that some data is missing.
    • IF running the OData request (Example:  <system URL>/sap/byd/odata/<madav_ID>.svc/<Entity Name>) from browser directly,  the data you expected cannot be also found, which means that the OData Service exposed from ByD doesn't return such data.
      => Note: you may need to run <system URL>/sap/byd/odata/<madav_ID>.svc/$metadata from browser in advance to get the Name of such entity based on the label shown in step 4.

Cause

  • As per SAP Blog, Using OData APIs for SAP Business ByDesign Analytics you can query and extract SAP Business ByDesign reports and data sources for analytical use cases:
    • OData for Reports can be used to query and retrieve characteristics and key figures exposed in ByD analytical reports.  
    • OData for Data Sources is designed to extract analytical raw data in flat tables.
  • In the scenario above, the query created in SAC is built on OData for Reports to extract formatted analytical data pre-processed by ByD.
    • In this case, OData will always take the Default Value selected for Variables defined in the ByD report.
    • So the records of other members excluded from such report variable/filter are not returned from the OData for Reports API.
    • Note, when running the same report in ByD, you will still have choice to change values for the variables to show more data. 

Resolution

  • Check with your ByD expert to see if it is possible to change/remove the Default Value selected for Variables defined in the ByD report.
  • Please always ensure that you could see the data you expected when running the OData request (Example:  <system URL>/sap/byd/odata/<madav_ID>.svc/<Entity Name>) from browser directly.

See Also

Your feedback is important to help us improve our knowledge base.

Keywords

EPM, SAP Cloud for Planning, sc4p, c4p, cforp, cloudforplanning, Cloud for Planning, Cloud for Analytics, C4P, Cloud4Analytics, CloudforAnalytics, Cloud 4 Planning, HCP, C4A, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, BOBJ, BOBJcloud, BOCloud., BICloud, BO Cloud, SAC, Import, Acquire, Load, ByD, C4C, report, Odata, missing, miss, data, row, record, filter, variable, initial, selection, default, value, member , KBA , LOD-ANA-AQU , Import Data Connections (Acquiring Data) , AP-RC-ANA , C4C, ByD, Travel: Analytics Tools & Frameworks , Problem

Product

SAP Analytics Cloud 1.0 ; SAP Business ByDesign 2402