Real time data push in to SSAS cube is very much possible.
There are different ways of doing it, How ever you have explore & see which one best fits your needs
The below are some of the options :
1) Push the data directly from the WH in to SSAS cubes using SSIS Package.
ex: Lets say there is a product dimension & Orders Fact table , in the SSIS package which loads the data in to these tables we can extend them to push the data to Product dimension & Orders Fact of OLAP cube.
2) Proactive Caching based on policy based management. The Policy settings - SilenceInterval, SilenceOverrideInterval, ForceRebuildInterval & latency play very important role.
But how do we get the data changed notifications from the data source, Here are the options :
1) use event trace entries
2) application can notify through webservice call
3) by polling the data source using sql queries to see if data has changed using a timestamp or any other column.
There are different ways of doing it, How ever you have explore & see which one best fits your needs
The below are some of the options :
1) Push the data directly from the WH in to SSAS cubes using SSIS Package.
ex: Lets say there is a product dimension & Orders Fact table , in the SSIS package which loads the data in to these tables we can extend them to push the data to Product dimension & Orders Fact of OLAP cube.
2) Proactive Caching based on policy based management. The Policy settings - SilenceInterval, SilenceOverrideInterval, ForceRebuildInterval & latency play very important role.
But how do we get the data changed notifications from the data source, Here are the options :
1) use event trace entries
2) application can notify through webservice call
3) by polling the data source using sql queries to see if data has changed using a timestamp or any other column.
No comments:
Post a Comment