In my opinion, your DBA's comments are premature. The two technologies (Multidimensional and Tabular) are very different. In order to make the best decision, it will be important to know what the requirements are from your end users. Things to consider would be: Data Volumes, Relationships and Access Methods.

Multidimensional is definitely not going away.