My fact table join with a dimension table with a foreign key.

But there some foreign key in the fact table which doesn't exist in the
dimension table.

When I add the dimension in cube, all no match rows will be filtered out

Can I reserve all the rows in Fact table when add the dimension in cube?

What do you mean by "reserve rows" ?
If you do not want to take these rows into account when refreshing cube
data, then use a view where you write the necessary logic.
In fact, always use a view for loading data in the cubes. It saved me a lot
of work...

Hth,
Tom


"ad" wrote: