.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
david stephan
Gaurav Pal
Post New Web Links

Process cube - other cubes get processed

Posted By:      Posted Date: August 30, 2010    Points: 0   Category :Sql Server
When I process a single cube other cubes are getting done as well. Am I right in assuming that is because they share dimensions ?

View Complete Post

More Related Resource Links

How to process just one cube in a solution of three cubes inside BIDS SSAS

Hi, I have a BIDS Solution with three cubes...I want to make a full process of just one of the cubes, but If am doing just one, the other cubes comes unavailable... How can I process just one without affecting the other ones? Thanks!

Determining the status os the Batch job that process SSAS Cubes

Hi All, I have a cube and that is processed through a batch job. The problem I am facing is there are many packages which are calling this Batch job to process the cube. Is there a way to determine the state of the job before the packages call this batch job to process the cube. And in which database can I find all the information about the jobs on the server. Thanks for your help. Vineeshvineesh1701

IS There is any way out to process only one partition of cube and data of other partition remain ava

HI ALL. Please let me know is there is any way out to process one partition only,while data of other partition remain available in the cube with the help of SSIS

Errors attempting to process SSAS Cube. I get Either user does not have permission to create a new o

Hi All, One of my production server deployed cubes i am not able to process the cube.When i tried to process the cubes i will get an Error: TITLE: Microsoft SQL Server Management Studio ------------------------------ Either the 'NA\gsad478' user does not have permission to create a new object in 'JNJAUSYSVR01', or the object does not exist.  (Microsoft.AnalysisServices)   Over the source server i do have sysadmin access and also  i have added read only role of particular cube. I right click on the database and tried to create new database of SSAS that also thrown with same error. Please help me in this regard.   Thanks, Gangadhar

How to process two month data only from 10 month data and 8 month data still available to the cube.

HI ALL, I have created cube in SSAS 2008 and created 10 partition on one of the measure which contains 30 day data per partition i.e 10 month data which is filtered on the basis of getdate() -30 to getdate() ,only date part included. Now i want to refresh data only for the last two partition i.e getdate()-60 to gedate() and also to sustain rest of the data i. e.-from getdate()_61 onwards. I have tried full process mode but in that case i have lost one day data. Please suggest whether it can be possible with the process data mode.if not kindly suggest the way how to perform the same.     Regards Amit   Regards Amit

error in process cube


hi all

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

any help?

dimension's incremental process generates processing on all partitions in cube


Hey eb

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??



Cube, Build, Deploy, Process

Dear all,

I'd like to get simple and clear explanation of the cube in data mining, and 3 notions we encounter a lot : Build, Deploy, and Process.

(1) What is the cube that is created when we deploy a mining solution/project?
  I wonder what type of cubes they are because although the dialog on deploy/process
  show that cube, after successful deployment we still don't see the cube in Cubes folder
  of the project.

(2) Why the SQL Server created that cube? Even though we process only one table
  and only use case-table (without nested table)

(3) Can someone explain these 3 concepts with CLEAR differences between them?
  (A) Build
  (B) Deploy
  (C) Process

As far as I know, the stages are like that : build, then deploy, then process.  Also, it seems
to me that those operations do not create objects inside 'Relational' database, but create
objects (binary and text, with text files usually in XMLA programming language) in the
related project's folders and subfolders.  Any good explanation is appreciated.


Cannot process a cube


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.



Process a SSAS cube's dimension by a T-SQL query



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.

is it possible to process the cube using vb.net/c# which exists in the remote server?




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?



Process SSAS cube's dimension by TSQL Query



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.



scheduled task Process a single cube dimension?


Hello experts,

Is it possible to process a single cube dimension on SSAS via SQL Server scheduled tasks? Any help is preciated.



ASP.NET Architecture - ASP.NET Worker Process - HTTP Pipleline - Http Modules and Handlers

"ASP.NET is a powerful platform for building Web applications, that provides a tremendous amount of flexibility and power for building just about any kind of Web application. Most people are familiar only with the high level frameworks like WebForms and WebServices which sit at the very top level of the ASP.NET hierarchy. In this article I'll describe the lower level aspects of ASP.NET and explain how requests move from Web Server to the ASP.NET runtime and then through the ASP.NET Http Pipeline to process requests.

For Multi-Language website which process is better in asp.net


 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.

CLR Inside Out: In-Process Side-by-Side


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

Team System: Streamline Team Projects With Process Templates


See how you can streamline your team projects using Process Templates in Visual Studio Team System (VSTS)

Brian A. Randell

MSDN Magazine December 2008

ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend