dbTalk Databases Forums  

design question

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap


Discuss design question in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Steffi
 
Posts: n/a

Default 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.



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.