Filter Values are not restricted

2 posts, 0 answers
  1. Boris
    Boris avatar
    3 posts
    Member since:
    May 2015

    Posted 13 May 2016 Link to this post

    Hello Support,

    Our Analysis Server based on user groups which have different access rights  like Country etc.

    If we add a dimension to the pivot grid, only the allowed values will be displayed.

    Example: German User is only able to the the figures from germany!

    Now, the user want activate a filter on this level "filter --> includes fields" and all available Countries will be displayed.

    Is it possible to reduce the filter option to the allowed countries. This effect belongs to each dimension within the pivot grid.


    Thanks for your support!


  2. Georgi Krustev
    Georgi Krustev avatar
    3747 posts

    Posted 17 May 2016 Link to this post

    Hello Boris,

    The PivotGrid widget is designed to perform different DISCOVER requests in order to get the relevant metadata (dimension labels and etc). For instance, in the "Include fields" case the widget will perform a MDSCHEMA_MEMBERS request with LEVEL_UNIQUE_NAME param to get the dimension root member. On expand it will call MDSCHEMA_MEMBERS with MEMBER_UNIQUE_NAME param. 

    If you would like to restrict the displayed filter data, then you will need to restrict the DISCOVER requests. The widget will call the parameterMap callback with a second argument "discover". You can use that function to send additional authorization params. The other option is to restrict the DISCOVER requests on server side based on the user identity.

    Georgi Krustev
    Join us on our journey to create the world's most complete HTML 5 UI Framework - download Kendo UI now!
Back to Top