Post reply

Integrating cube with reporting service

  • August 19, 2009 at 7:46 am

    #137332

    Hi

    I'm new to SSAS. I developed a cube and now i'm trying to show that cube in Reporting service.

    Can you please guide me how integrate Cube with reporting service?

    -----------------------------------------------------------------------------------------------------------------------------------------------------------
    Please feel free to let me know if you are not clear or I’ve misunderstood anything.

    Thanks,
    Arunkumar S P

  • August 21, 2009 at 2:43 pm

    #1043160

    You need to create a data source in SSRS using the cube (Type = Microsoft SQL Server Analysis Service), and then create your SSRS report using that data source.

    You might check out this link to get started: http://msdn.microsoft.com/en-us/library/ms156334(SQL.90).aspx

    Hope that helps.

    -Marianne

  • August 24, 2009 at 12:33 am

    #1043468

    Thanks a lot Marianne.

    I tried your solution and its working fine for me.

    Now another task for me is to retrieve a particular value(Measure) from cube and pass that to web application based on input(Dimension). How it is possible?.

    Kindly help me

    -----------------------------------------------------------------------------------------------------------------------------------------------------------
    Please feel free to let me know if you are not clear or I’ve misunderstood anything.

    Thanks,
    Arunkumar S P

  • August 24, 2009 at 11:50 am

    #1043805

    Sorry, I'll have to defer to someone else on your follow-up question.

  • August 25, 2009 at 12:36 am

    #1044000

    Its Okay. Thanks Marianne.

    -----------------------------------------------------------------------------------------------------------------------------------------------------------
    Please feel free to let me know if you are not clear or I’ve misunderstood anything.

    Thanks,
    Arunkumar S P

Viewing 5 posts - 1 through 4 (of 4 total)

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