Allo all!

I'm getting this error when trying to create a new hierarchy for an
existing dimension.

The name of dimension 'Customer.Test' conflicts with an existing
dimension. A dimension hierarchy cannot coexist with a dimension that
has the same name but no hierarchy.

I'm not sure what's happening. The original customer dim has a
hierarchy, the new dim has a hier, their doesn't seem to be an existing
customer.test, public or private.

I'd appreciate any suggestions.

Thanks!

-Joey

I presume you use AS2005.

its true, you can't create a user hierarchy with the same name of an
attribute hierarchy.
By default, an attribute has its own hierarchy which is the same name of the
attribute (Attribute Gender has an attribute hierarchy called Gender with 2
levels: gender and (all))
so you can't create a user defined hierarchy with the same name.

you have 2 options:
option 1. you can rename the attribute (like Gender become HiddenGender) and
hide this attribute to the end user
then create a user defined hierarchy called "Gender", use the attribute
"HiddenGender" and rename "HiddenGender" to "customer Gender"
there is no more conflict

option 2: use another name for the user defined hierarchy, like "Customers
by Gender" or "Gender of customers"

finally, keep in mind that to reference a level or a member, AS use this
notation:
[Dimension].[Hierarchy].[level].[member]

each [Dimension] ; [Dimension].[Hierarchy]; [Dimension].[Hierarchy].[level];
[Dimension].[Hierarchy].[level].[member]
must be unique its why you can't create a user defined hierarchy "Gender"
when AS auto create an attribute hierarchy using the same name.
unfortunatly , there is no way to change the name of this attribute
hierarchy and no way the change the "All member" label for this attribute.

I hope I have answered your question :-)

Jreome.


"Joey Pruett" <joeypruett (AT) hotmail (DOT) com> wrote

Thanks for the response Jerome. I'm actually using AS '00. I've seen
no reference to this error anywhere. I'll let you know if I figure
anything out. Thanks for the response.

-Joey

ok...
so in your database you have a dimension like:
Customer

now, if you want to create a dimension called "Customer.By Gender" you
can't.
the first dimension must be changed to add an hierarchy on it.

Procedure:
copy the customer dimension
paste the dimension in the same database, name the new dimension like
"Customers.By Country" (note the left part of the name is different, and the
..)
delete the customer dimension
copy / paste "Customers.By Country" to "Customer.By Country" (remove the S,
and you'll get the initial dimension name)
now you can create a new hierarchy based on the Customer dimension
"Customer.By Gender"

in fact, you can't create an hierarchy AFTER the dimension was created.


"Joey Pruett" <joeypruett (AT) hotmail (DOT) com> wrote

good tip on renaming the dimensions, thank you sir!

it's kind of a bummer that i can't ever create multiple hierarchies
after the initial dim creation. i'd love to have customer, then
customer.new, then customer.new2, etc. but, unless the hier is created
at intial dim creation, it looks like no two dims can ever have the
same base name, such as customer.

thanks again,

-joey