Post reply

Analysis Services CUBES in OWC11

  • August 30, 2006 at 10:23 pm

    #169536

    friends, Help me.

    My Cube which is developed in SSAS is not pumping data to OWC11 Pivot table of client browser. It is displaying in Server(win 2003), can any body help me come out this problem.

    thanks for helping

    Satyanand.

  • September 1, 2006 at 8:04 am

    #658044

    Hi,

    The First Step is to make sure that the client (I am assuming Excel) has the "Microsoft OLE DB Provider For Analysis Services 9.0" Available. This can be downloaded from Microsoft @ http://www.microsoft.com/downloads/details.aspx?familyid=d09c1d60-a13c-4479-9b91-9e8b9d835cdc&displaylang=en

    Use this to connect to the cube.

    Hope this helps.

     

    Ged

  • September 1, 2006 at 11:41 pm

    #658164

    Thanks Ged,

    I tried. But the pivot table is coming on to browser with out data.

    satyanand

  • November 17, 2006 at 12:58 am

    #672520

    In SQL Configuration Manager, SQL Native Client Configuration->Client Protocols enable TCP/IP if it is disabled

    In the OWC data change the Connection string from "Provider=MSOLAP.2" to "Provider=MSOLAP.3"

    HTH

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

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