Change Name of Members Using MDX

Question

Hi,

I have a cube in SSAS 2005. The thing I'd like to do is change the names of some of the members in the dimensions of the cube. For example maybe a dimension that has a company name, say "ABC Paint Store" -- I need to change it to something else without changing the numbers that relate to the member.

I'm doing this because I need to demo for a client what cube browsing would look like but I can't use the name of the company in the cube that owns the data. The company's name and their products are scattered throughout the cube. I could change the source tables that live in the star schema that we use to build the cube and rebuild it, however, that would probably take a lot of time.

Is there an MDX statement that you know of that allows you to change the names of the members or other member properties in an existing cube? I saw ALTER MEMBER and ALTER CUBE but they don't seem to relate to members other than calculated members.

Thank you

---

g

Answer 1

Hi,

take a look at ALTER CUBE Statement in combination with UPDATE DIMENSION
i have not used it you so i cannot give you any more information - sorry

greets,
gerhard

---

- www.pmOne.com -

Answer 2

Can't you use the "translations" to do this ?

With translations, you can rename everything : cubename, dimension name , member names .

This makes use of the "regional settings".

Pierre

Answer 3

Hi do the Dimesion Writeback and change the name of members .After changing the names disbale Writeback and do the dimension update process ....

Answer 4

The other ideas are great ideas but I tried the Dimension Writeback and it was actually quite easy to change the names of memebers.

---

Thank you for the help!