BW Authorization for different users on different Char values
I am in BW 7.0.
How can i set authorization for different users for different values for Char say SALES_REP.
1. Sales rep login in BW portal via BW system ID XYZ and runs a report.
2. In BW there is no relationship maintained between Sales REP value say 12345 and Sales ID XYZ.
3. Say new REP ABC joins company he should restrict to see SALES REP data 23456.
Can I create a single Authorization Object and reassign with different values of Char SALES_REP to different users.
We don't want to create as many authorization objects as the number of Sales Rep.
We have SALES_REP enabled as Authorization enabled don't know how to configure the things for above requirement .
It would be great help for me if steps are shared.