SAP Knowledge Base Article - Public

2111196 - Search on hierarchy disabled in Analysis for Office

Symptom

When filtering by member on a hierarchy, the search box is grayed out (disabled). Therefore, you are not able to use the search functionality.

Environment

SAP BusinessObjects Analysis, edition for Microsoft Office

Reproducing the Issue

#1 - Run a query in Analysis for Office
#2 - Filter by Member on a hierarchy
#3 - The search box is grayed out (disabled) and it is not possible to search for members

Cause

Usually a hierarchy is considered "large" when it exceeds the size of 50000 nodes.
For performance reasons Analysis for Office (respectively the BI Consumer Services called BICS) turns off the search for a hierarchy if it is a "large" hierarchy.

Resolution

It is possible to change a threshold value which defines when a hierarchy is considered as large.

  • In BW/4HANA systems:

    Maintain the value in field "Threshold when hierarchy is large" in transaction SPRO -> SAP Reference IMG -> SAP BW/4HANA -> Analysis -> Settings for Performance of Analytic Manager.

  • In other BW systems:

    Maintain the value in parameter RSR_HIER_CARD_THRESHOLD in RSADMIN, as described in SAP note 1256547.

How to Know the Size of the Hierarchy (in your Netweaver system)

  1. Run RSH1 transaction

  2. Search for the hierarchy and double-click on it

  3. Click on the "HAT icon" (first icon)

  4. Copy the "Hierarchy ID" and "Date From" (if exists) and close dialog

  5. Run SE37 transaction

  6. Run function module "RRSI_VAL_SID_SINGLE_CONVERT"

  7. Enter "0HIER_HIEID" for I_IOBJNM and the "Hierarchy ID" for I_CHAVL

  8. Copy value returned in "E_SID"

  9. Run function module "RRHI_HIEDIROLAP_READ" (SE37 transaction)

  10. Enter the "E_SID" value for I_HIESID and "Date From" copied for I_HDATE

  11. Check details of hierarchy and sum values "cardfix" + "cardrest" + "cardintvl"

  12. If the sum of these values is greater than the value defined in parameter RSR_HIER_CARD_THRESHOLD, the hierarchy is considered large and Analysis for Office will disable the search for this hierarchy.

Hierarchies based on CDS views are always treated as large regardless of their actual size, and consequently the search field is always disables.
For this case the parameter RSR_HIER_CARD_THRESHOLD is ineffective.

On this case apply the SAP note 2879713 - Wrong information on transient hierarchy cardinality

Keywords

grayed out, greyed out, search, hierarchy, hierarchies, disabled , KBA , BI-RA-AO-XLA , Excel Addin , How To

Product

SAP Analysis for Microsoft Office all versions