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

2 posts, 0 answers
  1. Jens
    Jens avatar
    12 posts
    Member since:
    Aug 2014

    Posted 10 Oct 2014 Link to this post

    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
  2. Georgi Krustev
    Admin
    Georgi Krustev avatar
    3706 posts

    Posted 13 Oct 2014 Link to this post

    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
     
    Join us on our journey to create the world's most complete HTML 5 UI Framework - download Kendo UI now!
     
  3. Kendo UI is VS 2017 Ready
Back to Top