I have a situation where our datawarehouse is updated
twice a day and Analysis Services once a day.

When processing cube where do I setup my filter in
Analysis Manager to only process the datwarehouse with
dimension values and measures from the fact table WHERE
the date dimension is greater than today?

Yes. You have two options. When you do incremental processing either you
setup an advanced filter to only expose the new rows; or you change the fact
table. What I typically advise customers to do is to have a control table in
your RDBMS which contains the date/time you wish to set as the beginning
period for the incremental data. Create a view which does a join between the
fact table and this control table over this date/time field (obviously you
need a date/time stamp in your fact table for this to work). Then when you
do an incremental process, tell AS that you want to use the view as the fact
table for the incremental processing.

That way, the only thing you need to do is set the correct date/time value
in the control table and then kick off incremental processing. Nothing is
hardcoded; everything is driven off that control table. Thus if you miss a
day; or have a long weekend; or you want to start doing incrementals more
often, you can use the same infrastructure.

Hope this helps.

--
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.

<anonymous (AT) discussions (DOT) microsoft.com> wrote

If you can, can you show us how this advance filter would
look like for the "new rows"? Does it look something
like this?

"Sales_Fact"."DatePurchased" >= getdate()