Symptom
The errors below occur in Analysis Office when filtering a hierarchy:
---------------------------
An exception occurred in one of the data sources.
[f1e2-4b20-50] Nested exception. See inner exception below for more details
An exception with the type CX_SY_RANGE_OUT_OF_BOUNDS was raised, but was not handled locally or declared in a RAISING clause.
Substring access (offset = 2-, length = 8) to a data object of the size 6 exceeds valid boundaries.
---------------------------
When executing the RSTT trace (recorded as described in SAP note 2129389), the trace is red with the following errors:
---------------------------
Execution of function module BICS_PROV_GET_MEMBERS
An exception with the type CX_SY_RANGE_OUT_OF_BOUNDS was raised, but was not handled local
Substring access (offset = 2-, length = 8) to a data object of the size 6 exceeds valid boundaries.
CL_RRHI_MDACCESS_TD >> Row: Inc: 37 Prog: GET_PARTKEYS
---------------------------
Environment
SAP BusinessObjects Analysis, edition for Microsoft Office
Resolution
Implement the SAP note below if applicable:
3062791 - Exception CX_SY_RANGE_OUT_OF_BOUNDS in CL_RRHI_MDACCESS_TD
Keywords
f1e2-4b20-50, CX_SY_RANGE_OUT_OF_BOUNDS , KBA , BI-RA-AO-XLA , Excel Addin , BW-BEX-OT-OLAP-HIER , Using Hierarchies , Problem