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?
I'd suggest that as a part of your data load you establish a process which
selects all the foreign keys from fact table that are not found in the
dimension and add them to the datasource for dimension (it can be a table or
a view). Then your dimension and cube will be consistent
Regards,
Ilona Shulman
Senior Development Consultant, DBA
SSE Inc
http://www.sseinc.com
"ad" <ad@.wfes.tcc.edu.tw> wrote in message
news:elh4y1lqEHA.1728@.TK2MSFTNGP10.phx.gbl...
> 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?
>
|||Analysis Services dislike bad data quality.
so you have to insure that all your keys in your fact table exists in your
dimension.
Generally we create an "unknown" member in the dimension.
For example, the key "-1" is the unknown dimension member.
Then every row in the fact table as the -1 as the default value, so if the
dimension member doesn't exists, your fact table contain -1 and can be used
in the cube.
Change your ETL process to do this job.
"ad" <ad@.wfes.tcc.edu.tw> a crit dans le message de news:
elh4y1lqEHA.1728@.TK2MSFTNGP10.phx.gbl...
> 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?
>
Thursday, February 16, 2012
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment