Home Dashboard Directory Help
Search

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


Status: 

Closed
 as Fixed Help for as Fixed


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

Description


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)
Details
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