Flatdata: different source columns for uniqueName(ID) and caption of a dimension(-attribute)

[Jens]

Dear Telerik team,

is it possible to set 2 different source columns for a single dimension?

Example:
Usually a product category has a name and an ID.
Therefore it has at least to related columns in the category database table: name, ID.
The ID is normally used to select/filter data and the name/caption is used for visualizing it within a grid, chart or other
visual area.

Can those 2 source columns be assigned in the meta data.
To trigger a filter later on - which is able to filter by ID - so not by caption of the category?
We need this to built an own configurator and filter control for the grid.

Thanks a lot
Jens

[Georgi Krustev]

Hello Jens,

The dimension can be mapped to one column source only. In general, the pivotgrid supports only filter by label. If you would like to filter by value, then I will suggest you filter the flat data before passing it to the widget. This will give you the ability to filter the data correctly (not the aggregated values) and then categorize it using the widget cube.

Regards,
Georgi Krustev
Telerik