I have tried to build a parent child dimension. I used csv file attached. There is a parent column (overordnet_konto) and child column (konto) and name column (kontonavn). I have imported it to sql server, then I have built parent-child dimension in SSAS. I have defined overordnet_konto as parent. The fact table conains data on lowest level (key is konto). When I view dimension in a browser in SSAS, I see just lowest level, where as there should be two levels till.
What is it that I do wrong.
Looking forward to hearing from someone with a solution.