dbTalk Databases Forums  

what is a member in the OLAP world ?

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


Discuss what is a member in the OLAP world ? in the microsoft.public.sqlserver.olap forum.



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

Default what is a member in the OLAP world ? - 04-27-2005 , 01:10 PM






Hear a lot of members, member keys in the OLAP world.. What is it ?



Reply With Quote
  #2  
Old   
Michael Vardinghus
 
Posts: n/a

Default Re: what is a member in the OLAP world ? - 04-27-2005 , 04:12 PM






A member is a dimension value.

In the project dimension you can have member A, B and C.

Member keys typically refers to surrogate keys .... you have a fact table
containing the values but when linking this table to the dimension table you
normally don't use the original dimension codes A, B, and C - you make this
link with surrogate int keys ... but of course you show the corect codes as
member name.

"Hassan" <fatima_ja (AT) hotmail (DOT) com> wrote

Quote:
Hear a lot of members, member keys in the OLAP world.. What is it ?





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.