SSAS can forgive but never forget
While you create a new dimension in SSAS, it tries to guess the name you like to give to your dimension. For example: If the table name is DimCustomer then SSAS will think you like to call the dimension that is based on that table: Dim Customer. Well, I don't like spaces on objects. It makes my life harder while I need to refer to this object on a code (call it [Dim Customer] instead of DimCustomer). For that reason I usually rename the dimension to a name without spaces. SSAS accept the rename request and up until now I thought everything is ok. But, as the title implies, SSAS never forget.
Read more...Tags: management, security