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