Analysis Services via WEB

  • Anyone out there with any success accessing Analysis Services and/or Analysis Services Cubes from your Web Browser? I have IIS and Analysis services set up per the documentation (A web connection produces a blank page), but haven't gone any further than that. Any assistance would be appreciated.

  • Are you speaking of the instructions titled "How to configure Analysis Services for the Web" in Books OnLine where you copy the msolap.asp file to \inetpub\wwwroot\ directory?

    K. Brian Kelley

    bkelley@sqlservercentral.com

    http://www.sqlservercentral.com/columnists/bkelley/

    K. Brian Kelley
    @kbriankelley

  • Yes, I have completed that successfully and it returns a 'blank' page in IE, which is supposedly shows a successful integration of AS with IIS. Now, I need to access a real AS cube from the browser, which quite honestly I don't know how to do. I'm looking at some additional info as I write this that leads me to an 'Office PivotTable list' to assist in doing what I need. I don't know any more than that at this point. Again, any help would be appreciated.

  • I don't believe this setup actually displays cubes via the browser. I think it's only for setting up an Analysis Server where connections can be made via HTTP such as with Excel and Microsoft Query.

    I think for what you're after you can probably find in some of the ADO samples that comes with Analysis Services. I looked in some of the samples directory and they have ASP code there. Here's a bit from the Books Online:

    http://msdn.microsoft.com/library/default.asp?url=/library/en-us/olapdmpr/prsamples_0y0j.asp

    K. Brian Kelley

    bkelley@sqlservercentral.com

    http://www.sqlservercentral.com/columnists/bkelley/

    K. Brian Kelley
    @kbriankelley

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

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