This is a migrated thread and some comments may be shown as answers.

Strange pivot behaviour

7 Answers 149 Views

PivotGrid

This is a migrated thread and some comments may be shown as answers.

Rayko asked on 17 Mar 2015, 12:59 PM

aggfields.png

2_rowfields.png

3_filter.png

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

7 Answers, 1 is accepted

answered on 20 Mar 2015, 12:40 PM

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.

answered on 20 Mar 2015, 04:23 PM

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>

<html xmlns="http://www.w3.org/1999/xhtml">

<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

answered on 30 Mar 2015, 08:24 AM

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.