Artículos IT, información y publicaciones sobre Linked server

Últimas publicaciones destacadas en Dataprix sobre esta temática TIC

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..

Syndicate content