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