A good OLAP interface writes an efficient SQL and reads an aqua rate data from database.
To design the interface and architect having good knowledge on database under standing the report requirements.   _{Your Comment}