Sometimes you cannot add any more dimension in an ASO application. Supposedly it has a limit on the number of times one can add/delete the dimension.
I faced this issue once and found an interesting blog by Glenn Schwartzberg which lead to a SQL script from comments.
alter database xx.xx reset all;
This resets the outline too and cures the limit (and keeps the outline small).
Source :
http://glennschwartzbergs-essbase-blog.blogspot.in/2010/12/aso-dimension-deletion-limit.html
I faced this issue once and found an interesting blog by Glenn Schwartzberg which lead to a SQL script from comments.
alter database xx.xx reset all;
This resets the outline too and cures the limit (and keeps the outline small).
Source :
http://glennschwartzbergs-essbase-blog.blogspot.in/2010/12/aso-dimension-deletion-limit.html