10 page dashboard pack in Excel

  • One of my users has created an Excel Dashboard pack containing 5 different OLAP Pivot tables (not Power Pivot) querying a single cube.

    He's using 5 slicers on each dashboard. It works but the latency is quite poor as every time a user clicks a slicer the queries are updated which involves a round trip to the SSAS server in another country !.

    I'm thinking of querying the cubes with ADO in VBA and then creating a single non-olap pivot/table for him to base the dashboards on. I don't think the aggregated data will be too big.

    Has anyone handled this problem differently?

Viewing 0 posts

You must be logged in to reply to this topic. Login to reply