How can I better manage OTBI based initiatives?

Summary:

We have more than 1000 initiatives based upon about 1000 OTBI analyses. What factors affect the efficiency of the initiatives? Are there any ways to know which analyses are still being used on active initiatives and which are no longer in use? Are there any good ideas for finding initiatives that have problems and may be throwing out errors or warnings? (There are a lot of logs to review.) Also, do you have anything that works for you when departments or job codes are created or changed to find analyses that would be affected? Lastly, we find that we