Hello,

I really appreciate your fast  UI components. Regarding the pivot grid, it looks great and works fine. However, I need to provide the users with ability to drill down on a large hierarchy level. Currently there are some issues that do not allow to achieve that. It would be great, if you consider fixing these issues to provide your customers with the more powerful Pivot Grid.   Please see the issues below.

When a hierarchy is added to the Columns or Rows area, the user is able to expand  it by clicking the  plus icon.  When a non-user-hierarchy is expanded, entire level is loaded. This causes a performance issue in case with large hierarchy levels (for example, Date.Date). Maybe there is no need to  load entire hierarchy level at this time, because all needed information (including level members) exists in the XMLA Command response.

Also when the XmlaDataSource is built using user hierarchy with specified members, entire user hierarchy will be loaded. Please see the example below.

 void MainPage_Loaded(object sender, RoutedEventArgs e)

  {

            XmlaDataSource xmlaDataSource = new XmlaDataSource(new XmlaDataProvider(new XmlaConnection(new XmlaConnectionSettings()

                                                                                                           {

                                                                                                               //TODO: replace with appropriate URL

                                                                                                               ServerUri = new Uri("http://localhost/olap/msmdpump.dll")

                                                                                                           })));

            xmlaDataSource.Database = XmlaDataSource.GenerateInitialDatabase("Adventure Works DW 2008R2");

            xmlaDataSource.Cube = DataSourceBase.GenerateInitialCube("Adventure Works");

            xmlaDataSource.Rows = DataSourceBase.GenerateInitialItems("[Date].[Calendar]{[Date].[Calendar].[Date].&[20071116]}");//This will cause XmlaDataSource to load entire Calendar hierarchy 

            xamPivotGrid.DataSource = xmlaDataSource;

        } 

Thank you,

Alexander

UPD: