Hello,

I have an OLAP cube (SQL 2k SP3) that is based on a SALES table structure (SQL 2k SP3). The underlying fact table is updated every 24 hours with the previous days sales.

I want to put an Incremental update into effect so that only yesterday's data will get inserted into the cube.

I am not able to create a filter to do that. Most of the filter examples I have seen talk about "Month"='January' but they do not cover on using formulas to calculate yesterdays date so that I can do something like:
"Sale_Date"=DateAdd ('d', -1, GetDate() )

tia,

Raj More.

What I typically recommend is that customers create a view on-top of the fact table which exposes only the data which has changed. A more advanced method would be to create a control table with beginning and ending date stamps -- and then have the view do a join between a timestamp in the fact table (e.g. DateEntered) with the control table. Then use that view as the fact table for the incremental update.
--
Dave Wickert [MSFT]
dwickert (AT) online (DOT) microsoft.com
Program Manager
BI SystemsTeam
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.

"Raj More" <rm (AT) tek (DOT) com> wrote

Hello,

I have an OLAP cube (SQL 2k SP3) that is based on a SALES table structure (SQL 2k SP3). The underlying fact table is updated every 24 hours with the previous days sales.

I want to put an Incremental update into effect so that only yesterday's data will get inserted into the cube.

I am not able to create a filter to do that. Most of the filter examples I have seen talk about "Month"='January' but they do not cover on using formulas to calculate yesterdays date so that I can do something like:
"Sale_Date"=DateAdd ('d', -1, GetDate() )

tia,

Raj More.