Sign in
 
Home20122008 R2200820052000LibraryForums
SQL Server >
> 
> 
Changing Dimension Attribute Names in a Cube

Answered Changing Dimension Attribute Names in a Cube

  • Monday, November 12, 2012 4:28 AM
     
     
    Sign In to Vote
    0

    Hi

    I have a Cube accessible in Excel and people use it as a pivot table.

    I need to rename Dimension attribute names into some meaningful names where, it may easy for people to use in Excel.

    If I rename Attribute names in 'Dimension Structure' tab, and 'Hierarchies ' and reprocess the cube, is it sufficient to have name change appear in Excel Pivot??

    Will there be any further complicate issues arise with these type of attribute name changes??

    Thanks in advance.

    Mira

     

All Replies

  • Monday, November 12, 2012 7:12 AM
     
     
    Sign In to Vote
    0
    just check if you have any mdx in calculations tab refering to that member, if yes plz modify them also as per ur new user friendly names other wise should not be a problem!!
     
  • Monday, November 12, 2012 11:51 AM
     
     
    Sign In to Vote
    0

    Thanks Nishink, for the reply. Just a small clarification, I checked 'Calculation' Tab,, dimension attributes which I planned to rename appear in {..} 'Named Set' as well as 'Calculated Members' categories, I hope I need to rename where ever it appears in this case both 'Named Set' MDX as well as 'Calculated Members' MDX ??

    Mira

     
  • Monday, November 12, 2012 2:02 PM
     
     Answered
    Sign In to Vote
    0

    yes offcourse

    or

    what u can try is if u have a dev server do all this things there:

    change the name of attributes and try to process the cube.while processing the cube and in the final stages u will get mdx error where it will say that ur old dimension name not found.so at that time u can go at particular place and change the name would be a lengthy process .:)


    • Edited by Nishink Monday, November 12, 2012 2:05 PM
    • Marked As Answer by Mira Pimbi Monday, November 12, 2012 9:41 PM
    •