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
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
0
Hi ,
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
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.
0
Rayko
Top achievements
Rank 1
Rank 1
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:
I didn't use code-behind.
Regards,
Rayko
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
0
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
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.
0
Rayko
Top achievements
Rank 1
Rank 1
answered on 25 Mar 2015, 12:26 PM
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
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
0
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:
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
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>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.
0
Rayko
Top achievements
Rank 1
Rank 1
answered on 30 Mar 2015, 08:58 AM
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
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
0
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
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.