Dimension ProcessAdd in SSAS
September 4th, 2013 in Analysis Services, BlogWhen you have very large dimensions in SQL Server Analysis Services (SSAS) cubes, the time taken to process them can cause a problem. This post builds upon an excellent walkthrough of the ProcessAdd option written by Daniel Calbimonte on MSSQLTips.com. and shows how to automate the identification of new data to be added. What are the main options for processing a dimension? (Technet details here) Process Full – the whole dimension is…
» Read more