MVC Pivotgrid with OLAP Cube

[Konstantinos]

I have an AnalysisServices Server Installed and i have created a cube in it. I need to add a pivotgrid into my site for browsing said cube.
My site is done using MVC controls and i have added an MVC Pivotgrid using the code below:

@(Html.Kendo().PivotGrid()
        .Name("pivotgrid")
        .ColumnWidth(200)
        .Height(570)
        .Filterable(true)
        .Sortable()
        .Configurator("#configurator")
        .DataSource(dataSource => dataSource
            .Custom()
            .Transport(transport => transport
                .Connection(connection => connection
                .Catalog("CatalogName")
                .Cube("CubeName"))
                //.Read(read => read
                //    .Url("RDC-35")
                //)
            )
            .Events(e => e.Error("onError"))
        )
)

 But i cannot understand where to put the server name. As far as i can tell i need to use .Read(x => x.Url("http://blah.blah") ). and that i need to have an http address for my server installed, as mentioned here: http://docs.telerik.com/kendo-ui/web/pivotgrid/overview

The PivotDataSource component communicates with OLAP cube instance on HTTP using the XMLA protocol
Is this the only way? Can't i use Adomd or ADO.NET?

 

P.S. i have found examples with code like the one below that imply using adomd is an option:

 <AdomdConnectionSettings Cube="Adventure Works" DataBase="Adventure Works DW 2008R2" ConnectionString="Data Source=http://demos.telerik.com/olap/msmdpump.dll;Catalog=Adventure Works DW 2008R2"></AdomdConnectionSettings>

Please forgive me if i have misunderstood anything, i am new to your controls and doing my best to understand them and start using them

[Konstantinos]

Forgot to mention that i am currently working localy. Both analysis services and IIS are on the local machine.

[Georgi Krustev]

Hello Konstantinos,

The Kendo UI PivotGrid can be bound either to msmdpump.dll service (HTTP access to SSAS) or to server proxy that communicates with OLAP cube using ADOMD. Here is a code library that demonstrates how to use the latter approach:

• http://www.telerik.com/support/code-library/bind-to-adomd-client

Let me know if something is not clear.

Regards,
Georgi Krustev
Telerik

 

 

[Milehigh JT]

Hi,

Are these still the only two options for remote binding of the pivot grid control? 

Thanks.

[Tsvetomir]

Hi James,

The Kendo UI PivotGrid is built according to the good convention for pivoting data. Namely, using an OLAP cube. Apart from this approach for data binding, I would recommend taking a look at how the PivotGrid could be bound to flat data. Here is a live demo depicting the same:

https://demos.telerik.com/aspnet-mvc/pivotgrid/remote-flat-data-binding

Is there a specific data-binding that you seek to implement? If so, could you share more details regarding the binding?

 

Regards,
Tsvetomir
Progress Telerik

[Milehigh JT]

Hi Tsvetomir, thanks for the pointer. I would like to do a remote flat binding as you suggest.

I read the demo page, but I can't figure out one line of code, below. Is it reading a method named Customers_Read on the PivotGrid controller?

.Transport(transport => transport.Read("Customers_Read", "PivotGrid"))

 

Where is the Customers_Read code in the demo? Sorry if that's a dumb question, but that seems to be the most important portion of the demo and I can't find it on the demo site, my installation examples, GitHub, or the support forums.

[Tsvetomir]

Hi James,

Indeed, the Controller that the demo utilizes is of type partial class. The implementation of the Customers_Read ActionMethod is within the IndexController. It returns a plain collection of items:

        public ActionResult Customers_Read([DataSourceRequest]DataSourceRequest request)
        {
            return Json(GetCustomers().ToDataSourceResult(request));
        }

And the GetCustomers() returns that collection. It performs a Select query over a traditional SQL database. 

The project that hosts the live demos on our site is shipped inside the installation folder. You could find it by following the folder path below:

installationFolder\wrappers\aspnetmvc\Examples\VS2019

Should you have any additional questions, do not hesitate to contact me back.

 

Regards,
Tsvetomir
Progress Telerik