locked
Form connection to Analysis Services RRS feed

  • Question

  • Hello, I am having trouble setting up a connection to Analysis Services 2008 cube. I can go through all the step from the Advanced Forms Templates page and even select MS Analysis Services as my new data source. Upon selecting Finish on the Data Connection Wizard I get the following error,

    Infopath cannot connect to the data source.

    The Show Details window says:
    InfoPath does not support the specified database. The database must be a Microsoft SQL Server.

    The same happens if I try to make a secondary data source from Analysis Services.

    Any thoughts on this?

     

    John


    John C. Hill
    Monday, June 13, 2011 7:13 PM

Answers

  • Infopath doesnt support multidimentional (OLAP) connections. To access the data it needs to be "flatten" by utilizing linked servers. Another approach would be to utilize XMLA (connection to XML file with OLAP data).
    http://alecpojidaev.wordpress.com
    • Marked as answer by JohnCHill Monday, June 13, 2011 8:11 PM
    Monday, June 13, 2011 7:57 PM

All replies

  • Infopath doesnt support multidimentional (OLAP) connections. To access the data it needs to be "flatten" by utilizing linked servers. Another approach would be to utilize XMLA (connection to XML file with OLAP data).
    http://alecpojidaev.wordpress.com
    • Marked as answer by JohnCHill Monday, June 13, 2011 8:11 PM
    Monday, June 13, 2011 7:57 PM
  • Thank you. I will try both of those options.
    John C. Hill
    Monday, June 13, 2011 8:11 PM