iOLAP interview question

technical challenge in prior project and solution