Search code examples
sql-serverssasolap

SQL Server Analysis Services, update OLAP dimensions from relational database

I have OLAP analysis services related with relational database.when the data updated or changed in relational database I must make process operation manually in my project(project to build the OLAP from relational database) to push the new data in OLAP.

I want every change in relational database to affect the OLAP automatically.

Thanks in advance

Solution

  • This is called: "Proactive Caching feature in SQL Server Analysis Services"

    Assuming that you are using Sql Server 2005 or later version this article help you:

    Configure Proactive Caching feature in SQL Server Analysis Services 2005

    To know more: What is and how does it work the Proactive Caching

    In case you still have doubts, here another article:

    Implement Proactive Caching in SQL Server Analysis Services SSAS

    Hope it help