Symptom
You are reporting on top of data source All Activities [CODACTU]. When filtering on field Main Account you select a specific Account ID from Value Help, but in report level other IDs are reflected instead.
Environment
SAP Cloud for Customer
Reproducing the Issue
- Go to Business Analytics > Design Reports
- Find and open report ABC
- In report selection, click on value help for standard field Main Account
- In value help, select the account id NNNN (e.g. 808928)
- See that report results are retrieving multiple different ids, but none of them is the one you selected
Cause
You are reporting on a characteristic field which has hierarchy enabled. It means that when selecting a value from value help you can either select the account as parent or child.
When you select the account as parent, the report results will show the account + all its children.
When it is selected as child it will show only this account.
In the above example, the parent account selected does not contain records itself, but the child accounts do have, so only the child accounts will be listed in report results.
Check into the screenshots from Attachments section for additional details.
Further, it is important to note the reason that value help for field Main Account shows results that are not visible in report results is because this is a characteristic of Master Data type context, so it will display all the values contained in master data by default, even if a given record may not be relevant for the specific report you are using.
Resolution
This is a standard behavior which is expected when using a field of Master Data context type with Hierarchy enabled. To avoid misunderstanding of the report results, make sure to check if the account id you are selecting on value help contain any child ids.
Keywords
Main Account values; Incorrect results in report; Report incorrect; Field Hierarchy; Characteristic Hierarchy; Report Hierarchy; Hierarchy; , KBA , AP-RC-ANA , C4C, ByD, Travel: Analytics Tools & Frameworks , How To
Product
Attachments
1st print for All Activities hierarchy field KBA.jpg |
2nd Print for All Activities hierarchy field KBA.jpg |