I have a cube,

I use a table named employee as my dimension table, a table order as fact
table.

When a employee quit, I delete it form the employee, but I reserve his sales
records in order table.

When I manage the cube, it is ok with Analysis 2000(Sql2000), but fail with
analysis 2005(Sql2005).



How can I do with sql2005?

Hello,

You are posting to the IIS newsgroup (a webserver). Your question is related
to SQL Server and is better answered in the SQL Server newsgroup.

--
Regards,
Kristofer Gafvert
http://www.gafvert.info/iis/ - IIS Related Info


"ad" <flying [at] wfes.tcc.edu.tw> skrev i meddelandet
news:uhDm09DOIHA.748 [at] TK2MSFTNGP04.phx.gbl...
>I have a cube,
>
> I use a table named employee as my dimension table, a table order as fact
> table.
>
> When a employee quit, I delete it form the employee, but I reserve his
> sales records in order table.
>
> When I manage the cube, it is ok with Analysis 2000(Sql2000), but fail
> with analysis 2005(Sql2005).
>
>
>
> How can I do with sql2005?
>
>
>
>
>
>