Hello PPilev,

Using the latest 2011.2 controls.  Here is the method in the user control to convert the DataTable to an Ilist for the data selector and pivot grid:

public void SetFlatDatasource(DataTable dt)
{
    DynamicTypeBuilder typeBuilder = new DynamicTypeBuilder
    {
        DynamicAssemblyName = "MyAssembly",
        DynamicTypeName = "Pane"
    };

    IList properties = new List();

    foreach (DataColumn column in dt.Columns)
    {
        DynamicTypePropertyInfo propertyInfo = new DynamicTypePropertyInfo
        {
            PropertyName = column.ColumnName,
            PropertyType = column.DataType
        };
        properties.Add(propertyInfo);
    }

    Type dynamicType = typeBuilder.GenerateType(properties);
    Type listType = typeof(List<>);
    Type genericListType = listType.MakeGenericType(dynamicType);

    IList list = (IList)Activator.CreateInstance(genericListType);

    foreach (DataRow dataRow in dt.Rows)
    {
        object myDynamicInstance = Activator.CreateInstance(dynamicType);

        foreach (DataColumn column in dt.Columns)
        {
            PropertyInfo propertyVal = dynamicType.GetProperty(column.ColumnName);

            if (dataRow[column] != DBNull.Value)
            {
                propertyVal.SetValue(myDynamicInstance, dataRow[column], null);
            }
        }

        list.Add(myDynamicInstance);
    }

    FlatDataSource flatDataSource = new FlatDataSource()
    {
        ItemsSource = list,
        Cube = DataSourceBase.GenerateInitialCube("Pane"),
        // if you know the names of demensions you want to be in rows and columns you can define them here
        Columns = DataSourceBase.GenerateInitialItems("[Columns]"),
        Rows = DataSourceBase.GenerateInitialItems("[Row]"),
        Measures = DataSourceBase.GenerateInitialItems("Value")
    };

    dataSelector.DataSource = flatDataSource;
    pivotGrid.DataSource = flatDataSource;
}

When you say initialization, do you mean the xaml? If yes, how can we post xaml in this forum? I will say it does not contain anything special. AllowCompactLayout is set to True, Height and Width are set to Auto...there is really nothing noteworthy.

Simple question, should this control perform well with a row count of say 2,000 with 8 columns?

Yes, it should work fine with such amount of data. The variety of the data of each column (the distinct count) is important as well because of the count of all possible combinations.

Have you tried to add the area items manually using drag-drop through XamPivotDataSelector, without setting initial area items for rows and columns?

Also the format you using for the initial area items is used in 10.3. Since 11.1 it have to follow this pattern [DimensionName].[HierarchyName]

FlatDataSource flatDataSource = new FlatDataSource()

{

    ItemsSource = list,

    Cube = DataSourceBase.GenerateInitialCube("Pane"),

    // if you know the names of demensions you want to be in rows and columns you can define them here  

    Columns = DataSourceBase.GenerateInitialItems("[Columns].[Columns]"),

    Rows = DataSourceBase.GenerateInitialItems("[Row].[Row]"),

    Measures = DataSourceBase.GenerateInitialItems("Value")

};

Another question is what kind of Panel is the host control where the XamPivotGrid is hosted? Is it a Grid or it is a StackPanel?

Plamen.

The distinct counts are (in order they are added to the row collection) 13, 60, 135, 169. 

Items have to be manually added.  Nothing is in the pivot grid after the data is loaded, not sure if this is to your point regarding the proper pattern?  There are no hierarchies defined, so what would I use in place your highlighted code above?

It is hosted in a Grid. 

Hello Jaime,

Currently we don’t provide an option to separate the topics from a forum thread, still if you want you can post the question as a new topic and I will copy the answer that Mircho provided for you.

Hello Mircho,

Works exactly how I had hoped!  Many thanks.  Unfortunately I did a bad thing and have asked questions within this post not related to the main point of the post.  This is valuable lesson for other users that I fear will remain lost here. 

Is there a way to separate this question and your answer into another post for the benefit of the community?

Thanks again!

Jaime

Hi JaimeZ,

Members count shows you how many hierarchies you have in the row tuple. So this check, r.Tuple.Members.Count == 1, shows that there is only one hierarchy in the row. What i understood is that you want to hide all totals that are aggregating only one item. What i can offer is this one:

 foreach (PivotDataRow r in pivotGrid.DataRows)
            {
                foreach (var member in r.Tuple.Members)
                {
                    if (r.IsTotal & member.ChildCount == 1)
                    {
                        r.IsVisible = false;
                    }
                }
            }

Hope this will resolve the issue.

Regards,

Hello again,

I was not able to achieve the hiding of row totals only when the members being totalled are greater than a count of 1.  This would be a great feature for your pivot grid.  Having row totals only where there is more than one data element to total would mean more data to review on screen and less noise.  I tried the following code but it hides all row totals in the heirarchy being expanded, not just ones where there is only one member to total:

private void pivotGrid_LayoutLoaded(object sender, EventArgs e)
{
    foreach (PivotDataRow r in pivotGrid.DataRows)
    {
        if (r.IsTotal & r.Tuple.Members.Count == 1)
        {
            r.IsVisible = false;
        }
    }
}

It seems that Tuple.Members.Count is always one, which I assume is the root element of each hierarchy being expanded? I was hoping for a way to get a count of what is being totaled, which yet may be possible?

Hello Elena,

Plamen has answers a few secondary questions, so those are issues are solved, however the main topic of this post deals with running out of memory when dragging data items from the xamPivotDataSelector into pivot grid rows.  The data is from a DataTable that is converted into a FlatDataSource.  There is an open support case for this, so maybe it would be good to leave this post open until the issue is resolved via a service release or other solution?

Thank you for the thread link!