CrazyEngineers
CrazyEngineers

  • xmla in data warehousing

    kyle.miller

    Member

    Updated: Oct 22, 2024
    Views: 1.3K
    hi guys,

    i am new to data warehousing, i want to know what exactly is xmla in data warehousing? and from where can i learn more about it, i am looking for online tutorials and e book, please provide me the link.

    i would really appreciate.
    thanks
    0
    Replies
Howdy guest!
Dear guest, you must be logged-in to participate on CrazyEngineers. We would love to have you as a member of our community. Consider creating an account or login.
Replies

  • Mahesh Dahale

    Member • Nov 17, 2009

    Hi kyle Wel come to CE family....

    XML for Analysis (XMLA) is a SOAP-based API. XMLA provides the most efficient way to access an OLAP database over the Internet. Hyperion, Microsoft and SAS first proposed the standard April of 2001. The standard’s organization is XMLA.org council. XMLA Consulting is a permanent XMLA.org council member.

    Currently, Microsoft Analysis Services has the leading market share in the OLAP market. Report Portal is based on AJAX, the same technology used by Google Maps and Gmail. The AJAX approach provides zero-footprint platform with mimimum of page reloads. Essentially, Report Portal is an IE SOAP client that consumes the XMLA web service provided by Microsoft. This gives Report Portal a technological advantage over other simalar products ProClarity (classic asp based) and Panorama (applet based).

    for online tutorials

    <a href="https://www.xmla.org/" target="_blank" rel="nofollow noopener noreferrer">XMLA | XML Analysis</a>

    <a href="https://www.xmlforanalysis.com/xmla1.1.doc" target="_blank" rel="nofollow noopener noreferrer">StackPath</a>
    Are you sure? This action cannot be undone.
    Cancel

  • melina386

    Member • Nov 17, 2009

    XML is a natural to deal with the collection of information from many sources that's needed by all data warehouses. XML can define the structure of the data being sent. In an ideal world the sending system would encode the data using XML. However, even if the data warehouse project must do the encoding, it still provides a single logical point to deal with any changes to the source.

    <a href="https://www.e-datapro.net" target="_blank" rel="nofollow noopener noreferrer">Account Suspended</a>
    Are you sure? This action cannot be undone.
    Cancel

  • rodney.marsh

    Member • Nov 17, 2009

    Hi, 😁

    XMLA is XML for Analysis which can be considered as a standard for accessing data in OLAP, data mining or data sources on the internet. It is Simple Object Access Protocol. XMLA uses discover and Execute methods. Discover fetched information from the internet while Execute allows the applications to execute against the data sources.

    For more info visit <a href="https://www.amazon.com/Multidimensional-Data-Modeling-Toolkit-Intelligence/dp/0981775306" target="_blank" rel="nofollow noopener noreferrer">Amazon.com</a>
    Are you sure? This action cannot be undone.
    Cancel
Home Channels Search Login Register