Strange pivot behaviour

8 posts, 0 answers
  1. Rayko
    Rayko avatar
    27 posts
    Member since:
    Jul 2012

    Posted 17 Mar 2015 Link to this post

    Hi,

    I have some issues regarding the Radpivotgrid. I use it to show values from an Olap cube.
    First:
    When I select an measure in "All fields" area it should move to "Aggregate fields". But first it is shown in "Row fields". After a click on "Update" it is shown in "Aggregate fields" correctly.

    Second:
    I set ShowFilterHeaderZone="False" ShowColumnHeaderZone="False" ShowRowHeaderZone="False" ShowDataHeaderZone="False".
    For row fields I choose a date hierachy.
    The shown values in the grid look a little bit weird. The expanded row values overlap the Grad total. Is this a style problem?

    Third and least:
    The filter fields header label of configuration panel has a filter symbol with a little whatever on the left side. Is this normal?

    Regards,
    Rayko
  2. Maria Ilieva
    Admin
    Maria Ilieva avatar
    4017 posts

    Posted 20 Mar 2015 Link to this post

    Hi Rayko,

    The described issues are rather strange and I believe specific for your scenario as they could not be replicated in our online demos, even after modify them locally.

    See the demo below:

    http://demos.telerik.com/aspnet-ajax/pivotgrid/examples/olap/defaultcs.aspx

    Therefore it will be best if you can send us the exact RadPivotGrid markup as well as the related code behind. Thus we will be able to revise your code locally and advise you further.

    Regards,
    Maria Ilieva
    Telerik
     

    Check out the Telerik Platform - the only platform that combines a rich set of UI tools with powerful cloud services to develop web, hybrid and native mobile apps.

     
  3. UI for ASP.NET Ajax is Ready for VS 2017
  4. Rayko
    Rayko avatar
    27 posts
    Member since:
    Jul 2012

    Posted 20 Mar 2015 in reply to Maria Ilieva Link to this post

    Hi Maria,

    The behaviour regarding fields move to wrong area occures when no fields are pre-selected for row-fields or aggregate fields etc. The grid has to be empty to reproduce the behavior.
    In the online demo the grid isn't empty initially.
    The issue with overlapping row fields occures when I choose my date hierarchy (year-quarter-month-day). It's a standard time dimension from Olap cube.
    The little point left beside the filter symbol seems to be a problem in the Windows7 skin. In default skin the symbol is ok.

    I reproduced all the issues with a new web application project:

    <%@ Page Language="C#" AutoEventWireup="true" CodeBehind="WebForm1.aspx.cs" Inherits="WebApplication2.WebForm1" %>
    <%@ Register TagPrefix="telerik" Namespace="Telerik.Web.UI" Assembly="Telerik.Web.UI" %>
     
    <!DOCTYPE html>
     
    <head runat="server">
        <title></title>
    </head>
    <body>
        <form id="form1" runat="server">
            <asp:ScriptManager runat="server"></asp:ScriptManager>
        <telerik:RadPivotGrid runat="server" ID="PivotGrid" RowTableLayout="Tabular" EnableConfigurationPanel="True" Skin="Windows7"
                                EnableZoneContextMenu="true" AggregatesPosition="Rows" Width="100%" AllowFiltering="true" AllowSorting="true" AllowPaging="true"
             ShowFilterHeaderZone="False" ShowColumnHeaderZone="False" ShowRowHeaderZone="False" ShowDataHeaderZone="False">
            <PagerStyle AlwaysVisible="true" />
            <OlapSettings ProviderType="Adomd">
                <AdomdConnectionSettings ConnectionString="User ID=xxxx; Password=xxxx; Data Source=https://xxxx/msmdpump.dll;Locale Identifier=1031;" Cube="StandardCube" DataBase="xxxx"></AdomdConnectionSettings>
            </OlapSettings>
            <ConfigurationPanelSettings Position="Left" LayoutType="SideBySide" DefaultDeferedLayoutUpdate="true" EnableFieldsContextMenu="True"
                                        EnableDragDrop="False"  FlattenOlapUncategoriezedFields="True" />
            </telerik:RadPivotGrid>
        </form>
    </body>
    </html>

    I didn't use code-behind.

    Regards,
    Rayko
  5. Angel Petrov
    Admin
    Angel Petrov avatar
    1006 posts

    Posted 25 Mar 2015 Link to this post

    Hi Rayko,

    Regarding the first two reported problems I would kindly like to ask you to open a formal support ticket and provided us with the real pivot configuration(meaning the actual connection string) so we could connect to the cube and observe the abnormalities.

    As for the skin issue I have already logged it in our system. Our front end developers will have the care to investigate it and apply the necessary changes. As a token of gratitude for reporting it I have added Telerik points to your account.

    Regards,
    Angel Petrov
    Telerik
     

    See What's Next in App Development. Register for TelerikNEXT.

     
  6. Rayko
    Rayko avatar
    27 posts
    Member since:
    Jul 2012

    Posted 25 Mar 2015 in reply to Angel Petrov Link to this post

    Hi Angel,

    To give you the real credentials for the cube won't work as the server works in a dev environment which isn't reachable for you. Can't you try my sample code with the Telerik's demo cube?

    Regards,
    Rayko
  7. Angel Petrov
    Admin
    Angel Petrov avatar
    1006 posts

    Posted 30 Mar 2015 Link to this post

    Hi Rayko,

    The first issue regarding the aggregate field being initially set as a row field I was able to reproduce with the following code.

    ASPX:
    <telerik:RadPivotGrid runat="server" ID="PivotGrid" RowTableLayout="Tabular" EnableConfigurationPanel="True" Skin="Windows7"
              EnableZoneContextMenu="true" AggregatesPosition="Rows" Width="100%" AllowFiltering="true" AllowSorting="true" AllowPaging="true"
              ShowFilterHeaderZone="False" ShowColumnHeaderZone="False" ShowRowHeaderZone="False" ShowDataHeaderZone="False">
              <PagerStyle AlwaysVisible="true" />
              <OlapSettings ProviderType="Adomd">
                  <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>
              </OlapSettings>
              <ConfigurationPanelSettings Position="Left" LayoutType="SideBySide" DefaultDeferedLayoutUpdate="true" EnableFieldsContextMenu="True"
                  EnableDragDrop="true" FlattenOlapUncategoriezedFields="True" />
          </telerik:RadPivotGrid>
    After further research it seems that it was previously reported to us and is logged into our system for improvement. I hope that our developers will be able to apply the necessary changes for the next official release.

    As for the overlapping problem I was not able to replicate it using the above code. Could you please run it on your end and check whether you can reproduce it? Additionally please elaborate more on the exact version of the controls used in the application.

    Regards,
    Angel Petrov
    Telerik
     

    See What's Next in App Development. Register for TelerikNEXT.

     
  8. Rayko
    Rayko avatar
    27 posts
    Member since:
    Jul 2012

    Posted 30 Mar 2015 in reply to Angel Petrov Link to this post

    Hi Angel,

    I use version 2015.1.225.40. The overlapping issue is reproducable with your code. I've just replaced the connection string because I can't use your conn string (remote host closed connection).
    The problem occures when I move a expanded hierarchy into row fields and header zones are not shown.

    Regards,
    Rayko
  9. Angel Petrov
    Admin
    Angel Petrov avatar
    1006 posts

    Posted 02 Apr 2015 Link to this post

    Hi Rayko,

    I was not able to reproduce the problem on my end after trying out different configurations. Considering this I recommend opening a formal support ticket and attaching a small runnable sample which illustrates the problem there. That way we will be able to inspect it and try to find the root cause of the issue.

    Regards,
    Angel Petrov
    Telerik
     

    See What's Next in App Development. Register for TelerikNEXT.

     
Back to Top
UI for ASP.NET Ajax is Ready for VS 2017