We use Analysis Services 2000 for maintaining a cube.
We have a dimension table that has [ State, Region, City, Street, ID ]. The
ID column joins to the CUSTOMER_ID column in the fact table. The columns in
the dimension table correspond to levels in the Customer dimension, the
Street being the lowest level. We could correctly view the data from the
cube, using Crystal Analysis. On a given street, if we could drill up and
view the data for the City.
We then added a level called Name to the same dimension, but set its source
column to be the NAME column from the fact table. This leaves us with 4
levels with source columns from the dimension table and 1 lowest level with
source column in the fact table.
Now when we view the cube at the Name level, we see names of individual
customers. When we drill up from a customer name, we would expect the Streets
to be shown. However, Crystal Analysis shows a message saying "Cannot drill
up. Selected member has no parent".

Can somebody explain why this happens?

Thanks