Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
45
PivotView read configuration
posted

How to read the current configuration(such as rows,columns,filters,measures etc) that are available in the PivotView Control using the ASP.NET MVC 4 Helper APIs. I am looking to read/write these configurations from/to database.

I tried the below and it does seem to work. Please advice

Code & Screenshot attached below

Added a button on the view to post. Here is the View code

@using Infragistics.Web.Mvc
@model Infragistics.Web.Mvc.PivotViewModel

@using (Html.BeginForm("PivotView","Home",FormMethod.Post))
{
    <input type="submit" value="Read" />

@(Html.Infragistics().PivotView()
        .DataSourceOptions(
            dataSourceOptions => dataSourceOptions
                .Columns("[Product].[Product Categories]")
                .Rows("[Sales Territory].[Sales Territory]")
                .Measures("[Measures].[Internet Order Count]")
                .XmlaOptions(
                xmlaOptions => xmlaOptions
                    .ServerUrl("http://sampledata.infragistics.com/olap/msmdpump.dll")
                    .Catalog("Adventure Works DW Standard Edition")
                    .Cube("Adventure Works")
                    .MeasureGroup("Internet Sales"))).ID("pivotView")
                    .Render())
}

On the controller, the values for rows,columns,filters,measures etc all appear as 'null'