Hi.
In my Visual Studio solution I use your PivotGrid and PivotFieldList to display a cube: I need to filter all the values in it according to the selected sale point, which is chosen through a combo box. I tried to do it using a Filter, which has been created in the code-behind. My problem is that the user should not be able to edit or delete it in any way. Is there a way to make this filter "blocked", so that the user can't move it? If it isn't, is there a way to filter all the values according to this parameter? I can't use Analysis services roles because there are hundreds of sales point to manage.
This is the code I use:
filtroPV = new XmlaFilterDescription();
filtroPV.MemberName = "[Punti Vendita].[Id]";
OlapSetCondition cond = new OlapSetCondition();
cond.Comparison = Telerik.Pivot.Core.Filtering.SetComparison.Includes;
cond.Items.Add("[Punti Vendita].[Id].&[7300]");
filtroPV.Condition = cond;
filtroPV.SettingsChanged += filtroPV_SettingsChanged;
Thank you in advance,
Riccardo
In my Visual Studio solution I use your PivotGrid and PivotFieldList to display a cube: I need to filter all the values in it according to the selected sale point, which is chosen through a combo box. I tried to do it using a Filter, which has been created in the code-behind. My problem is that the user should not be able to edit or delete it in any way. Is there a way to make this filter "blocked", so that the user can't move it? If it isn't, is there a way to filter all the values according to this parameter? I can't use Analysis services roles because there are hundreds of sales point to manage.
This is the code I use:
filtroPV = new XmlaFilterDescription();
filtroPV.MemberName = "[Punti Vendita].[Id]";
OlapSetCondition cond = new OlapSetCondition();
cond.Comparison = Telerik.Pivot.Core.Filtering.SetComparison.Includes;
cond.Items.Add("[Punti Vendita].[Id].&[7300]");
filtroPV.Condition = cond;
filtroPV.SettingsChanged += filtroPV_SettingsChanged;
Thank you in advance,
Riccardo