Skip to Content

Search on hierarchy in Analysis for Office


Hi all,

Some times you try to filter by member on a specific hierarchy and the search box appears as grayed out (disabled) so you are not able to use the search functionality.

The KBA 2111196 "Search on hierarchy disabled in Analysis for Office" created by @Filipe described how to analyze the hierarchy size and check if you are using the default size (50000) or if you are with a large number (when the search box start grayed out)

Kind regards,
Diego Ferrary