dbTalk Databases Forums  

SSAS - Parent Child dimension

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


Discuss SSAS - Parent Child dimension in the microsoft.public.sqlserver.olap forum.



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

Default SSAS - Parent Child dimension - 12-13-2005 , 12:58 PM






Do PC dimensions have to remain standalone like in AS2K?




Reply With Quote
  #2  
Old   
RJ Smith
 
Posts: n/a

Default Re: SSAS - Parent Child dimension - 12-14-2005 , 01:51 AM






Nope, in SSAS, they're attribute hierarchies, so you can have as many as you
want (or need).

Take a look at the Employee dimension in AdventureWorksDW -- the table is
self-referencing on the ParentEmployeeKey, and SSAS detects that and makes
the Employee attribute a parent-child hierarchy. There's also an Employee
Department hierarchy in that dimension which is multi-level on Department
Name->Title->Full Name.

--RJ

"Jesse O" <jesperzz (AT) hotmail (DOT) com> wrote

Quote:
Do PC dimensions have to remain standalone like in AS2K?






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.