Questions on Line Manager Dashboard Prompt LOV restrictions

User_7PNH1

We are currently looking for a way to utilize the existing Line Manager Dashboard, In that we could see that the prompt LOV values that are displaying is not limited to Manager’s access.

For Example Managers were able to see all the department, Grade, BU’s etc in the LOV, We wanted to restrict the LOV’s with the access considering their sub-ordinates data.

For that we had included the Fact (Measure) Fields in the prompt after adding it “"Workforce Management - Worker Assignment Real Time"."Worker Assignment"."Head Count" s_2” the values are getting restricted using Choice List Values “SQL Results”

Below is how the prompt values looks now

SELECT "Workforce Management - Worker Assignment Real Time"."Legal Employer"."Name" s_1, "Workforce Management - Worker Assignment Real Time"."Worker Assignment"."Head Count" s_2 FROM "Workforce Management - Worker Assignment Real Time" WHERE "Worker"."Person Number" IS NOT NULL

Now the LOV value is restricted based on the access of Line manager.

Now we want to restrict the same prompt based on the other prompt.

For Example: If a manager chooses Sales as the Department the system should restrict the other LOV’s such as Grade or Location to show only the Grade or Location where the employee count is more than 1.

We don’t have the option to Limit Values by Prompt as we are using “SQL Results” as choice List Values.

We tried using Presentation variable but that is showing the right results. And as the dashboard is very big we won’t be able to ensure that the data’s are correct on all the results of the dashboard.