I have been working with SSAS cubes for a while now and connect our proprietary reporting tool with SSAS cubes, but, recently came across a Tableau demonstration and saw that if we pull in a view from relational database which has transaction level detail for the measures associated with dim ids, Tableau creates aggregations just like SSAS cube and we can show the aggregations on the Tableau report with a link to see full data transaction details (drill down).
My question is weather we should let Tableau'f feature to create aggregations or should we use SSAS cube? Any pros or cons for both options are appreciated.
Thanks in advance.