Dimension table


ExpDesc
ExpNod

i want dimension like this

0 - 90 days (ExpDesc)
20 (ExpNod)
25
35
91 - 180 days (ExpDesc)
95
125
145
181 - 270 days (ExpDesc)
185
225
255
>1 Year
390
425


I related the fact table with ExpNod

While creating dimension i unchecked autobuild then i selected ExpDesc and
ExpNod as key coloumn and
selected ExpDesc as column containing member name. Dimension type Regular
and finally i gave name as Experience.
I am able to process this dimension successfully when i browse the data i am
able to see data for ExpDesc.


After this, to create a hierachy i dragged ExpDesc and then ExpNod, i am
getting warning message

Attribute relationship doesn't exisits in one or more level in this hierachy
Following level doesn't have direct or indirect relationship defined to
parentlevel:
ExpNod -> ExpDesc



How to solve this issue/warning

any help

kk