parent-child dimension problems in SSAS


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.

Who is Participating?
agandauConnect With a Mentor Commented:
Attached are some pointers.  Maybe you got way further than this.  Hope it helps.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.