ComponentOne
Web API Explorer ASP.NET Web API Explorer

In this sample, all the data such as the field list in PviotPanel, the aggregated data shown in PivotGrid and the detail raw data for some cell are fetched from the DataEngine server api. We also have a client-side option if you perfer.

In this sample, the PivotPanel control is bound with the DataEngine api. And the PivotGrid control is used to show the aggregated data. When double clicking on some cell in the PivotGrid control, a new grid will pop up to show the detail raw data for the cell.

A list of available fields will show in the PivotPanel, and users will be able to drag fields between summary areas to generate data summaries (also known as "views"). Users can also configure the fields by setting their headers, summary functions, filters, and formats.

The PivotPanel control has properties that allow you to customize the view. Use the controls below to modify the values of these properties and see their effect:

Dataset
Row totals
Column totals
Show Zeros
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.Mvc;
using WebApiExplorer.Models;
 
namespace WebApiExplorer.Controllers.MVCOlap
{
    public partial class MVCOlapController : Controller
    {
        //
        // GET: /Index/
 
        public ActionResult Index()
        {
            ViewBag.DataSets = OlapData.GetDataSets();
            ViewBag.ShowTotals = OlapData.GetShowTotals();
            return View();
        }
 
    }
}
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
@using WebApiExplorer.Models
@using System.Collections
@{
    ViewBag.Title = "DataEngine";
    ViewBag.HideFeatures = true;
    ViewBag.DemoDescription = false;
    var webAPIService = System.Configuration.ConfigurationManager.AppSettings["WebAPIService"] + "api/dataengine";
    var dataSets = (IEnumerable<OlapData>)(ViewBag.DataSets);
    var showTotals = (IEnumerable<string>)(ViewBag.ShowTotals);
}
 
@section Head{
    <script type="text/javascript">
        window['webAPIService'] = '@webAPIService';
    </script>
    <script src="~/Scripts/DataEngine/common.js" type="text/javascript"></script>
}
 
<div class="title-container">
    <p>@Html.Raw(Resources.MVCOlap.Index_Text0)</p>
    <p>@Html.Raw(Resources.MVCOlap.Index_Text1)</p>
    <p>@Html.Raw(Resources.MVCOlap.Index_Text2)</p>
</div>
<div class="container-fluid">
    <div class="row">
        <div class="col-sm-4 col-md-4">
            @(Html.C1().PivotPanel().Id("pivotPanel")
            .BindEngine(eb => eb.BindService(webAPIService + "/complex10")
                        .ShowRowTotals(ShowTotals.None).ShowColumnTotals(ShowTotals.None).ShowZeros(false)
                        .RowFields(rfcb => rfcb.Items("Product", "Country"))
                        .ValueFields(vfcb => vfcb.Items("Sales", "Downloads"))))
        </div>
        <div class="col-sm-8 col-md-8">
            @Html.C1().PivotGrid().Id("pivotGrid").ItemsSourceId("pivotPanel").ShowSelectedHeaders(C1.Web.Mvc.Grid.HeadersVisibility.All)
        </div>
    </div>
</div>
<div class="col-lg-12 ui-helper-clearfix content-panel" style="margin-top:20px">
    <p>@Html.Raw(Resources.MVCOlap.Index_Text3)</p>
    <dl class="dl-horizontal">
        <dt>@Html.Raw(Resources.MVCOlap.Index_Dataset)</dt>
        <dd>
            @(Html.C1().ComboBox().Id("cmbDataSets").Bind(dataSets)
        .DisplayMemberPath("Name").SelectedValuePath("Value")
        .OnClientSelectedIndexChanged("cmbDataSets_SelectIndexChanged"))
        </dd>
        <dt>@Html.Raw(Resources.MVCOlap.Index_RowTotals)</dt>
        <dd>
            @(Html.C1().ComboBox().Id("cmbRowTotals").Bind(showTotals)
        .OnClientSelectedIndexChanged("cmbRowTotals_SelectIndexChanged"))
        </dd>
        <dt>@Html.Raw(Resources.MVCOlap.Index_ColumnTotals)</dt>
        <dd>
            @(Html.C1().ComboBox().Id("cmbColTotals").Bind(showTotals)
        .OnClientSelectedIndexChanged("cmbColTotals_SelectIndexChanged"))
        </dd>
        <dt>@Html.Raw(Resources.MVCOlap.Index_ShowZeros)</dt>
        <dd><input id="chkShowZeros" type="checkbox" onclick="chkShowZeros_CheckedChanged()" /></dd>
    </dl>
</div>