How to

29 Mar 2018 / 3 minutes to read

Configure pivot tree map through the model properties

There comes a time when you want to set pivot tree map properties other than using PivotTreeMapPropertiesBuilder i.e., in the Controller side. At that time, you can pass PivotTreeMapProperties model instance as a parameter to the pivot tree map helper method.

We can set properties to pivot tree map control in server-side using the PivotTreeMapProperties class and it is used in the view page with the help of pivot tree map helper overload.

In addition to the id parameter of pivot tree map helper method, we can also pass PivotTreeMapProperties model as another parameter to the pivot tree map helper method.

The following code example explains how to render the pivot tree map control in relational mode.

The following code example which will explain to render the pivot tree map control.

@model Syncfusion.JavaScript.Models.PivotTreeMapProperties
    @(Html.EJ().Pivot().PivotTreeMap("PivotTreeMap", Model))
namespace PivotTreeMap
{
    public class PivotTreeMapController: Controller
    {
        public ActionResult PivotTreeMapFeatures()
        {
            Syncfusion.JavaScript.Models.PivotTreeMapProperties pivottreemap = new Syncfusion.JavaScript.Models.PivotTreeMapProperties();

            PivotDataSource pivottreemapDS = new PivotDataSource();
            pivottreemapDS.Data = "https://bi.syncfusion.com/olap/msmdpump.dll";
            pivottreemapDS.Cube = "Adventure Works";
            pivottreemapDS.Catalog = "Adventure Works DW 2008 SE";


            List<Field> rows = new List<Field>();
            rows.Add(new Field() { FieldName = "[Date].[Fiscal]" });
            pivottreemapDS.Rows = rows;

            List<Field> cols = new List<Field>();
            cols.Add(new Field() { FieldName = "[Customer].[Customer Geography]" });
            pivottreemapDS.Columns = cols;


            List<MeasuresItems> measures = new List<MeasuresItems>();
            measures.Add(new MeasuresItems() { FieldName = "[Measures].[Internet Sales Amount]" });
            List<Field> values = new List<Field>();
            values.Add(new Field() { Measures = measures, Axis = Syncfusion.JavaScript.AxisName.Column });
            pivottreemapDS.Values = values;
            pivottreemap.DataSource = pivottreemapDS;
            return View(pivottreemap);
        }
    }
}

As a result of the previous code example, the pivot tree map will be displayed as shown below:

OlapClientside