Available in the Full Version

Pivot View - ASP.NET MVC XMLA Data Binding

This sample demonstrates how to use the ASP.NET MVC Helper for the igPivotView with 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.

            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>
</head>
<body>
    @(Html.Infragistics().PivotView()
        .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"))).ID("pivotView")
                    .Render())
</body>
</html>