I have a data set of 2million records, however finance users setup OLAP Tabular via Excel with lots of attributes to see detail
they don't filter down the view, they like seeing all Age records for current day vs history day snapshot
or should i scrap the cube, make users think its a cube but have pivot connected to View
i think performance wise it will be better than tabular cube as the cube struggles when viewing 5000 rows, But the view option doesn't allow for calculations but knowing the audience they going to setup multiple templates with the goal analytical view in PowerBI performance is going to be key
Thoughts or better ideas please?