Is it possible to process a single cube dimension on SSAS via SQL Server scheduled tasks? Any help is preciated.
View Complete Post
Have any one noticed this behavior??
Incremental process (process update) of dimension generates reprocessing of indexes on all cube's partitions,even when no change has occured in that dimension.
I am using SSAS 2005 sp2.
This is disturbing because my cube holds some 700 daily partitions so processing indexes on all of them - on an hourly basis - is very time consuming.
Also it flashes that cube's cache!
I did noticed that changing heirarchies memberskeysunique property to True + changing the toppest attribute in this heirarchy mambernamesunique to true solves this problem.
Is this a must then to prevent recalculating indexes on partitions every process update of dimension??
I need to process a SSAS 2008 cube's dimension by a T-SQL query, using a SQL agent job.
How can this be done.
hello every one
i bought a hosting plan that allows me to send about 500email/per hour
but my client wish to send about 2000 or 3000 email at a time
is there a way to split them and 500 email per a time automaticly without the need of reloging again every hour
my hosting plan doesn't allow me to create a sql jop or send mails via Sql Server.
any bright ideas ?