locked
How can I add SQL Server analysis into my website? RRS feed

  • Question

  • I have a website. I build it Joomla 1.5 version. How can I add SQL server Analysis into my website?
    Thursday, April 18, 2013 8:51 PM

Answers

  • Hello iqbal51,

    Analysis Services provides a range of solutions for building and deploying analytical databases used for decision support in Excel, PerformancePoint, Reporting Services, and other business intelligence applications. The basis of any Analysis Services solution is a business intelligence semantic data model and a server instance that instantiates, processes, queries, and manages objects in that model.

    I recommend you refer to the following article:
    Analysis Services: http://technet.microsoft.com/en-us/library/bb522607.aspx

    ADOMD.NET is a Microsoft .NET Framework data provider that is designed to communicate with Microsoft SQL Server Analysis Services. ADOMD.NET uses the XML for Analysis protocol to communicate with analytical data sources by using either TCP/IP or HTTP connections to transmit and receive SOAP requests and responses that are compliant with the XML for Analysis specification.

    For more information, please see: http://technet.microsoft.com/en-us/library/ms123483.aspx

    Regards,


    Elvis Long
    TechNet Community Support

    • Marked as answer by Elvis Long Friday, April 26, 2013 8:57 AM
    Monday, April 22, 2013 7:32 AM

All replies

  • Hello,

    What do you mean with "... add SQL server Analysis into my Website"?

    You can use AdoMd Client to query data from your SSAS cube(s) to Show the result on your web side.


    Olaf Helper

    Blog Xing

    • Proposed as answer by swapp018 Friday, April 19, 2013 5:22 AM
    Friday, April 19, 2013 3:43 AM
  • Hello iqbal51,

    Analysis Services provides a range of solutions for building and deploying analytical databases used for decision support in Excel, PerformancePoint, Reporting Services, and other business intelligence applications. The basis of any Analysis Services solution is a business intelligence semantic data model and a server instance that instantiates, processes, queries, and manages objects in that model.

    I recommend you refer to the following article:
    Analysis Services: http://technet.microsoft.com/en-us/library/bb522607.aspx

    ADOMD.NET is a Microsoft .NET Framework data provider that is designed to communicate with Microsoft SQL Server Analysis Services. ADOMD.NET uses the XML for Analysis protocol to communicate with analytical data sources by using either TCP/IP or HTTP connections to transmit and receive SOAP requests and responses that are compliant with the XML for Analysis specification.

    For more information, please see: http://technet.microsoft.com/en-us/library/ms123483.aspx

    Regards,


    Elvis Long
    TechNet Community Support

    • Marked as answer by Elvis Long Friday, April 26, 2013 8:57 AM
    Monday, April 22, 2013 7:32 AM