Request failed

[Rajshree]

I am getting error after i integrated Cube to Pivotgrid in cshtml. however, cube is producing result in excel when i tried. please see attached image for error and excel result generated from cube.

this is the major piece my manager is looking before he approves Telerik license budget and i have only 3 days left to trial version.

please help ASAP.

here is the code.

 

    @(Html.Kendo().PivotConfigurator()
.Name("configurator")
.HtmlAttributes(new { @class = "hidden-on-narrow" })
.Filterable(true)
.Sortable()
.Height(580)
    )

    @(Html.Kendo().PivotGrid()
.Name("pivotgrid")
.ColumnWidth(200)
.Height(580)
.HtmlAttributes(new { @class = "hidden-on-narrow" })
.Filterable(true)
.Sortable()
.Configurator("#configurator")
.DataSource(dataSource => dataSource.
    Xmla()
    .Columns(columns =>
    {
        columns.Add("[Incident].[Status]").Expand(true);

    })
    .Rows(rows => rows.Add("[Clients].[Id]"))
    .Measures(measures => measures.Values(new string[] { "[Measures].[Incident Count]" }))
    .Transport(transport => transport
        .Connection(connection => connection
             .Catalog("NextGenToolIncidentCube")
                    .Cube("[IncidentAnalyticalCube"))
        .Read(read => read
            .Url("http://xxxxxxxxxxx/OLAP/msmdpump.dll")
            .DataType("text")
            .ContentType("text/xml")
            .Type(HttpVerbs.Post)
        )
    )
    .Events(e => e.Error("onError"))
)
    )

[Preslav]

Hello Rajshree,

Generally speaking, the provided code looks okay to me. Thus, I am not sure what is causing the issue.

The only thing that I noticed is the extra "[" in the definition of the cube. 

.Cube("[IncidentAnalyticalCube"))

I assume that it should not be there. Please correct me if I am wrong.

If the above does not resolve the issue, in order to continue my investigation, could you please prepare and share a sample runnable project that clearly replicates the scenario? Running this project locally will help me fully understand the case and I might be able to provide a workaround.


Regards,
Preslav
Progress Telerik

[Rajshree]

Preslav,

I removed extra bracket that i accidentally had it in code. that did not fix issue.

however,I tried below code and it worked nicely.

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

i still wonder why it did not work with my code. let me know if you have answer or like to find out. I can send the solution file.with sample code.

additionally, now can i pass dropdown parameter/value to update pivotgrid cube?

for instance, i have client list dropdown on top.when i select specific client,I should only see related data in to configure and pivotgrid.can i pass that in to cube datasource? 

fyi. i have integrated pivotgrid with SSAS cube.

this will be be help you i get answer of this.

[Preslav]

Hi Rajshree,

Based on the provided information I assume that your project requires having an external DropDownList. When the user selects a value from the DropDown, the PivotGrid should filter. Please correct me if I am wrong.

If this is the case, you could implement a DropDownList. In the select event handler, based on the selected value, filter the PivotGrid.

• https://docs.telerik.com/kendo-ui/api/javascript/ui/dropdownlist#events-select
• https://docs.telerik.com/kendo-ui/api/javascript/data/datasource#methods-filter

For example, check my testing Dojo: http://dojo.telerik.com/EdaJUl

I hope this helps.


Regards,
Preslav
Progress Telerik