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.
...
About Me
Anjum Ara
I am a technology enthusiast, an ardent reader. My latest interest is virtualization.
In my free time, I love understanding child nutrition, child holistic development. I bake, read, paint, and do whatever it takes to improve myself every day.