i need to create a report based on 4 views for this i have created 4 database views and i imported them in physical layer also.
here problem is all the four views contains dimensional attributes.
In physical layer i need to make joins but here how can i define which is Fact and which is dimension as all the views contains descriptive values only , no numerics.
Thats fine, you can go with joins with char datatype columns.
Regarding the Fact.. look for the table which got more joins with other tables among 4 views..
If you didnt find anything nothing wrong to choose any one.