SSAS dimension process

In SSAS(SQL Server Analysis Service), big dimensions like dimensions related to daily sales or ticket booking will have millions of rows. Thousands of row can be inserted in the dimension on daily process. Processing these type of dimensions on daily basis will take long time.

Microsoft, some place refer to use ProcessAdd to process the dimension by XMLA code. But it was not supported by tool process, it was not recommended by microsoft.

ProcessAdd - This wont handle changes in the existing dimension data like updation, deletion. It can handle new inserted data only.

XMLA code segment to process dimension by ProcessAdd is not clear. We can do ProcessAdd by two types:
1) Push method
2) Pull Method

Push Method:
New data needs to be added will be hard coded and make the XMLA to process the dimension. Some samples are available online
Negative - XMLA handling is tough,
Positive - Dimension process will be faster

Pull Method:
We need the pull the data added newly. This is simple and XMLA handling is very easy when compare to push method. Samples available in net wont work normally.
Negative - Process performance is slow when compare to push method
Positive - XMLA is very easy to handle


Sample:
Create the dimension with source or view and process the dimension and cube. Right click on cube, generate XMLA alter script. We need to use the dimension attribute XMLA script to process the dimension by ProcessAdd.

Sampe XMLA code  to process the dimension by ProcessAdd Pull method.