Symptom
In Analysis Office tool, the user searches for an InfoProvider. For example: "ZABCXYZ".
In the result list, the InfoProvider is shown with an exclamation point like "!ZABCXYZ".
When executing the InfoProvider, the user gets the error "Data source !ZBGADNRPR was not found in system <SID>".
In RSRT transaction, the InfoProvider can be executed with the exclamation (e.g. !ZABCXYZ) without errors in ABAP BICS mode and even in Analysis Office.
Environment
Analysis for MS Office
Reproducing the Issue
- Start Analysis Office;
- Search for InfoProvider (e.g. ZABCXYZ);
- Confirm the InfoProvider is shown with an exclamation point (e.g. !ZABCXYZ);
- Try to run the InfoProvider and confirm the error below:
"Data source !ZABCXYZ was not found in system SID"
Cause
The issue is caused by the metadata search, which is not implemented correctly in the BW system. As a consequence, the issue occurs when the InfoProvider is searched and executed from Analysis Office tool.
Resolution
Make sure that the following SAP notes are implemented in the BW system and the manual post-implementation steps are followed:
Keywords
infoprovider, not found, search , KBA , BI-RA-AO-XLA , Excel Addin , BW-WHM-MTD-SRCH , BI Search , Problem