Errors in the high-level relational engine. when building cube with DSV with two different data
There error is:
Errors in the high-level relational engine. The following
exception occurred while the managed IDbCommand interface
was being used: Could not locate registry entry for OLE DB
provider 'SQLNCLI.1'..
The SQL executed looks like:
FROM
OPENROWSET
(
N'SQLNCLI.1',
N'',
The cube builds fine if the measure is not added from the secondary source, once added it fails to build. You can view the secondary datasource in the Data Source view fine and in the Cube Structure table diagram.

