[Solved] Report Filter

[Annie]

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

[Rosen Vladimirov]

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

[Annie]

Hi Rosen,

Thanks.
Is that any plan/timeline for this feature to available in RadPivotGrid for OLAP? On the coming release?

[Rosen Vladimirov]

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

[Travis]

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. 

[Rosen Vladimirov]

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

[Annie]

Hi Telerik,

Is there any expected date for your Q1 2013 release?

Please advice.

[Rosen Vladimirov]

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