SQL Server Performance

setting visibilty properties,renaming attributes of a dimension

Discussion in 'Analysis Services/Data Warehousing' started by sana, Sep 21, 2007.

  1. sana New Member

    hi
    Kindly help me with following MDX related queries:
    1. How to set the visibilty property of an attribute of a dimension using MDX Query?
    2. How to Rename an attribute of a dimension using MDX Quryand do we need to process the cube after renaming ?
  2. ranjitjain New Member

    Hi
    In AS 2005 you can open your as db in visual studio and rename the attribute which will not require processing of cube.
    Else you can even execute XMLA Alter script to the database.

Share This Page