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

Report Filter

7 Answers 97 Views
PivotGrid
This is a migrated thread and some comments may be shown as answers.
Annie
Top achievements
Rank 1
Annie asked on 04 Dec 2012, 02:01 AM
RadPivotGrid for OLAP support is a nice control where it give a fast respond. I have try to using this control everything is working fine except I can't perform Report Filter on it, I can't drag and drop the dimension to Report Filter list box.
It is a bug or I have miss out anything?
Below is my xaml code
<UserControl.Resources>
        <pivot:XmlaDataProvider x:Key="DataProvider">
            <pivot:XmlaDataProvider.ConnectionSettings>
                <pivot:XmlaConnectionSettings
                    Cube="Cube"
                    Database="Database"
                    ServerAddress="http://server/olap/msmdpump.dll"/>
            </pivot:XmlaDataProvider.ConnectionSettings>
 
            <pivot:XmlaDataProvider.RowGroupDescriptions>
                <pivot:XmlaGroupDescription MemberName="[Dim Creation Calendar].[Fiscal Year]"/>
                <pivot:XmlaGroupDescription MemberName="[Dim Creation Calendar].[Fiscal Quater]"/>
            </pivot:XmlaDataProvider.RowGroupDescriptions>
 
            <pivot:XmlaDataProvider.ColumnGroupDescriptions>
                <pivot:XmlaGroupDescription MemberName="[Dim Location].[Location]"/>               
            </pivot:XmlaDataProvider.ColumnGroupDescriptions>
             
            <pivot:XmlaDataProvider.AggregateDescriptions>
                <pivot:XmlaAggregateDescription MemberName="[Measures].[No. of Ticket]"/>
            </pivot:XmlaDataProvider.AggregateDescriptions>
        </pivot:XmlaDataProvider>
    </UserControl.Resources>
 
<Grid x:Name="LayoutRoot" Style="{StaticResource LayoutRootGridStyle}">
        <Grid.ColumnDefinitions>
            <ColumnDefinition Width="3*" />
            <ColumnDefinition Width="*" />
        </Grid.ColumnDefinitions>
        <Grid.RowDefinitions>
            <RowDefinition Height="*" />
            <RowDefinition Height="Auto" />
        </Grid.RowDefinitions>
 
        <pivot:RadPivotGrid x:Name="Pivot" Grid.RowSpan="2" DataProvider="{StaticResource DataProvider}" />
        <pivot:RadPivotFieldList x:Name="FieldList" Grid.Column="1" Margin="4 0 0 0" DataProvider="{StaticResource DataProvider}"/>
    </Grid>

Thanks

7 Answers, 1 is accepted

Sort by
0
Rosen Vladimirov
Telerik team
answered on 04 Dec 2012, 06:26 AM
Hi Annie,

With the current release of RadPivotGrid you are not able to use ReportFilter with XmlaDataProvider. You can check our article for more information about XmlaDataProvider.

Thank you for choosing RadPivotGrid. Don't hesitate to contact us if you have any suggestions or concerns.

Kind regards,
Rosen Vladimirov
the Telerik team

Explore the entire Telerik portfolio by downloading Telerik DevCraft Ultimate.

0
Annie
Top achievements
Rank 1
answered on 04 Dec 2012, 08:17 AM
Hi Rosen,

Thanks.
Is that any plan/timeline for this feature to available in RadPivotGrid for OLAP? On the coming release?
0
Rosen Vladimirov
Telerik team
answered on 04 Dec 2012, 08:57 AM
Hi Annie,

Our goal is to do this for the official release (2013 Q1), but I cannot promise you with 100% assurance that it will be ready. Our team is working very hard on all needed features. If you have something else in mind that is really important for you as functionality, feel free to send us feedback - as I said - we are trying to finish all tasks on time, but some of them have higher priority based on our customer needs.

We are always happy to receive feedback from our customers. Thanks again for choosing RadPivotGrid.

Kind regards,
Rosen Vladimirov
the Telerik team

Explore the entire Telerik portfolio by downloading Telerik DevCraft Ultimate.

0
Travis
Top achievements
Rank 1
answered on 15 Jan 2013, 01:31 AM
Hi Telerik -

 It seems as though not having filter ability is a very large block for my dev team.  We need a pivot control that can do this.  When will this feature be released?  I can't understand what other features would be of higher priority than this.  How might we (Microsoft) ask that you increase the priority of this feature so it is indeed released in your 2013 Q1 shipment.  Will it be already?  What date does the 2013 Q1 ship? 

We assumed that this feature was part of the control because the demo itself has the filter box available to drag/drop - though admittedly, we assumed you simply had a bug and that's why it wasn't working on your demo..

Please advise as this is very important for us. 

0
Rosen Vladimirov
Telerik team
answered on 15 Jan 2013, 07:57 AM
Hi Travis,

In our demo application, when you try to drag an item in Report Filter box, nothing will happen (or if you try to drag an item from rows/columns to the filter box, the item will be removed). We have designed it this way just to prevent users to put items in the Report Filter which are not filtering anything with the current release.
Full OLAP support (including sorting, filtering, etc.) is our highest priority feature and I can assure you that with our official release you will be able to use fully functional RadPivotGrid and RadPivotFieldList with OLAP data source.

We are sorry for the inconvenience caused. Don't hesitate to contact us if you have any suggestions or concerns.

Kind regards,
Rosen Vladimirov
the Telerik team

Explore the entire Telerik portfolio by downloading Telerik DevCraft Ultimate.

0
Annie
Top achievements
Rank 1
answered on 07 Feb 2013, 01:08 AM
Hi Telerik,

Is there any expected date for your Q1 2013 release?

Please advice.
0
Rosen Vladimirov
Telerik team
answered on 07 Feb 2013, 08:37 AM
Hi Annie,

The official release is planned for the second part of the February. It should be available for download after 21st of February and RadPivotGrid will have its official release.

Hopefully this helps.

Regards,
Rosen Vladimirov
the Telerik team

Explore the entire Telerik portfolio by downloading Telerik DevCraft Ultimate.

Tags
PivotGrid
Asked by
Annie
Top achievements
Rank 1
Answers by
Rosen Vladimirov
Telerik team
Annie
Top achievements
Rank 1
Travis
Top achievements
Rank 1
Share this question
or