none
Project Server 2010 & Visio Services on SharePoint RRS feed

  • Question

  • Hello,

    I have been using Visio Services linked to SharePoint lists, but I understand I should be able to use data from Project Server (via the ODC?) in the same way.

    I can access Excel reports from Project Server which use the OLAP Cubes perfectly fine (and can refresh etc.) - however, when I try to open these data connections in Visio (e.g. by getting the URL of an ODC in Project Server), it doesn't seem to work. It gives me the below error.

    I'm not massively technical, but I notice on the Authentication Settings for the Connection Properties in Excel it uses "SSS" and it lists in the field next to it an 'SSD ID', but I can't find a similar option for this in Visio. Is this is the problem?

    Many thanks

    Wednesday, February 5, 2014 3:48 PM

Answers

All replies

  • Hello,

    Try a normal direct SQL AS connection to the cube, does this work?

    Paul


    Paul Mather | Twitter | http://pwmather.wordpress.com | CPS

    Wednesday, February 5, 2014 4:17 PM
    Moderator
  • Hello,

    Try a normal direct SQL AS connection to the cube, does this work?

    Paul


    Paul Mather | Twitter | http://pwmather.wordpress.com | CPS

    Hi Paul. I'm not sure what SQL AS is, but I realised I may have been choosing the wrong option within the "Link Data to Shapes" wizard in Visio - I'd chosen "Microsoft SQL Database Server" and pasted the URL ending in .odc.

    I've tried, however, the "Previoisly created data connection" option in the wizard, and again pasted the URL in, but it gives the following different error:

    Many thanks.



    • Edited by thevesper Wednesday, February 5, 2014 4:42 PM
    Wednesday, February 5, 2014 4:42 PM
  • Hello,

    I would probably post this in the Visio forum to see if they can help - might be quicker that the project / project server forum. Let me know, I can move the post if you like.

    Paul


    Paul Mather | Twitter | http://pwmather.wordpress.com | CPS


    Wednesday, February 5, 2014 5:37 PM
    Moderator