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? |