Building dimension for level hierarchy dimension with 2 info

[ramaanujamr]

Hi, I am building student info as dimension. I am pulling the data from 5 different tables. I created one datasource and i add all 5 tables information. I need to find student info and contact info. Student info is just looking for student school info and his address and contact details. Contct info is student parent contact info , student contact emergency info like that. So each student will have more number of conatct info in his school years. But my studentinfo dimension does not pull the contact info correctly. But i  can do it in sql but i cant do it DM. I used star schema to build this dimendion. Do i need to look for some other option? Do you any idea about this. or can i solve this problem with lookup table etcc.

Any suggestion is appreciated.

Thanks
Ram

[UseCog]

Hi,

Have you got this issue solved...

otherwise, can you tell me something about the dimenion you want to be created.Do you want all parent information for a student in the dimension or you want only the latest parent information for that student.

[leodwe]

what is the details.