Symptom
When opening AO workbook in Analysis Office, you get the following exception:
The requested query / does not exist on the current server (BRAIN-605, XXX)
The underlying query of this AO workbook can be opened in Analysis Office successfully.
Environment
SAP Analysis for Microsoft Office
Reproducing the Issue
Open AO workbook in Analysis Office and record RSTT Trace.
Execute the RSTT trace and can find the following error:
Execution of function module BICS_PROV_GET_INITIAL_STATE
OLAP message handler messages
The requested query / does not exist on the current server
Message no. BRAIN605
Cause
The message is displayed because in the rfc BICS_PROV_GET_INITIAL_STATE, the meta data search is called which should not happen. Note 3003335 disabled this functionality.
Resolution
Implement note in transaction SNOTE in system:
3003335 - BICS : switch to disable functionality of note 2812687
See Also
3085386 - Error BRAIN 605
Keywords
BRAIN-605, BRAIN605, AO, the requested query, does not exist, on the current server , KBA , BI-RA-AO-XLA , Excel Addin , How To