Can I create a view that looks at multiple Schemas but doesn't select distinct table names?
I would like to create a view that looks at multiple schemas and will give all tables, regardless of name. For example, we have two Dim_Customer tables on different schemas but only one is being returned when I create a SQL server non-schema specific data source.
Short of moving the joining of tables to the reports is there another way to join Schemas?
Or, if that's not possible, is there a way to turn on Schema and table prefixes in the view builder?