Symptom
1. When inserting data source, error "Invalid new element, level to high: 7 but expected 6" occurs.
Below error is in AO log.
=========
>> Bali Exception:
Invalid program status\: Invalid new element, level to high: 7 but expected 6
2. The query works fine in T-cd: RSRT.
Environment
SAP Analysis for Microsoft Office
Reproducing the Issue
- Open Analysis for Office.
- Insert data source.
- Press OK button on prompts.
- Error occurs.
Resolution
With the RSADMIN parameter "RS_USE_RESULT_OPS" set to the value "N" the frontend specific implementation of the result set operations are used. It's recommended to use the report "SAP_RSADMIN_MAINTAIN" (SE38) to maintain RSADMIN parameters.
- RS_USE_RESULT_OPS = N
Keywords
data source, BICS, element, RS_USE_RESULT_OPS , KBA , BI-RA-AO-XLA , Excel Addin , BW-BEX-ET-WJR-BICS , BI Consumer Services , Problem