SAP Knowledge Base Article - Public

3196735 - search BW query is not working in Analysis for Office

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

  1. Start AO.
  2. Click "Insert Data Source" icon and select "Select Data Source for Analysis"
  3. Select a BW system and logon
  4. In "search" tab, input query ID and click search icon, no result.
  5. Go to "Area" tab, expand the hierarchy and navigate to the area, the query is shown.
  6. If set the parameter DisableBWDirectSearch = True in AO, the search works.

Cause

It is caused by the Inconsistent buffer of the BW search.

Resolution

  1. Run transaction RSOSM.
  2. Click "Configure BW Search" button.
  3. Click delete icon of "Status of Shared Buffer".

  4. 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