I began on a BI job a few months ago and one of my first tasks is to replace our current way to access the SSAS cubes. It is a custom web application based on OWC (which is now deprecated) and it's starting to get cumbersome to install owc11 on every new client.
I was trying Excel Services and PowerPivot on SharePoint 2010 but I can't seem to find a way for the user to play (drag-n-drop filters, columns, rows) with the fields and totals. The way our current system does:
Is this even possible with SharePoint, ExcelServices and PowerPivot or should I be looking for another solution?