SAP Knowledge Base Article - Public

2911779 - Counter of Data Source Shows More Records in C4C/ByD Compared to BW

Symptom

You have extracted a data source to a system other than C4C/ByD and you have noticed the counter is not showing the same figure as your system.

Environment

  • SAP Cloud For Customer
  • SAP Business ByDesign

Reproducing the Issue

  1. Go to Business Analytics.
  2. Go to Design Data Sources.
  3. Search for your data source e.g. Account Contact Data (technical ID BPCSCONTB).
  4. Click on Preview and run the data source.
  5. You will notice the counter shows something like 150000.
  6. Now you extract this data source to your BW system.
  7. You notice that the counter shows considerably less than the system. 

Cause

The counter in some data sources where no characteristic is selected may include additional records which are required for access restriction. This is the reason why an unrestricted user would see all records which may be more than the total number of counted entries.

For example: This type of behavior can be seen in the standard data source Account Contact Data.

This type of behavior can be seen in the Business Warehouse/BW system.

Resolution

In order to get a correct count please select the relevant characteristics - the count will change based on selected characteristics and reflect the correct number of entries.

Keywords

BPCSCONTB, counter, BW, less, data source, design data sources, preview , KBA , AP-RC-ANA , C4C, ByD, Travel: Analytics Tools & Frameworks , How To

Product

SAP Business ByDesign all versions ; SAP Cloud for Customer add-ins all versions ; SAP Cloud for Customer core applications all versions