Post reply

SSAS integration with SSRS

  • July 8, 2008 at 12:27 pm

    #209663

    I have created on cube in SSAS. I want to integrate it with my reporting service. But before that I have used excel's pivot table functionality which connects to my ssas server's cube. and does the pivoting. I can publish this sheet as a web page and in IE it works exactly like excel (I can drag & drop the criteria, etc.. ). While viewing it installs ActiveX of Web office component.

    My question is:

    As here SSAS and Excel interacts with each other; Can I do the same thing (pivoting) with SSRS which interacts with SSAS cube?

    Thanks.

    Thanks.

    Gunjan.

  • July 9, 2008 at 6:33 pm

    #840579

    I found that one. Report builder has no capability like what excel has. you can't do the pivoting with reportbuilder , you can't do the drag and drop columns as you can do with excel

    Thanks.

    Gunjan.

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

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