Creating a dimension tablr

Hi Guys
Fairly new to this, I'm having a problem creating a hierarchial dimensionn
from a table with the following structure:
STATE | ZONE | BRANCH | CONTACT TYPE | CONTACT
--|--|--|--|--
9 records|7 records | 25 records | 6 records |3984 records
I need the structure to be as follows:
STATE
--ZONE
--BRANCH
--CONTACT TYPE
--CONTACT
I can't seem to get this right, I've created the dimension and added the
level above as an attribute to the current level. e.g.:
ZONE
--Attribute STATE
BRANCH
--Attribute ZONE
etc.
Then created the hierarchy as specified above, the dimension processes, but
it doesnt display correclty, all the properties on the dimension are set to
default, anyone care to help me?
I hope the above makes sense.
I forgot to add, you'll see that ZONE has less records than STATE, thats
because the current system is storing NAMES not keys, and a ZONE name can be
in more than on STATE, e.g. STATE:"New York" can have a zone called
ZONE:"AGRICULTURE" and STATE:"California" can have a zone called
ZONE:"AGRICULTURE"
|||Sorry, another thing... the record counts in the first post are DISTINCT
counts...