SAP Knowledge Base Article - Public

3782685 - Hierarchy Report Not Shows All Child Accounts Related To Parent Account

Symptom

In report, not all accounts from the account hierarchy appears in the result. 

In the account hierarchy work center view, all accounts are visible, but some are missing in the report.

Environment

SAP Cloud For Customer

Reproducing the Issue

  1. Go to Customers work center.
  2. Navigate to Account hierarchy work center view.
  3. Search for the parent account. 
  4. We can see all the accounts in the account hierarchy including child accounts.
  5. Go to Business Analytics work center.
  6. Navigate to Design reports work center view.
  7. Open the report.
  8. In the report selection, choose a parent account and enable ACCOUNT_HIERACHY.
  9. We can see that some child accounts are missing in the report.

Cause

The account hierarchy was not synchronized in the system, resulting in incomplete hierarchy expansion for the report.

Resolution

  1. Go to Business Analytics work center.
  2. Navigate to Common Tasks work center view.
  3. Select Buffer Hierarchies.
  4. Select hierarchy name 'Account' and click Schedule Buffering.
  5. You've an option to schedule buffering in one of the following ways: Ad hoc or Periodically.
  6. Select your option and click Save and Close. Based on the settings, the system runs the job periodically, or you can run it manually when required.
  7. All the child accounts will be available in the report.

See Also

Buffer Hierarchies | SAP Help Portal

Keywords

account hierarchy, missing accounts, reporting, custom report, ACCOUNT_HIERACHY, hierarchy expansion, analytics, design reports , KBA , AP-RC-ANA , C4C, ByD, Travel: Analytics Tools & Frameworks , Problem

Product

SAP Cloud for Customer core applications 1.0