dbTalk Databases Forums  

newbie member key question

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


Discuss newbie member key question in the microsoft.public.sqlserver.olap forum.



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

Default newbie member key question - 08-20-2003 , 09:09 PM






What is the significance of a member key unique property for a level ?

If I have a table like this:

col1 int
col2 char(3)
col3 char(3)

with values:
col1 col2 col3
----- ----- ------
1 abc abc
2 abc abc
3 def xyz


I have setup a dimension called def with one level, col3.
The member key is col2 and the member name is col3.

The member keys unique is set to true and the member Names unique is
set to false for this level.

Why doesnt Analysis services complain about the duplicate key values
in col2 column in the database ?

-John.

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.