Hi,

I have a connection pointing to a SQL server 2014 database.

On said database we have multiple schemas and some object names are duplicated across these schemas e.g.

report.Dim_Month
ssas.Dim_Month

when I create a Yellowfin view I don't seem to be able to choose one of the two views i.e.

I can enter "Dim_Month" into the search and it just shows one result without a schema prefix (in our case when I look at the properties of the table after selecting I can see it selected ssas.Dim_Month).
When I enter the schema prefix the search fails completely.

So how do I specify the particular object I wish to use?

Note I can't limit the connection to a particular schema as I need to be able to query across schemas.

thanks
Robin