cancel
Showing results for 
Search instead for 
Did you mean: 

Hiding characteristics based on authorization?

ravi_rawat
Participant
0 Kudos

Dear Gurus,

Below is the structure of WAD report which user wants to see .Unfortunately my client operates on WAD 3.X.

He has following requirements.

1. For some users, he wants to hide Employee Group and Sub group based on access.

Is it possible at authorization level?

2. In WAD report, user wants to see Employee Status in colors.If Employee Status eq Permanent then Green and if contract then yellow.

   How can we achieve it in WAD 3.x.

EmployeeEmployee GroupEmployee Sub GroupEmployee StatusSalary

Points will be rewarded for help full answers too.

Thanks,

Ravi Rawat

Accepted Solutions (1)

Accepted Solutions (1)

Loed
Active Contributor
0 Kudos

For question #2, try to put a DUMMY KF in the infoprovider..Then in transformation level, make a routine so that it will have a value of 1 if employee is "PERMANENT" and a value of 2 for "CONTRACTUAL" (you can use any number you want), then use the EXCEPTIONS mentioned by Suman to apply the COLOR..

Regards,

Loed

Answers (2)

Answers (2)

ravi_rawat
Participant
0 Kudos

Thanks for your inputs Suman & Loed.

I will create separate queries for the first issue.This report will go to manager and employee.

I need to create the roles in such a way that employee can see only his own data by single sign on and manager can see only employees reporting  him.

How can we acheive this? Please share some links if any...

Regarding my second question, this can be possible in WAD by using java script. I checked on forums and it has been achieved by some WAD experts. But they did not share the code. I am in touch with web team for the same.

Thanks,

Ravi

Loed
Active Contributor
0 Kudos

If ever you got your requirements please share here what you did.

Thank you!

Loed

ravi_rawat
Participant
0 Kudos

Hi Loed,

Sure..I will post it. But can you please answer my first question? I have re-written the question below

"I will create separate queries for the first issue.This report will go to manager and employee.

I need to create the roles in such a way that employee can see only his own data by single sign on and manager can see only employees reporting  him.

How can we acheive this? "

former_member182470
Active Contributor
0 Kudos

As i told you, you have to assign different roles along with these different queries to them. SO manager will have access according to his role and the query you attach to it. Similarly for employees as well. What is that single sign on you are saying about? This cocncept is not required here, I believe.

former_member182470
Active Contributor
0 Kudos

Hi Ravi,


1. For some users, he wants to hide Employee Group and Sub group based on access.

Is it possible at authorization level?

It's not possible to hide columns by based on Authorizations. Instead you have to create separate queries without Emp Group and Sub Group and assign this query to those respective User roles.


2. In WAD report, user wants to see Employee Status in colors.If Employee Status eq Permanent then Green and if contract then yellow.

   How can we achieve it in WAD 3.x.

You can't format cells with colors in WAD. You can achieve this Analyzer by Format cells, but still to achieve colors dynamically to char cells, you have to try with VBA Macro code. Hope you know Exceptions concept for KFs to highlight with colors.

Regards,

Suman