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
- Go to Customers work center.
- Navigate to Account hierarchy work center view.
- Search for the parent account.
- We can see all the accounts in the account hierarchy including child accounts.
- Go to Business Analytics work center.
- Navigate to Design reports work center view.
- Open the report.
- In the report selection, choose a parent account and enable ACCOUNT_HIERACHY.
- 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
- Go to Business Analytics work center.
- Navigate to Common Tasks work center view.
- Select Buffer Hierarchies.
- Select hierarchy name 'Account' and click Schedule Buffering.
- You've an option to schedule buffering in one of the following ways: Ad hoc or Periodically.
- 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.
- All the child accounts will be available in the report.
See Also
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
SAP Knowledge Base Article - Public