Solution : https://service.sap.com/sap/support/notes/1141576 (SAP Service marketplace login required)
Summary :
When executing a search in a hierarchy in SAP, the system may display the error "Cannot execute search; hierarchy is too large" due to excessive hierarchy size. To resolve this, the RSADMIN parameter 'RSDM_RS_HIER_SEARCH_LIMIT' should be adjusted within the program 'SAP_RSADMIN_MAINTAIN'. This parameter governs the maximum visible nodes and leaves in a search hierarchy. The new limit can be set up to 150,000, enhancing performance by reducing memory usage. Additionally, create message BRAIN 864 in SE91 stating "The leaf search is case sensitive" to inform users of search case sensitivity. Support Package 18 for SAP NetWeaver 7.0 must be imported for these changes.
Key words :
improves search performance considerably, 0 bi import support package 18, prerequisites flexibility solution, create message brain 864, triggers message brain 863, support package, 0 support package 18, message brain 863, bi patch 18, sapbinews bi 7
Related Notes :
| 1472878 | Selector:display the Popup message if hierarchy is too large |
| 1136882 | SAPBINews NW7.0 BI Support Package 18 |
| 1126007 | SAPBINews NW BI 7.10 ABAP SP06 |