I have a problem where after I dragged Branch ID into the Row Area and update, the pivotgrid will load for some time and show empty result. Results will show if Branch ID is not dragged into row area.
I have tried the same scenario in Visual Studio 2008 SSAS and it successfully shows the result.
Thanks.
9 Answers, 1 is accepted
I am sorry to say but the provided information is not sufficient for us to determine what causes this problem. Could you please share with us the page contents(markup and code-behind) so we could examine the setup?
Regards,
Angel Petrov
Telerik
Rank 1
Here my code:
<%@ Page Title="Home Page" Language="VB" MasterPageFile="~/Site.Master" AutoEventWireup="false"
CodeFile="Default.aspx.vb" Inherits="_Default" %>
<%@ Register Assembly="Telerik.Web.UI" Namespace="Telerik.Web.UI" TagPrefix="telerik" %>
<asp:Content ID="HeaderContent" runat="server" ContentPlaceHolderID="HeadContent">
</asp:Content>
<asp:Content ID="BodyContent" runat="server" ContentPlaceHolderID="MainContent">
<telerik:RadScriptManager runat="server" ID="RadScriptManager1" />
<telerik:RadPivotGrid AllowSorting="True" ID="RadPivotGrid1"
FieldsPopupSettings-AggregateFieldsMinCount="2" AllowPaging="True"
PageSize="20" runat="server" EnableConfigurationPanel="True" EnableZoneContextMenu="True"
AggregatesPosition="Rows" ResolvedRenderMode="Classic">
<PagerStyle AlwaysVisible="true" />
<OlapSettings ProviderType="Adomd">
<AdomdConnectionSettings Cube="TSBA_Movement"
ConnectionString="Provider=MSOLAP;Data Source=N0903;Initial Catalog=TSBA_Movement;"></AdomdConnectionSettings>
</OlapSettings>
<RowHeaderCellStyle Width="100px" />
<ConfigurationPanelSettings Position="FieldsWindow" LayoutType="OneByFour" DefaultDeferedLayoutUpdate="true" />
<ClientSettings>
<Scrolling AllowVerticalScroll="false" ScrollHeight="600px" />
</ClientSettings>
</telerik:RadPivotGrid>
</asp:Content>
Pretty straightforward but I have no idea why it does not work.
I have simplified my question. I have attached results with and without measurement. With measurement with multiple column fields will results in empty data.
We managed to reproduce the problem on our end. We are currently researching what is causing it and hope to find the root cause soon. I will post additional details regarding the matter in this thread as soon as possible.
Regards,
Angel Petrov
Telerik
Rank 1
We have thoroughly investigated the matter and it seems that there is a problem in the pivot engine. It is already logged into the system and our dev team will do their best to provide a fix for it as soon as possible. You can monitor our progress on the matter from here.
We apologize for any inconvenience this problem may have caused you.
Regards,
Angel Petrov
Telerik
Rank 1
Hi,
I am having the same problem, the pivotgrid show empty result after update.
How can I know is the fix has been provided? or when it will be?
I did click on the link you wrote but i cannot see anything related to the pivotgrid.
Thanks
The RadPivotGrid for ASP.NET AJAX uses the pivot engine of the WPF pivot grid and this is the feedback item logged for the problem when OLAP binding is used and no data is displayed. In order to speed things up I suggest voting for the item thus increasing its priority.
As for the fix I am sorry to say but I can not provide a certain time frame in which it will be available. That said I suggest monitoring the feedback item for progress on the matter.
Regards,
Angel Petrov
Telerik
Rank 1
Unfortunately the mentioned issue is still not fixed in the Pivot engine. I would suggest you to vote and follow the public item below so that you can check its progress in future:
http://feedback.telerik.com/Project/143/Feedback/Details/168231-pivotgrid-outofmemoryexception-is-thrown-when-heavy-grouping-is-performed-and-th
Excuse us for inconvenience this issue may lead.
Regards,
Maria Ilieva
Telerik by Progress