Post reply

accessing cubes through excel 2000 pivot tables

  • May 10, 2005 at 5:55 pm

    #164488

    HI Steve

     for yor suggestions

    the error im getting is "Intialization of data source failed, check the db server or contact your DBA"

    also to add to my original comments, i downloaded the sp's for analysis server as this install did not have any sp's, (sp1, sp2, sp3)

    i tired your suggestions and the cubes where/are set to visible

     

    thanks once again

     cheers

     Todd

    Kindest Regards,

    Todd,non est vivere sed valere vita est

  • May 10, 2005 at 8:13 pm

    #557926

    Todd,

    Can you make a new connection to the cube?  ie is it visible in the cube list?  If not, check that the visibility of the cube hasn't been set to false (edit cube, select the cube in the tree, goto properties pane, advanced, Visible property).  I know you said security hadn't changed but you may want to check the visibility/access in the security role/s also.

    Cheers,

    Steve.

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

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