Using pivot tables (in Excel) easily with predefined hierarchies is definately a plus.
Not having to write SQL code can be a plus for certain users. However, if something is not present in the cube they will have to write MDX which is worse than SQL.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP