is there any reason as acustomer i am not supposed to create a view of multiple tables in business one. if not can the views be created in the query generator or do i have to be on the server?
you can create views in the database. The upgrade process will not remove them.
the only thing you cannot create are triggers, in this case, the upgrade will fail for the database.