View Complete Post
im trying to process a cube and im geting this error:
OLE DB error:the qurery has been canceled because the estimated cost of this query (1039) exceeds the configured thredshold of 300
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??
When I try to process a cube it starts by processing the first dimension but nothing seems to happen.
I've tried processing each dimension separately and they all start but never complete. No errors are reported.
I pulled the cube in visual studion and from the Data Source View I can browse the data. However, when I try to process the cube or each dimension I get the same symptoms.
Analysis Services is running under a domain service account which has sys admin rights on the server.
Can anyone shed some light as to why this would happen?
I've processed a cube many times before and have never come across this.
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.
can we process the cube exists in the remote system, using vb.net/c#
i am able to process in the same system, where analysis service available.
i couln't process this from the client system.
is there any soluctions?
Is it possible to process a single cube dimension on SSAS via SQL Server scheduled tasks? Any help is preciated.
I want to build multi-language website in asp.net 2008 and asp.net 2010. So, which process is better for building application? Using either Local and Global Resource or New Folder to make separate according to language?
Application performance should be good and also easy manageable.
Please suggest me in which way I will build the application either using resource or folder. If there is any other better solution then please share.
The new .NET Framework 4.0 maintains backward compatibility while allowing core innovations by using a new feature called In-Process Side-by-Side. Learn about how it works and some problems it didn't solve.
Luiz Fernando Santos, Jesse Kaplan
MSDN Magazine December 2009
See how you can streamline your team projects using Process Templates in Visual Studio Team System (VSTS)
Brian A. Randell
MSDN Magazine December 2008