Home Dashboard Directory Help

BISM - The 'Hierarchy' with 'ID' = 'xxxx' doesn't exist in the collection. by Darren Gosbell


 as Fixed Help for as Fixed

Sign in
to vote
Type: Bug
ID: 785963
Opened: 4/30/2013 5:56:47 PM
Access Restriction: Public
User(s) can reproduce this bug


When you create a hierarchy with "special" characters in the name. (eg a full stop) and then try to create a perspective that includes this hierarchy you will get an error when you try to deploy your tabular model.

This happens because the <HierarchyID> in the dimension strips out special characters, but the <HierarchyID> in the <Perspective> tag actuall reference the name property of the hierarchy (which includes "special" characters)
Sign in to post a comment.
Posted by Microsoft on 7/24/2013 at 3:58 PM
Thanks for the bug report. We have fixed this and it should be available in an upcoming CU. Right now it is slated for CU5.
Sign in to post a workaround.
Posted by Darren Gosbell on 4/30/2013 at 6:05 PM
If your bim file is corrupt start by taking a back-up copy of this file to another name/location.

Then right-click and "View Code".

Then search for the hierarchy ID which could not be found. The first reference you find should be the Hierarchy itself, copy the actual HierarchyID value and continue searching for the hierarchy name. The next value(s) you find should be for hierarchy references within perspectives. Replace the values in the persepective references with the actual hierarchy ID value (which will not have any "special" characters).

Save your bim file.

Close and re-open your solution.
Posted by Darren Gosbell on 4/30/2013 at 6:01 PM
Avoid using any "special" characters (like punctuation characters) in hierarchy names
File Name Submitted By Submitted On File Size  
Adventure Works Tabular - Broken.zip 4/30/2013 40 KB