Cube security – Using CUSTOMDATA and SSAS

I was able to connect to cube using your accelerator. Web app using windows user to connect Cube, who has full access. We want to restrict cube data based on currently logged in user. The security model we chose was to use userid in custom data. (see https://www.wiseowl.co.uk/blog/s2488/customdata.htm or http://aniruddhathengadi.blogspot.com/2013/09/configuring-web-server-for-accessing.html).  
I read your documentation https://www.flexmonster.com/doc/configuring-authentication-process/#!custom-authorization. But its not clear how to implement, if you have any example code that shows custom authorization, that would be great
Thanks for your help

1 answer

Public
Tanya Gryshko Flexmonster April 27, 2018

Hello, Pradeep,
Thank you for writing to us.
Please check this sample on JSFiddle: http://jsfiddle.net/flexmonster/faq275u1/.
Here you can see how customData property is set in the report. customData property can contain your values.
Our suggested approach is the following:
1) Specify customData in your report
2) On the server side, handle cube data restriction based on customData you are getting with each request from the client side
Also, we wanted to make sure that you have seen this MVC project showing how Accelerator should be referred: https://github.com/flexmonster/pivot-accelerator-dll/.
Please let me know in case of further questions.
Regards,
Tanya

Please login or Register to Submit Answer