Multiple data sources in a report model

I've built several data view sources and report models and think its great.
But this week I'v ran into problems. I'm trying to implementent a report
model that uses data from three databases. I've managed to build the data
source view containing tables from all three different data sources, but when
I try to build the report model it fails. It seems that it can't find tables
in other data sources that the primary.In SQL Server 2005, a report model can have only one data source file, one
data source view file, and one smdl file. What you are attempting to do is
not a supported scenario in this release.
"Erik Hedlund" wrote:
> I've built several data view sources and report models and think its great.
> But this week I'v ran into problems. I'm trying to implementent a report
> model that uses data from three databases. I've managed to build the data
> source view containing tables from all three different data sources, but when
> I try to build the report model it fails. It seems that it can't find tables
> in other data sources that the primary.|||Hmm, this is very limiting, because the data source view can contain tables
from several datasources. It's rather odd that the report model should be
concerned about lies bellow the data source view abstraction layer.
"Katmac [MS]" wrote:
> In SQL Server 2005, a report model can have only one data source file, one
> data source view file, and one smdl file. What you are attempting to do is
> not a supported scenario in this release.
> "Erik Hedlund" wrote:
> > I've built several data view sources and report models and think its great.
> > But this week I'v ran into problems. I'm trying to implementent a report
> > model that uses data from three databases. I've managed to build the data
> > source view containing tables from all three different data sources, but when
> > I try to build the report model it fails. It seems that it can't find tables
> > in other data sources that the primary.|||Multiple data source support is on the wish list for a future release.
"Erik Hedlund" wrote:
> Hmm, this is very limiting, because the data source view can contain tables
> from several datasources. It's rather odd that the report model should be
> concerned about lies bellow the data source view abstraction layer.
> "Katmac [MS]" wrote:
> > In SQL Server 2005, a report model can have only one data source file, one
> > data source view file, and one smdl file. What you are attempting to do is
> > not a supported scenario in this release.
> >
> > "Erik Hedlund" wrote:
> >
> > > I've built several data view sources and report models and think its great.
> > > But this week I'v ran into problems. I'm trying to implementent a report
> > > model that uses data from three databases. I've managed to build the data
> > > source view containing tables from all three different data sources, but when
> > > I try to build the report model it fails. It seems that it can't find tables
> > > in other data sources that the primary.|||If the product doesn't allow a DSV to have multiple data sources, then you
shouldn't be able to save a DSV that references more than 1 DS. I just
wasted three hours trying to track down this "bug." Certainly would have
saved me time had VS just told me it didn't support more than 1 data source
in a dsv. instead, I got a cryptic message at model generation time that it
coudln't find a table.
"Katmac [MS]" wrote:
> Multiple data source support is on the wish list for a future release.
> "Erik Hedlund" wrote:
> > Hmm, this is very limiting, because the data source view can contain tables
> > from several datasources. It's rather odd that the report model should be
> > concerned about lies bellow the data source view abstraction layer.
> >
> > "Katmac [MS]" wrote:
> >
> > > In SQL Server 2005, a report model can have only one data source file, one
> > > data source view file, and one smdl file. What you are attempting to do is
> > > not a supported scenario in this release.
> > >
> > > "Erik Hedlund" wrote:
> > >
> > > > I've built several data view sources and report models and think its great.
> > > > But this week I'v ran into problems. I'm trying to implementent a report
> > > > model that uses data from three databases. I've managed to build the data
> > > > source view containing tables from all three different data sources, but when
> > > > I try to build the report model it fails. It seems that it can't find tables
> > > > in other data sources that the primary.