We have two roles : one for poster and one for bill to and two reports viz poster report and invoice report.
These 2 roles are assigned to one user to view both the reports.
Now, we want to restrict the user with a single value for poster, that means the user should able to view only that poster when he executes the poster report.We also want to restrict bill to in the same way in invoice report.
Now the problem is that this combination work only for a single report. If poster is restricted in the poster report then user can see all the bill to values in the invoice report. we tried so many combinations but unable to get the correct value.
Both the report should work at the same time with the restrictions but it is working for only one report. We also got authorization error when trying to achieve this in one report.
We are in BI 7 and we tried doing these in RSECADMIN. Even we tried with variable. Nothing is working.
Any help to solve this issue will be highly appreciated.