Available in the Full Version

Pivot View - XMLA Data Binding

This sample demonstrates how to bind the igPivotView to an igOlapXmlaDataSource.
    FiltersColumns
        Rows

            This sample is designed for a larger screen size.

            On mobile, try rotating your screen, view full size, or email to another device.

            As of the 2014.1 release the igPivotView supports visualizing Key Performance Indicators (KPIs) from an OLAP cube.

            Code View

            Copy to Clipboard 
            <!DOCTYPE html>
<html>
<head>
    <title></title>

    <!-- Ignite UI for jQuery Required Combined CSS Files -->
    <link href="http://cdn-na.infragistics.com/igniteui/2024.2/latest/css/themes/infragistics/infragistics.theme.css" rel="stylesheet" />
    <link href="http://cdn-na.infragistics.com/igniteui/2024.2/latest/css/structure/infragistics.css" rel="stylesheet" />

    <script src="http://ajax.aspnetcdn.com/ajax/modernizr/modernizr-2.8.3.js"></script>
    <script src="http://code.jquery.com/jquery-1.11.3.min.js"></script>
    <script src="http://code.jquery.com/ui/1.11.1/jquery-ui.min.js"></script>

    <!-- Ignite UI for jQuery Required Combined JavaScript Files -->
    <script src="http://cdn-na.infragistics.com/igniteui/2024.2/latest/js/infragistics.core.js"></script>
    <script src="http://cdn-na.infragistics.com/igniteui/2024.2/latest/js/infragistics.lob.js"></script>

</head>
<body>
    <script>
        $.support.cors = true;

        $(function () {
            $("#pivotView").igPivotView({
                dataSourceOptions: {
                    xmlaOptions: {
                        serverUrl: 'https://sampledata.infragistics.com/olap/msmdpump.dll',
                        catalog: 'Adventure Works DW Standard Edition',
                        cube: 'Adventure Works'
                    },
                    rows: "[Ship Date].[Calendar]",
                    columns: "[Delivery Date].[Calendar]",
                    measures: "[Measures].[Product Gross Profit Margin Status],[Measures].[Product Gross Profit Margin Goal]",
                }
            });
        });
    </script>
    <div id="pivotView"></div>
</body>
</html>