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.

Monday, May 19, 2014

ASO Dimension deletion limit

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
Share:

0 comments: