Symptom
When search BW query no result is shown, even you can find the same query under "Area" tab.
Environment
SAP Analysis for Microsoft Office
Reproducing the Issue
- Start AO.
- Click "Insert Data Source" icon and select "Select Data Source for Analysis"
- Select a BW system and logon
- In "search" tab, input query ID and click search icon, no result.
- Go to "Area" tab, expand the hierarchy and navigate to the area, the query is shown.
- If set the parameter DisableBWDirectSearch = True in AO, the search works.
Cause
It is caused by the Inconsistent buffer of the BW search.
Resolution
- Run transaction RSOSM.
- Click "Configure BW Search" button.
- Click delete icon of "Status of Shared Buffer".
- If the issue still exists, execute report RSOSM_REGISTER_DELE in SE38.
- For SAP BW 7.50-SAP BW 7.53, implement Note 2767648-TLOGO object DELE is not available in BW search, and then execute the report RSOSM_REGISTER_DELE in SE38.
- For SAP BW 7.53 above and BW/4HANA, follow KBA 3305130-TLOGO object is missing from RSOSM after upgrade to BW/4HANA, to create report ZSAP_REGISTER_DELE and execute it in SE38.
Keywords
Analysis for Office, A4O, Analysis for Excel, AFO, , KBA , BI-RA-AO-XLA , Excel Addin , BW-WHM-MTD-SRCH , BI Search , Problem
Product
SAP Analysis for Microsoft Office 2.8
Attachments
ac72e925eb3cae50fe17f799cad0cd15 |