Available in the Full Version

Pivot Data Selector - ASP.NET MVC XMLA Data Binding

This sample demonstrates how to use the ASP.NET MVC Helper for the igOlapXmlaDataSource and how to use this data source in igPivotDataSelector and igPivotGrid.
    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.

            Code View

            Copy to Clipboard 
            @using Infragistics.Web.Mvc
@using IgniteUI.SamplesBrowser.Models

<!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>
    <script>
        // neccessary for older IE browsers
        $.support.cors = true;
    </script>

    <style>
        #dataSelector, #pivotGrid {
            float: left;
        }
    </style>
</head>
<body>
    <div class="sampleContent">
        @(Html.Infragistics().OlapDataSource().ID("xmlaDataSource")
        .DataSourceOptions(
            dataSourceOptions => dataSourceOptions
                .Columns("[Product].[Product Categories]")
                .Rows("[Sales Territory].[Sales Territory]")
                .Measures("[Measures].[Internet Order Count]")
                .XmlaOptions(
                xmlaOptions => xmlaOptions
                    .ServerUrl("https://sampledata.infragistics.com/olap/msmdpump.dll")
                    .Catalog("Adventure Works DW Standard Edition")
                    .Cube("Adventure Works")
                    .MeasureGroup("Internet Sales"))).Render())
        @(Html.Infragistics().PivotDataSelector().Width("250px").Height("650px").DataSourceID("xmlaDataSource").ID("dataSelector").Render())
        @(Html.Infragistics().PivotGrid().Width("560px").Height("650px").DataSourceID("xmlaDataSource").ID("pivotGrid").Render())
    </div>
</body>
</html>