Excel Add-on 3.0 -3.4 Cache loads parent hierarchy incorrectly when subsets are used as a dimension
This item has been identified as an outstanding known issue; a workaround is provided until the issue is officially fixed.
The issue occurs when a connection is created to a module containing a list subset as it will incorrectly load the parent hierarchy into the cache. When you subsequently attempt to create a connection to a module that contains any of the parent hierarchy as a dimension, only the items (and their parents) that are members of the subset will be shown.
This will manifest on the pivot and filter screen.
Clear the cache. On the excel add-in this can be done by signing out. To prevent this from manifesting establish a connection to the desired module containing the subset first.
If this workaround is not suitable in your use case, please contact Support at email@example.com.