Well, I'm kinda new to Data Warehousing, too, and I don't know what you mean by open close principle. This wouldn't be a student project, would it?
====================================
The reasonable man adapts himself to the world. The unreasonable one persists in trying to adapt the world to himself. Therefore all progress depends on the unreasonable man. - George Bernard Shaw