MS SQL Server OLAP - ProcessAdd Dimension Refresh in 2005

Author

ProcessAdd Dimension Refresh in 2005

david_h_petiot@hotmail.com

2005-12-29, 11:23 am

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/an..._asprocarch.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?

Akshai Mirchandani [MS]

2005-12-29, 8:24 pm

This whitepaper has a lot of good information:
http://msdn.microsoft.com/library/d..._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@hotma
il.com> wrote in message
news:1135876055.270606.25460@g47g2000cwa.googlegroups.com...
> 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/an..._asprocarch.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?
>

Sponsored Links