Skip to Content

Unable to Link Dimensions with Hierarchy enabled

Nov 29, 2017 at 11:10 PM


avatar image
Former Member


We are facing issue while Linking Dimensions with Hierarchy enabled on the common Dimension. Linking works when its a flat list, however on enabling the Hierarchy, it returns an exception.

An exception occurred in one of the data sources. SAP BI Add-in has disconnected all data sources. If you want to restart, press the Restart button below. (ID-111006)

Also Just to add that this works fine, when the Query is in display mode. This issue occurs once going into change mode.

Please note we are on Analysis for Office

Any help highly appreciated.


10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

avatar image
Former Member Nov 30, 2017 at 09:15 AM

Hi Ajay

I believe the below link will resolve your issue. I have checked at my end as well. I am able to perform what you have mentioned.



10 |10000 characters needed characters left characters exceeded