Creating a Data Source View from multiple Data Sources is no problem but what happens when you try to create the actuall Report Model. Using the primary Data Source doesn't give access to other databases, since each table name starts with dbo. Is there a option/flag to set to include database name?
Report Model DSVs only support one database, to pull in data from other databases you'll need to create a Named Query.
Analysis Services, on the other hand, don't have that problem, except for being limited to one database per DSV.
Note: I'm pretty sure I'm correct, but not 100%
sql
No comments:
Post a Comment