In many shops, I am guessing there are multiple servers. Development, Production, maybe a Staging, etc. With SQL Server Analysis Services (SSAS) and SQL Server Integration Services (SSIS), you set up data sources, connection to databases. In SSAS you usually have a connection which then you build your data source view off of, and in [...]