We have an OLAP cube we want to view with the PivotGrid in an ASP.NET website.
We need to allow different users only to view their own data from the cube with some kind of pre-filter or sub query.
Any help to achieve this would be appreciated.
Thanks in advance
Richard
1 Answer, 1 is accepted
0
Maria Ilieva
Telerik team
answered on 14 May 2015, 07:01 AM
Hi,
Possible approach in your case is to apply initial filter by using the FilterByLabel and FilterByValue methods of the RadPivotGrid in the PreRender event.
RadPivotGrid1.Fields["Total"] as PivotGridAggregateField,
"filter value",
"between filter value");
}
Regards,
Maria Ilieva
Telerik
Do you want to have your say when we set our development plans?
Do you want to know when a feature you care about is added or when a bug fixed?
Explore the
Telerik Feedback Portal
and vote to affect the priority of the items