dbTalk Databases Forums  

week dimension error

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


Discuss week dimension error in the microsoft.public.sqlserver.olap forum.



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

Default week dimension error - 05-17-2005 , 07:44 AM






I have table only datetime column. I created time dimension with year,week
level. unfortunately, when wizard shows preview data, i get error message
"Detected 2 subling members with the same name : week 10" I deleted 10 th
week days from table then it showed weeks else week 9. I see that analysis
server says week10 for both week9 and week10. how can do this? why it says
week10 between "02.20.2005" and "02.27.2005" ?




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.