Search code examples
t-sqlssas

Update/Insert sql table from SSAS cube


Is it possible, preferably using tsql or MDX, to read data from cube and use it to update or add records in a sql table?


Solution

  • OPENQUERY can do this

    How to perform a SQL Server distributed query with OLAP Server