Request failed

4 posts, 0 answers
  1. Rajshree
    Rajshree avatar
    36 posts
    Member since:
    Feb 2015

    Posted 13 Dec 2017 Link to this post

    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"))
    )
        )
  2. Preslav
    Admin
    Preslav avatar
    379 posts

    Posted 15 Dec 2017 Link to this post

    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
    Try our brand new, jQuery-free Angular components built from ground-up which deliver the business app essential building blocks - a grid component, data visualization (charts) and form elements.
  3. Rajshree
    Rajshree avatar
    36 posts
    Member since:
    Feb 2015

    Posted 15 Dec 2017 Link to this post

    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.

  4. Preslav
    Admin
    Preslav avatar
    379 posts

    Posted 19 Dec 2017 Link to this post

    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.
    For example, check my testing Dojo: http://dojo.telerik.com/EdaJUl

    I hope this helps.


    Regards,
    Preslav
    Progress Telerik
    Try our brand new, jQuery-free Angular components built from ground-up which deliver the business app essential building blocks - a grid component, data visualization (charts) and form elements.
Back to Top