Groups | Blog | Home
all groups > sql server data warehouse > july 2003 >

sql server data warehouse : Impact of Full Process Cube Related to Dimension Update


Steven Wong
7/16/2003 3:53:53 PM
Hi:

When a full process of an OLAP cube is perform, does it
also automatically perform a restructure/"full process" of
the related dimensions? Or does the restructure/"full
process" of the related dimensions need to be handled
separately?

Thanks!
..

Jono Indrawijaya
7/18/2003 10:38:17 AM
As quoted from MOC :
Implications of Performing a Full Process on a Cube
The following are important implications of performing a full process on a
cube:
- If the cube is MOLAP, it is erased and rebuilt.
- Regardless of cube storage-MOLAP, ROLAP, or HOLAP-aggregations are erased
and rebuilt.
- Any virtual cubes based on the cube are unavailable after the process
until they are reprocessed themselves.
- All partition data is read into the cube from the RDBMS data sources.
- All private dimensions are rebuilt.
- If a shared dimension belonging to the cube has been modified structurally
and needs to be rebuilt, the dimension will automatically rebuild when the
cube is processed. All other cubes that use the same shared dimension will
not be available again until they have each been reprocessed.
- If an error occurs, the operation is rolled back.

--
Hope it helps :)
Regards,
Jono Indrawijaya - MCDBA
PT. eBiz Cipta Solusi - Microsoft Certified Partner
Indonesia

[quoted text, click to view]

AddThis Social Bookmark Button