design question -
06-13-2006
, 01:38 AM
hi,
I'm using AS 2000 to design cube and the fact table source is a view which
has one function column.
Here is the sample view,
create view vfactEmp
as
select
col1,
col2,
col3,
dbo.fn01(x,y) as col4,
sum(col5) as cnt
from table
group by 1,2,3,4
In my case, I found if I modify function "fn01", the measure of the cube is
missing.
I have to reprocess cube to get back the measure.
Why?
Thanks. |