Guenter

Thanks very much for your ideas/suggestions. I think they have helped me understand the problem I have and I can now move forward.

Noch mal vielen Dank!

Regards,

J

Thanks for that Steve.

Would you be able to expand on those methods a little? I've be looking at it since you replied and can't quite work it out.

Regards,

J

Thanks Daniel but that article concerns parent/child SQL queries not the creation of a SSAS dimension to reflect that relationship.

As I said, I already create a dimension with the parent/child...

Does anyone have any ideas ? This is still an issue for me!

Brilliant. Thanks for that. The Import/Export wizard is exactly what I was looking for.

J