Some of my dimensions point to columns in a table with hundreds of millions of rows. Is there a way to apply a filter when inc. updating the dimension so it will only look at a small slice of data instead of the whole table
Sometimes it takes an hour of processing just to add a single new member to the dimension
Thanks
ADA

You can load the dimension via a SQL view.
However, you should be careful. You should ALWAYS expose all dimension
members and they rely on Analysis Services to figure out what is new and
what has changed. It is very dangerous to add new dimension member
incrementally by just exposing the "new" members without the entire
dimension table.
--
Dave Wickert [MS]
dwickert (AT) online (DOT) microsoft.com
Program Manager
BI Practices Team
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.


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

dimension so it will only look at a small slice of data instead of the whole
table?