dbTalk Databases Forums  

Yukon - Slowly changing dimension

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


Discuss Yukon - Slowly changing dimension in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
tarana halsall via SQLMonster.com
 
Posts: n/a

Default Yukon - Slowly changing dimension - 01-16-2005 , 10:53 PM






Do the SCD start, end and currernt attribute Types have
any purpose other than documentation?

I tried playing around with these values and AS does not
seem to use them to decide which dimension gets
displayed - that is, the inactive member got listed along
with the new member.

And as source table filter feature seems to have been shifted to the dsv, do we need to define views for all our dimensions to filter out members other then "current"?

I have tried posting this on a Beta news group, but have not been able to get to the bottom of this yet

thanks

--
Message posted via http://www.sqlmonster.com

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.