Hi

I want to be able to loop and Drill MemberFilters in my Rows/Columns/Filters in my pivotGrid.

This is my code for doing this:

//Rows
for (int i = 0; i < pivotGrid.DataSource.Rows.Count; i++)
{
IFilterViewModel fvm = pivotGrid.DataSource.Rows[i] as IFilterViewModel;
if (fvm != null && fvm.FilterMembers != null)
{
foreach (IFilterMember member in fvm.FilterMembers)
{
DrillIn(fvm, member, FilterTypes.Rows, 4);
}
}
}

But so far i have only been able to get the loaded dimensions in the pivotGrid LayoutLoaded event. In all other Events the Rows Count = 0.

I have tried all the DataSource events like DimensionsLoaded, SchemaLoaded etc but the Rows are empty.

Is there any way that i can read this in a event that fires only once when completed? 

Another Question is:

When setting the Rows Dimension i use these lines: 

XmlaDataSource ds = (XmlaDataSource)this.Resources["xf.Database);

//Fill the datasource with Dimensions.
ds.Rows = DataSourceBase.GenerateInitialItems(rf.Rows);

But if i debug, the Rows are empty. Is there anyway for me to listen to an event that fires when the loading of all rows is complete?

br