User defined hierarchy in cube (dyslexia) <p>I can make 6 level dimension hierarchy with such relationships:</p> <ol> <li>main -> lvl1</li> <li>lvl1 -> lvl2</li> <li>lvl2 -> lvl3</li> <li>lvl3 -> lvl4</li> <li>lvl4 -> lvl5</li> </ol> <p>Hierarchy looks fine in the dimension browser. All attribute keys are composition keys of each other.</p> <p>When i try to use dimension in cube, with main as key to measures, it will fail citing: 'Attribute key 'main' not found..'</p> <p>In the measures are all members of the dimension hierarchy.</p> <p>is the relationship faulty or what is missing?</p>