Quite often the name of something will change in the source system, say
someone gets married. Their ID stays the same, just the name changes. No new
surrogate key, no new busienss key. The Member Key is the same.

In AS, I'd like this change in names to be reflected. Does the dimension
have to be set to changing in order to do so?

No, as long as you have the ID column setup as the member key, you can
change the member name by simply incrementally processing the dimension
(assuming it is a shared dimension)

The changing property relates to the structure of the dimension. One
example would be if you had an employee dimension and you wanted to move
an employee to a different manager and you wanted to be able to do this
without fully re-processing the cube, then you would need to set the
dimension as changing.

Note: Parent-Child dimensions are inherently changing, due to the way
their structure is defined.

--
Regards
Darren Gosbell [MCSD]
Blog: http://www.geekswithblogs.net/darrengosbell

In article <egqAaSV6FHA.2012 (AT) TK2MSFTNGP14 (DOT) phx.gbl>, jesperzz (AT) hotmail (DOT) com
says...

That's what I thought as well...however the name updates aren't happening,
they're only occuring in the changing dimensions.

Weird.

"Darren Gosbell" <jam (AT) newsgroups (DOT) nospam> wrote

That is a bit strange, I have not had to do this in a production
environment, so I actually checked in BOL before posting. Under
incremental processing of shared dimensions and it said the following:

<snip>
Because almost any property of a member can be changed by changing the
appropriate field in the underlying dimension table, it is possible to
have changed member names after the dimension is incrementally updated.
</snip>

Are you on the latest SP? If so, and you can reproduce the issue it may
be an idea to report to MS. If you have sensitive data or large cubes,
see if you can reproduce the situation in the Foodmart database.

--
Regards
Darren Gosbell [MCSD]
Blog: http://www.geekswithblogs.net/darrengosbell

In article <O4eyfNX6FHA.1864 (AT) TK2MSFTNGP12 (DOT) phx.gbl>, jesperzz (AT) hotmail (DOT) com
says...