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.
olapsql serverssas
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.
Best Answer
You need to look into proactive caching for your partitions and dimensions where you can set up notifications based on a tracking table.
From the documentation:
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:
What all the options such as enable ROLAP aggregations and the latency settings do is explained in more detail in this blog post or this one