Filter Values are not restricted

[Boris]

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!

Boris

[Georgi Krustev]

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.

Regards,
Georgi Krustev
Telerik