i have added perspective in cube,as well as dimensions,measure,attributes and each and every thing....but at the end when i try to update it,it dnt give me any exception and even donot update it....i have seen this link http://msdn2.microsoft.com/en-us/library/ms345086.aspx#Persp) but still confrating the same problem.kindly help me out.
Are you trying this from BIDS? If so check the privileges for that user to perform such action Satya SKJ Microsoft SQL Server MVP Writer, Contributing Editor & Moderator http://www.SQL-Server-Performance.Com This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.