Showing posts from June, 2012

SSIS - 0x80040155-Interface not registered

Getting error as showed in figure 1 when I tried to create new SSIS package.  Fig 1 This is due to msxml3.dll and msxml6.dll crash. we an reregister the dlls by using below commands in run ( start->run) regsvr32 msxml3.dll regsvr32 msxml6.dll

SSAS - Options for Cube and Dimension processing

Options available for processing cube and dimensions are almost same. Cube is having couple of more options than dimension. Cube There are 7 different types of options are available for cube processing. Process Full – Server checks the storage mode and if the mode is MOLAP, server reads the from the relational data and store it in a compact format. If there were aggregations defined for the cube, the server will build those aggregations during these processing. Finally the server creates indexs for the data that helps the speed access to data during querying. Process default – Server checks all the objects and process only those that have not been processed if the cube data has been processed and if aggregations and indexes are not processed, then those are processed. Process incremental - Process only new fact data Unprocess – it will clear all the data in the cube that we have processed already. Process structure – Process all the cube dimensions and the