Hi all,

In my fact table there are some records for which I do
not have a mapping reference to dimension table. Even
then the cube is getting processed successfully.

My assumption was that the cube would fail on such cases
since the fact table would fail in finding the
corresponding foreign key relation in the dimension table.

Any suggestions on this would be helpful

Thanks
Gomathi Sarma

If you look at the SQL statement, the default for an unoptimized schema is
to form an inner join between the fact table and the dimension tables. This
means that missing dimension rows just "disappear" before AS even gets them.
If you optimized the schema (using the Optimize Schema tool in the Cube
Editor), you will start seeing error rows.
--
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.

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