I am just wondering if it is possible to create a business model for self joins, that I can later use with saiku-reporting.

Kaapa: from IRC says that you can't have self joins. But I can achieve that by creating a new business view for the same table

But if I do that, I will have duplicate views
For ex: If I have a table called "Student" and If I want to achieve self join on this. I need to have two views "Student" & "Student-Copy-For-selfjoins".

I understand this solves the problem but it appears ugly specially for end users.

Have you ever come across this situation before? If so, I am curious to know how you solved it.

Thanks for your time!