asked on August 23, 2022
Hi, I have a problem with the filters, I have a diferents roles for my users, in the ssas roles I put them the specific role for only see the information that they can see, but we work with reports already did by me (I have full access to the all information and I save the report with dont filter), and when my users select one of them the information that is displayed is like the user has full access data (only in the calculated values, the dimension data works correctly), the role work well on the field select, but when I open the report like a simple user and with and specific role, the user can see the values like he has permission for all the data like me. i dont know if i have to set another configuration in the component, in the proxy, or directly in the role of ssas.
thanks
regards
⋅ August 26, 2022
Hello, Mauel!
Thank you for reaching out to us.
Kindly note that calculated values from SSAS are added to Flexmonster the same way as the dimensions data. So, we think you need to add some configurations directly in the role of SSAS to prefilter calculated data on the cube.
Hope you will find this answer helpful.
Regards,
Solomiia
⋅ August 29, 2022
Hi, thanks for the suggestion, here an example, with this role I only have one "presencia" with the name "Quetzaltenango" but in the total that qty is like the role has all the "presencia" that i manage, i dont know why?, it is like the component take "all" like if I have full access, but really I only have permission for Quetzaltenango. The total of the row is correct, but the general total no. With the configuration that you mentioned is on the xml that I charge to the component or change another configuration in my cube?
Thanks
⋅ August 31, 2022
Hello Manuel,
Thank you for reaching out to us.
We have contacted you via email.
Please check our response there.
Kind regards,
Tetiana
