I'm specifically looking at Filters in this post.  Is that the correct syntax?  I'm using the following:

Filters

="[Product].[Sub Category Name]{[Product].[Sub Category Name].&[Segment 1]}"

I would expect the pivot data to be filtered by [Product].[Sub Category Name] whose value is "Segment 1".  I get data back, but it's not filtered and the filter control on the xamPivotGrid is not changed either.  And what if I also wanted "Segment 2".  I don't see any examples as to the syntax on the XmlaDataSource reference page.

Thanks.

Hi,

Here are the XAML and code behind syntaxes:

[Code behind]
xmlaDataSource.Filters = DataSourceBase.GenerateInitialItems("[Product].[Sub Category Name]{[Product].[Sub Category Name].&[Segment 1]}");

[XAML]
Filters="[Product].[Sub Category Name]{[Product].[Sub Category Name].&[Segment 1]}"

When the grid is loaded the Product hierarchy should appear in the filter area and in the hierarchy filter tree you have to see that just “Segment 1” member is checked.

Regards.

Plamen.

Thank you.  I see the syntax.  I'm sticking with the XAML, but I'll switch to the code behind later when my custom controls are hooked up.

This is something that I've tried, but when I execute this restriction the AdomdDataProvider (using the Infragistics sample) throws a Null Reference exception when creating the AsyncCompletedEventArgs() in the Completed event.  I'm not using the msmdpump.dll.  I hope I can get this working.  I'm SO close and yet the code provided by Infragistics is throwing that NullReference exception.

The provider works fine when there is no restriction (just the dimension, and handles a second one using a comma), but once I add that restriction it blows up with the NullReference in the call back for the DimensionGroups in the AdomdDataProvider code.  I'm in the debugger and as far as I can tell it's in the constructor because all the other variables are NOT null.  Something in the cube structure is null that is causing this exception.

OnLoadMeasureGroupDimensionsCompleted(

new AsyncCompletedEventArgs(e.Error, e.Cancelled, cube));

Hi,
Now I see that you might pass a wrong member unique name, because the filter part is using the member’s unique name.

Columns="[Sales Territory].[Sales Territory]{[Sales Territory].[Sales Territory].[Country].&[France]}"

That name depends on the pattern that member name follow.

Plamen.

But there is no other hierarchy level between Sub Category Name and Segment 1.  "Segment 1" is a unique value under the "Sub Category Name" level, as long with "Segment 2" and "Online". 

The stack might be helpful:

   at Infragistics.Olap.Xmla.XmlaConnection.GetXmlaSoapWebClient[T]()
   at Infragistics.Olap.Xmla.XmlaDataProvider.LoadMembersAsyncImpl(ICube cube, Object userState, IDictionary`2 restrictions)
   at Infragistics.Olap.Xmla.XmlaDataProvider.LoadMembersAsync(ICube cube, IHierarchy hierarchy)
   at Infragistics.Olap.Xmla.XmlaDataSource.UpdateHierarchiesCollection(AreaItemsCollection hierarchiesCollection)
   at Infragistics.Olap.DataSourceBase.LoadInitialAreaItems()
   at Infragistics.Olap.DataSourceBase.CreateMetadataTree()
   at Infragistics.Olap.DataSourceBase.DataProviderLoadMeasureGroupDimensionsCompleted(Object sender, AsyncCompletedEventArgs e)
   at Infragistics.Olap.DataProviderBase.OnLoadMeasureGroupDimensionsCompleted(AsyncCompletedEventArgs args)
   at NCM.BIVizControls.AdomdDataProvider._client_LoadMeasureGroupDimensionsCompleted(Object sender, LoadMeasureGroupDimensionsCompletedEventArgs e)
   at NCM.BIVizControls.OLAPService.OLAPServiceClient.OnLoadMeasureGroupDimensionsCompleted(Object state)

If I step back a bit and set the Rows property on the xamPivotGrid to:

Rows="[Product].[Sub Category Name]"

This shows up fine and I see measures along with the ability to filter by "Segment 1", "Segment 2", "Online", etc.  These filter attributes are showing up in the built in filtering mechanism.  When I select Segment 1 the control refreshes with only the Segment 1 values.  This is GREAT!

But I'd like to filter this before the user sees this control so I thought I could apply the value in curly braces {see above} ^^^ and this would work.  It looks like the control is attempting to do this, but the AdomdDataProvider (that is part of the Infragistics samples) is blowing up on a Null Reference and I've been trying to track that down.  So the data source is trying to do something different.  If I have the syntax for the filtering incorrect, the the data source just ignores the filtering and I get ALL the values instead of just getting Segment 1.