dbTalk Databases Forums  

With prosessing type (rebuild or incemental update) occures on dimensions?

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap


Discuss With prosessing type (rebuild or incemental update) occures on dimensions? in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Marco Della Casa
 
Posts: n/a

Default With prosessing type (rebuild or incemental update) occures on dimensions? - 10-08-2004 , 09:20 AM






Hi

for me its not clear witsh processing occures on a full database prosse in
AM? When I process all dimension a incremental update will be done and I see
this in the prossessing activities.

An other thig that a don't understand is, when I make a full process on a
cube same dimensions are incremental updated. But I have't check the
incremental update in the window.

Thanks for any informations.

Marco



Reply With Quote
  #2  
Old   
Mingqing Cheng [MSFT]
 
Posts: n/a

Default RE: With prosessing type (rebuild or incemental update) occures on dimensions? - 10-11-2004 , 08:06 AM






Hi Marco,

Thanks for your post.

From your descriptions, I understood that you would like to know when cube
process will occur on a full database in Analysis Manager. Have I
understood you? Correct me if I was wrong.

Based on my scope, we could learn from BOL that when you process a cube,
the aggregations designed for the cube are calculated and the cube is
loaded with the calculated aggregations and data. Processing a cube
involves reading the dimension tables to populate the levels with members
from the actual data, reading the fact table, calculating specified
aggregations, and storing the results in the cube. After a cube has been
processed, users can query it.

After making structural changes to a cube, you must process the cube before
attempting to browse its data. Process your cube after completing any of
the following:
-- Building the cube and designing its storage options and aggregations
-- Changing the cube's structure (measures, dimensions, and so on) and
saving the changes to the cube
-- Changing the structure of a shared dimension used in the cube

See the following documents for further detailed descriptions about this

Cube Processing
http://msdn.microsoft.com/library/de...us/olapdmad/ag
cubesprocess_1zg3.asp

Processing Cubes
http://msdn.microsoft.com/library/de...us/olapdmad/ag
processcubes_2nua.asp

Cube Processing Settings Dialog Box
http://msdn.microsoft.com/library/de...us/olapdmad/db
oxcubesetting_9a9k.asp

Thank you for your patience and corperation. If you have any questions or
concerns, don't hesitate to let me know. We are here to be of assistance!


Sincerely yours,

Mingqing Cheng

Online Partner Support Specialist
Partner Support Group
Microsoft Global Technical Support Center
---------------------------------------------------------------
Introduction to Yukon! - http://www.microsoft.com/sql/yukon
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.