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'