Hi Ian,

This scenario can be directly modelled in AS 2005 using referenced
role-playing dimensions. In AS 2000, you'll probably have to create
copies of the original AgentUser dimension, like TranslatorUser and
PresenterUser, possibly each using its own view of the dimension table,
to handle the role-playing.


- Deepak

Deepak Puri
Microsoft MVP - SQL Server

*** Sent via Developersdex http://www.developersdex.com ***

Thanks Deepak. I ended up creating an AgentPrescreen cube and an
AgentTranslator cube which are broken down by a single role dimension. I
don't try to create a hierarchy with all the roles existing on the same
level. This made more sense for me anyway since the metrics for a
Prescreener and a Translator shouldn't appear on the same line anyway;
they're different.

"Deepak Puri" <deepak_puri (AT) progressive (DOT) com> wrote