Hierarchy Unknown Member error

Some users are getting the attached error. “A Hierarchy unknown member cannot be used as a parameter value…”. when running our dashboards.

Extra info. The hierarchy it is referring occasionally changes. Members of this hierarchy get moved, renamed, created, and deleted. We believe that the hierarchy changing is what might be causing this error, however, most of us are not getting this error -The same dashboards continue working fine except for a few individuals.

Hi Anthony,

It actually sounds like the hierarchy members are still stored in the member and might be related to the hierarchy expiration settings.

By default the filter values would be cached for a certain period, and you can change that. You can do this from the config setting, Hierarchy Cache Absolute Expiration. However, this setting will affect all filters.

You can also use a script in dashboard load event to bypass hierarchy cache for a specific filter instead of setting for all filters, like this:

parameterHierarchy1.control.bypassHierarchyCache = true;

To read more on this topic:

https://www.dundas.com/support/learning/documentation/data-metrics/refresh-data-in-dundas-bi#h4-bypass-the-hierarchy-cache]