hi,
im new in analysis services 2005. is it possible to link 2 or more cubes together?
thanks,
cherriesh
Are you trying to associate two or more fact tables? If so, you handle that inside a single cube using multiple measure groups.
B.
|||It is also possible to link in measure groups and dimensions from other cubes using the Linked Object wizard.hi,
I have 2 databases from which my data will be coming from. How can I join this 2 databases in reporting services?
cherriesh
It depends on the structure of the data. There are a few options you can try, though none really involve joining 2 data sources together in Reporting Services - transforming the data for reporting is usually done with an ETL layer.
Build an ETL package to load the data into a temporary staging database or
Build a view in SQL Server using linked servers or 4-part naming to union the data together.
These are two ways to get the data together.
cheers,
Andrew
