I want to use a view as a dimension that has the following
structure:

AccountKey
AccountNumber
LineOfBusinessLevel1
....
LineOfBusinessLevel4

Hierarchically, the dimension looks like this (from top to
bottom)

LineOfBusinessLevel1
....
LineOfBusinessLevel4
AccountNumber

The Line of business hierarchy changes over time and the
underlying dimension table reflects the profile of the
account at the time of the fact's occurrence. AccountKey
will be different for each profile of the account, but the
AccountNumber will not change.

When processing the cube, the above-referenced error is
returned for the AccountNumber column. What can I do to
fix this problem? My users need to drill up and down the
hierarchy...

TIA,

Mike

Hi Mike - Try changing the member keys unique property to false at the
dimension and account level. If your member key = member name, then
also set the member name property to false and set "allow duplicate
member names" = True at the dimension level. Hope that helps.


"Mike A." <anonymous (AT) discussions (DOT) microsoft.com> wrote