One of the features of AS 2005 that is key in my decision to migrate to
2005 from 2000 is the ability to process a dimension by adding new
members only. I want to do this for a Fact dimension that will
potentially contain millions of members. Incremental refresh in 2000,
which is ProcessUpdate in 2005, does a full read of all those dimension
records, and this is simply not an option for us.

Incremental dimension refresh corresponds to the processing option
ProcessAdd in the Processing Options table in the Analysis Services
2005 Processing Architecture doc
(http://msdn.microsoft.com/sql/bi/ana...sprocarch.asp).
I am using SQL Server 2005 Developer addition (same featrure set at
Enterprise addition). I am able to select and configure Process
Incremental for a partition in BI Studio, but the option is not present
for dimensions. Does anyone know how to exploit this feature of AS
2005?

This whitepaper has a lot of good information:
http://msdn.microsoft.com/library/de...asprocarch.asp
(Look for the ProcessAdd topic)

Essentially you would need to use the ProcessAdd type, define a new DSV that
specifies the new rows in the dimension and include that DSV in the process
request...

Thanks,
Akshai
--
This posting is provided "AS IS" with no warranties, and confers no rights
Please do not send email directly to this alias. This alias is for newsgroup
purposes only.

<david_h_petiot (AT) hotmail (DOT) com> wrote