How to connect to tables with same name in different schemas?
22 March, 2016
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
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
Hi Robin,
unfortunately the functionality you have described is not currently possible in the Yellowfin View Builder. However we have had 2 previous requests for this from other customers, so there already exists an enhancement request - 131111, and I have added a note to it that you also would like such a new feature.
I do know that I have definitely heard talk of revamping the View Builder soon, although not sure if it will be in 7.3 or later.
regards,
Dave
unfortunately the functionality you have described is not currently possible in the Yellowfin View Builder. However we have had 2 previous requests for this from other customers, so there already exists an enhancement request - 131111, and I have added a note to it that you also would like such a new feature.
I do know that I have definitely heard talk of revamping the View Builder soon, although not sure if it will be in 7.3 or later.
regards,
Dave