CODEWITHSUNDEEP
sql-serverssasolap
Sherif
Sherif

Reputation: 121

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

Upvotes: 2

Views: 985

Answers (2)

Preet Sangha
Preet Sangha

Reputation: 65496

We use a SQL CLR proc call to the ADOMD to issue the XMLA command.

Upvotes: 0

Luka Milani
Luka Milani

Reputation: 1541

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

Upvotes: 2

Related Questions