Parent-child dimension 2

#1

I get a parent-child dimension, and I would like to add a
upper member in this dimension. But the new level comes
from an other dimension table.

Ex Member Key: ID_Territory
Parent Key: ID_Parent
Member name: Territory_Hierarchy_Name

I would like to add above the ID_Territory_Name level, a
ID_Territory_Roll_up

I don't know how I can do this ?

#2

Combine the 2 tables into a view.

Regards
Jamie Thomson

"curieux38 (AT) discussions (DOT) microsoft.com" wrote:

Quote:

I get a parent-child dimension, and I would like to add a
upper member in this dimension. But the new level comes
from an other dimension table.

Ex Member Key: ID_Territory
Parent Key: ID_Parent
Member name: Territory_Hierarchy_Name

I would like to add above the ID_Territory_Name level, a
ID_Territory_Roll_up

I don't know how I can do this ?

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Parent-child dimension 2

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

Parent-child dimension 2 - 10-07-2004 , 04:46 AM

RE: Parent-child dimension 2 - 10-07-2004 , 05:11 AM