October 9, 2010 at 4:31 am
hi all.
do the only way for process cube automatically is ssis package and then using job in ssms?
do another way exist for process cube automatically?
October 11, 2010 at 1:45 am
It can be processed by Proactive caching. In Proactive caching, you need not to schedule it by SSMS. Analysis Services will take care.
http://www.msbiconcepts.com/2010/10/implementation-of-proactive-caching-in.html
Thanks,
Amit G
http://www.msbiconcepts.com
October 11, 2010 at 10:58 pm
hi amit.
proactive caching only cach new data but not process cube.I examine it, but process cube manually to brows cube to see changes.
October 13, 2010 at 3:36 am
It process the cube data based on silence interval defined in your cube.
http://www.msbiconcepts.com/2010/10/proactive-caching-sql-server-2008.html
Thanks,
Amit G
http://www.msbiconcepts.com
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply