Thanks for your answer, but I have admin access on VDP. if i have 1 join layer or 2 join layer lavel we are good. if you have few layers, I am seeing this issues.
suppose assume. A inner join with B -> result set would be "C", now C was making as a aggregaed data as 'D' and innerjoin with E -> F. so our final derived view is "F" right here. when I am trying to see the F query excution paln ...
F->Name<unnamed private wrapper>->Name<unnamed private wrapper>>Name<unnamed private wrapper>(DB level)..
but I am getting the expected datea from "F", but when I go query excution plan I am seeing the like this. I am not sure,I am making anything wrong here ? or privileges issues?