ig.OlapXmlaDataSource

ig.OlapXmlaDataSource_image
The igOlapXmlaDataSource component handles the communication between a JavaScript client application and a Microsoft® SQL Server Analysis Services (SSAS) server configured with the msmdpump.dll HTTP data provider. It exposes a user-friendly way for obtaining data from Microsoft SQL Server Analysis Services (MS SASS) – you do not have to possess any particular knowledge of Multidimensional Expressions (MDX) or XML for Analysis (XMLA) in order to get the data from an SSAS server. The igOlapXmlaDataSource generates the necessary MDX queries based on the commands it is given. The igOlapXmlaDataSource is usually used with one or more of the Ignite UI widgets capable of visualizing and interacting with OLAP data, e.g. igPivotView™ or igPivotGrid™.

Code Sample

<!doctype html>
<html>
<head>
    <!-- jQuery Core -->
    <script src="js/jquery.js" type="text/javascript"></script>
    <!-- jQuery UI -->
    <script src="js/jquery-ui.js" type="text/javascript"></script>
    <!-- Infragistics Combined Scripts -->
    <script src="js/infragistics.core.js" type="text/javascript"></script>
    <script src="js/infragistics.lob.js" type="text/javascript"></script>
    <script type="text/javascript">
        $.support.cors = true;               
        $(function () {
            var dataSource = new $.ig.OlapXmlaDataSource({
                serverUrl: "http://sampledata.infragistics.com/olap/msmdpump.dll",
                catalog: "Adventure Works DW Standard Edition",
                cube: "Adventure Works",
                rows: "[Date].[Calendar]",
                measures: "[Measures].[Customer Count], [Measures].[Internet Order Count]"
            });
             
            dataSource.initialize().done(function(metadataTree) {
                // do anything with dataSource once it's initialized
                // the result of the pre-loaded rows, columns, filters and measures is evaluated as part of initialization
                var result = dataSource.result();
            });
        });           
    </script>
</head>
<body>
</body>
</html>   

Related Samples

Related Topics

Dependencies

jquery-1.9.1.js
infragistics.util.js

Copyright © 1996 - 2025 Infragistics, Inc. All rights reserved.