SQL Server Administration, and tips for Integration Services (SSIS) and Analysis Services (SSAS)

Datos inmemory en SQL Server 2014This SQL Server eBook compile our best articles about SQL Server administration and development, including posts about Database Administration, for SQL Server DBA's, and about the Business Intelligence components of the Database, the ETL tool SQL Server Integration Services (SSIS) and the OLAP tool SQLServer Analysis Services (SSAS).


How to use Openquery to make a join between a SSAS cube and a table from any other database


Connetion to SSAS instanceImagine you need a report with data from an OLAP sales cube, and have to include data from a table of the relational data source, or from an external database.

With a linked server you can construct a MDX query in the SQLServer instance where you have the cube, joining with an external database to complete the data with information from tables of the relational database..