Filter OlapGrid

[Ryan Schroeder]

I have a olapGrid connected to a cube. I currently have a different dimension for the columns and rows and a measure elements.

How do I filter (not slice) grid results based on other dimensions from a cube?

ex.

Time is the column dimension.
Type(a,b or c) is the row dimension.
cost is the measure.

I want to filter by product. eg. i just want to see the cost for type and time period of a certain product without the product being on either axis.

[Dwaragesh M.B.]

Hi,

Grid values can be filtered based on the following way,

- Filter Grid values based on Measure using FilterElements in OlapReport
- Filter Grid values based on Dimensions using SlicerElements in OlapReport

In your case, you can use Slicer element to filter grid values based on other dimensions.

Please refer the below document for more details regarding filtering,

http://www.syncfusion.com/uploads/redirect.aspx?&team=support&file=Filtering105880521.zip

Thanks
Dwaragesh M.B.