Post reply

Filtering, Sorting, Drilling in SSRS 2005 Reports

  • May 31, 2011 at 11:11 pm

    #239138

    Hello Everyone,

    I have sucessfully deployed Cube in SSRS 2005 now I want to perform Drilling, Filtering, Sorting etc. what are the ways to do this.

    Thanks.

  • June 1, 2011 at 1:03 pm

    #1332724

    If you just want to explore the cube yourself you can connect to Analysis Services via SQL Server Management Studio (SSMS) and Browse the cube. Otherwise Excel is very powerful and can be used to connect and explore the cube with PivotChart and PivotTable functionality. If you are looking more for canned reports try Report Builder or SQL Server Reporting Services. If you want dashboards PerformancePoint works well with Cubes. There are many other third party options as well, it just depends on what you are trying to accomplish.

  • January 26, 2012 at 1:15 pm

    #1439009

    You can query an SSAS cube directly using SSRS 2008 R2.

Viewing 3 posts - 1 through 2 (of 2 total)

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