I created a cube in SSAS, how I can extract real time data from the data source to my cube?
I mean if any data modification (insert, update, delete) happens, SSAS should update the cube.
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It only takes a minute to sign up.Sign up to join this community
From the documentation:
Proactive caching provides automatic MOLAP cache creation and management for OLAP objects. The cubes immediately incorporate changes that are made to the data in the database, based upon notifications received from the database. The goal of proactive caching is to provide the performance of traditional MOLAP, while retaining the immediacy and ease of management offered by ROLAP.
The subject is a bit broad for an answer and there are quite a few options and drawbacks to consider.
In general you check the box "enable proactive caching" and pick some latency options:
and then you specify a tracking table on the "notification" tab: