I have the following Cost Center Hierarchy and I do not know how to
implement this in Analysis Services. The sample cost center hierarchy
is as follows:

ROOT
In this case 1000, 2000, 3000, 4000, 5000, 6000, 7000 are cost centers
and are present in the cost center dimensions but GRP1 & GRP2 is not a
cost center but a grouping name for cost centers I am not sure how to
implement the above as a parent child hierarchy if so how to
incorporate labels like GRP1 and GRP2 into the hierarchy.

Your ideas on modelling this hierarchy is highly appreciated.

Thanks
Belinda

Hi,

you need to have all information about a dimension in a table.... or a view!
That might be a solution for you. Perhaps a UNION from your cost center
table and a "grouping" table will do the trick.

I have no idea how big your cost center table is. Perhaps it's even a better
idea to set up a table with only the structure of the dimension and join it
with the cost center table which adds some specific information you probably
need...

HTH


Thomas

"Belinda" <belindacur (AT) yahoo (DOT) com> schrieb im Newsbeitrag
news:41af5e48.0401270414.5429064c (AT) posting (DOT) google.com...