I want to implement security in Jasper Analysis. With the help of Domain, I am able to implement row level and column level security. But I would like to achieve it in OLAP Schema.
For Example :- In my DB there are n number of Organization so I want superuser to access all the oranization data, but If Org1 user do login then he should see on Org1 Data and so on. Currently , I have achieved it but i have created different roles for the same, So if i have 10 organization then i have created 10 roles for the same.
Can it be possible with profile attribute or any different method?? Please help.