Available in the Full Version

Pivot Grid - ASP.NET MVC XMLA Data Binding

This sample demonstrates how to use the ASP.NET MVC Helper for the igPivotGrid with igOlapXmlaDataSource.

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

ASP.NET View
ASP.NET Controller

@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().PivotGrid()
        .Height("600")
        .Width("915")
        .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("pivotGrid").Render())
</body>
</html>

using System.Web.Mvc;
using Infragistics.Web.Mvc;
using IgniteUI.SamplesBrowser.Application.Data;
using System.Data;
using System.Data.SqlClient;
using IgniteUI.SamplesBrowser.Models.Repositories;
using Newtonsoft.Json.Converters;
using System.Linq;
using System;

namespace IgniteUI.SamplesBrowser.Controllers
{
    public class PivotGridController : Controller
    {
        [AdomdDataSourceAction]
        [ActionName("adomd-provider-endpoint")]
        public ActionResult RemoteAdomdProviderEndpoint()
        {
            return View(new AdomdDataSourceModel()
            {
                ConnectionString = "Provider=MSOLAP.4;Persist Security Info=True;Data Source=http://sampledata.infragistics.com/olap/msmdpump.dll;Initial Catalog=Adventure Works DW Standard Edition;MDX Compatibility=1;Safety Options=2;MDX Missing Member Mode=Error"
            });
        }

        [ActionName("remote-adomd-provider")]
        public ActionResult AdomdProvider()
        {
            return View("remote-adomd-provider");
        }

        [XmlaDataSourceAction]
        [ActionName("remote-xmla-provider-endpoint")]
        public ActionResult RemoteXmlaProviderEndpoint()
        {
            return View(new XmlaDataSourceModel { ServerUrl = "http://sampledata.infragistics.com/olap/msmdpump.dll" });
        }

        [ActionName("remote-xmla-provider")]
        public ActionResult RemoteXmlaProvider()
        {
            return View("remote-xmla-provider");
        }

        [ActionName("using-the-asp-net-mvc-helper-with-flat-data-source")]
        public ActionResult UsingAspNetMvcHelperWithFlatDataSource()
        {
            var invoices = RepositoryFactory.GetInvoiceRepository().Get().Take(200).Select(invoice => new
            {
                Address = invoice.Address,
                City = invoice.City,
                CustomerName = invoice.CustomerName,
                Discount = invoice.Discount,
                Freight = invoice.Freight,
                OrderDate = invoice.OrderDate == null ? null : invoice.OrderDate.Value.AddYears(16).ToShortDateString(),
                ProductName = invoice.ProductName,
                Quantity = invoice.Quantity,
                RequiredDate = invoice.RequiredDate == null ? null : invoice.RequiredDate.Value.AddYears(16).ToShortDateString(),
                Salesperson = invoice.Salesperson,
                ShipCountry = invoice.ShipCountry,
                ShippedDate = invoice.ShippedDate == null ? null : invoice.ShippedDate.Value.AddYears(16).ToShortDateString(),
                ShipperName = invoice.ShipperName
            });
            return View("using-the-asp-net-mvc-helper-with-flat-data-source", invoices);
        }

        [ActionName("using-the-asp-net-mvc-helper-with-xmla-data-source")]
        public ActionResult UsingAspNetMvcHelperWithXmlaDataSource()
        {
            return View("using-the-asp-net-mvc-helper-with-xmla-data-source");
        }
    }
}

Ignite UI for jQuery | Samples

Search Results

Pivot Grid - ASP.NET MVC XMLA Data Binding

Code View